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?