Dear All, I have around 1400 xls files with 2 sheets in each file.(with the filenamelike 50005100.xls but without a pattern) Here is what I want to do: 1) delete the first sheet; 2) insert a column with header(ID) and then fill in the column with the file name in the second sheet. then export the file to csv(I know how to do that) I need to do this to all of them one by one. Can anyone help me with this? Million thanks. Az
MATLAB: Multiple import/edit of xls files
importing excel data
Related Question
- How to open an existing Excel file and communicate with it using ActiveX
- How to delete the default sheets Sheet1, Sheet2 and Sheet3 in Excel, when I use XLSWRITE
- How to delete worksheets in the Excel file using MATLAB
- Xlswrite to create file with xlsx extension
- How to create chart objects in Excel from MATLAB 7.8 (R2008a)
Best Answer