Excel capture and copy formatting via DataTables

Hi, I am currently using data tables for data manipulation and cleaning from Excel files.

E.g. incomplete rows are deleted, extra columns are handled, rows from various sheets with different columns are added together etc.

The output I currently have is a clean merged table with all the info from valid rows from source Excel files.

Now I want to add extra functionality which preserves the formatting of the source Excel files. What is the best way to do this?

Hi deathfish,

Have you checked the properties of the read range - preserved format ?

Hi, if I preserve the format in Read Range, how will this be stored within the output data table object?

1 Like