Save Excel worksheet as csv Using com Object
15 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Philip
el 6 de Oct. de 2018
Respondida: Philip
el 6 de Oct. de 2018
I'm trying to save an Excel worksheet as a CSV. Here's my code:
% Connect Matlab to Excel
e = actxGetRunningServer('Excel.Application');
% Select 1st sheet
eSheets = e.ActiveWorkbook.Sheets;
eSheet1 = eSheets.get('Item',1);
eSheet1.Activate
% Save as csv
SaveAs(eSheet1,'C:\myfile.xlsx') % Works - Saves Excel as xlsx
SaveAs(eSheet1,'C:\myfile.csv','xlCSV') % Does not work
I'm going off the documentation here: WorkSheet.SaveAs. It must be a simple formatting issue of how to actually call Excel methods, but I cannot figure out how to save the worksheet as a csv. Any help would be greatly appreciated.
0 comentarios
Respuesta aceptada
Más respuestas (0)
Ver también
Categorías
Más información sobre Use COM Objects in MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!