Overwriting a vector to a specific location into CSV file

Hi MATLAB experts,

I have csv file here, and want to overwrite a vector in a specific column 'H' and row '4' ('H4') in the spreadsheet called 'sheet1' (while without deleting other data in the same tab). For example, I have a vector as follows:

m = {'a';'b';'c'}

Please teach me cool stuff!! Thanks for any help you can provide in advance.

Best Regards, Jake

Answer 1

[Abhishek Pandey]

Hi Jake! I understand you want to overwrite a vector in a specific column in a CSV file spreadsheet. You can do this using the xlswrite function.

For example, if you want to write the vector ‘m’ to column ‘H4’ in a spreadsheet called ‘sheet1’, you can use the following code:

xlswrite('sheet1.csv', m, 1, 'H4');

Hope this helps!

- Abhishek

[Jake]

Thank you so much, Abhishek!