Thanks for your help in advance.
I have datatable initially come from a specific .DAB file. I converted it to .txt file for use by using a software and I open .txt with Excel application to get data from it. On the datatable, I’m trying to do some manipulation (adding data to certain columns and filtering empty rows) and I want to save the output as .txt or .csv with tab being set up as delimiter but I’m facing some issues:
If I get data from .CSV, it will not populate headers when extracted as datatable so error gets thrown when i’m trying to make some modification based on the column name.
If I get data from .XLSX, it will populate headers so I can transform the datable to whatever form i needed as an outcome. But when I write it back to an Excel (.XLSX and .CSV), text alignment will be off and all data table is being stored in the first column.
Can anyone has experienced in a similar situation help me on this? That will be greatly appreciated.