How do you write a .csv file into excel without carrying along the commas with it?
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Here is my code to read and write the .csv file:
%-----------------------------------------------------------------------------------------------------------------------------------------
fileID = fopen(ExPath1);
c = textscan(fileID, '%s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s');
fclose(fileID);
xlswrite('Book.xlsx', [c{:}])
%-------------------------------------------------------------------------------------------------------------------------------------------
The reason why I am reading in the data first is because I would like to alter the data and then save the newly altered data as an excel file.
0 Kommentare
Antworten (1)
Caroline
am 5 Aug. 2013
I think you can use textscan to specify the delimeter. For example:
c = textscan(fileID, '%s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s', 'delimeter', ',');
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!