Excel Format Cells Not Reflecting

[Pablito (Pawel Wozniak)]

I think this might be helpful then:

Force excel to recognize numbers as text when pasting from datatable

Hey folks, the most easy way is to have an empty excel with the name temp.xlsx and set the column formats as required in your output excel. Now simply write range your Data Table in it and rename it. for eg if you want to preserve your first col as text then in temp.xlsx set it as text and when you write the data table to it your format is preserved.