How can I delete a certain cell area in an Excel table using MATLAB 7.8 (R2009a)?
21 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I would like to delete the existing values in a certain cell area of an Excel table using MATLAB.
Akzeptierte Antwort
MathWorks Support Team
am 27 Jun. 2009
When XLSWRITE is used to write to cells in a spreadsheet, by default it overwrites the existing data in the cells. Thus deleting the existing values in a certain cell area can also be accomplished by writing empty cells.
The following example shows how to use the XLSWRITE command to write an empty cell to a cell area in order to clear the existing values:
xlswrite('test.xls', cell(29, 1), 'Table1', 'A3:A31');
0 Kommentare
Weitere Antworten (0)
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!