Home

How to keep source file format when using query?

%3CLINGO-SUB%20id%3D%22lingo-sub-689219%22%20slang%3D%22en-US%22%3EHow%20to%20keep%20source%20file%20format%20when%20using%20query%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-689219%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20using%20query%2C%20the%20data%20combined%20with%20a%20table%20style%20format.%3C%2FP%3E%3CP%3EI%20want%20to%20keep%20source%20excel%20file%20format%20e.g.%20cell%20color%2C%20cell%20and%20text%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20query%20with%20the%20following%20steps.%20(excel%202016)%3C%2FP%3E%3CP%3ENew%20query%20%26gt%3B%20from%20file%20%26gt%3B%20from%20folder%20%26gt%3B%20combine%20and%20edit.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-689219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-690042%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20keep%20source%20file%20format%20when%20using%20query%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-690042%22%20slang%3D%22en-US%22%3EPower%20Query%20cannot%20capture%20cell%20styles%20sorry%2C%20the%20output%20table%20could%20be%20formatted%20though%3C%2FLINGO-BODY%3E
mocholameow
Occasional Visitor

When using query, the data combined with a table style format.

I want to keep source excel file format e.g. cell color, cell and text format.

 

I am using query with the following steps. (excel 2016)

New query > from file > from folder > combine and edit.

1 Reply
Power Query cannot capture cell styles sorry, the output table could be formatted though
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies