MATLAB: CSV files into separate Excel spreadsheets all within 1 workbook

csv excel workbook

Hello,

I have a large set of CSV files (N=400; all in a single folder) that need to be added as separate sheets into a single Excel Workbook. So far I have written code to open my destination workbook. I am having trouble, however, looping through my directory to open each CSV file. I then need to write each CSV file as a separate sheet in my destination workbook.

Any help would be greatly appreciated, thank you!

Best Answer

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

When you xlswrite() provide either a worksheet name or worksheet number as the third parameter.

Related Solutions

MATLAB: Paste values in excel with MATLAB COM activeX

Use PasteSpecial with an XLPasteType of xlPasteValues (-4163) instead of Paste.

Note: I would recommend against using Active... particularly since you have the references to the original object. With Active... you always run the risk that something else gets activated in between your calls. Instead of

ibs.Activate
Sheets = excel.ActiveWorkBook.Sheets;

simply do

Sheets = ibs.Sheets;  %Since ActiveWorkbook should be ibs.

So anyway:

excel = actxserver('Excel.Application');
excel.Visible = true;
excel.DisplayAlerts = false;
filename = 'C:\Dropbox\Auryn\ESTRATEGIAS\ibs multiactivo2.xlsm';
filename2 = 'C:\Dropbox\Auryn\ESTRATEGIAS\ZEN REAL2.xlsm';
filename3 = 'C:\Dropbox\Auryn\Ordenes\Recommendations2.xlsx';
ibs = excel.Workbooks.Open(filename);
zen = excel.Workbooks.Open(filename2);
rec = excel.Workbooks.Open(filename3);
pause(60)
zen.Save;  %don't need invoke
zen.Close;
ibsheet = ibs.Sheets.Item(5);  %no need for get(...)
ibsheet .Range('B64:W104').Copy;
recsheet = rec.Worksheets.Item('Ordenes');
recsheet.Range('B10').PasteSpecial(-4163);  %-4163 for xlPasteValues

MATLAB: Consolidating multiple Excel workbooks into single workbook

I didn't scrutinize your code but maybe you can mine. I have a generic function I wrote to transfer worksheets from one workbook to another. See the attached m-file.

Best Answer

Related Solutions

MATLAB: Paste values in excel with MATLAB COM activeX

MATLAB: Consolidating multiple Excel workbooks into single workbook

Related Question