Hello Everyone,
I am incurring a little problem on execution of following code
filename='myExcelFile.xlsx';myTable = cell2table(Dataset, 'VariableNames', header);writetable(myTable, filename, 'WriteVariableNames', true);
By writing a table to excel, it removes pre 0. I mean it saves 0409 to 409. Is there any way to preserve initial zeros?
Second, can we sort the data in columns as well? For instance, it sorts Text data to flush left and numerical data to flush right. Can we initialize a directon for that?
Any help would be appreciated.
Thank you 🙂
Best Answer