how to write a matrix to spesific excel row?

Question

Ararat Cetinkaya 2020-2-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504344-how-to-write-a-matrix-to-spesific-excel-row

关闭： MATLAB Answer Bot 2021-8-20

Hi everybody,

I have an 91x1 matrix and ı want to add this matric to excels F (Columns A to E are already full )column. I try to use xlswrite('testset.xls',classval','F1'); code but it deleted the other columns and writes the matrix on A column

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

Giuseppe Inghilterra 2020-2-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/504344-how-to-write-a-matrix-to-spesific-excel-row#answer_414481

Hi,

when you use xlswrite function, if you don't specify "sheet" as input argument, you must write the range in rectangular shape. In your case:

xlswrite(filename,matrix,'F1:F91');

If you want to deepen how to use xlswrite function, you can see: https://it.mathworks.com/help/matlab/ref/xlswrite.html

2 个评论
显示无隐藏无

Ararat Cetinkaya 2020-2-9

if my matrixs lenght is uncertain and its change depend on a loop, can ı wirte this in a loop with just giving a start point ?

Giuseppe Inghilterra 2020-2-10

在 MATLAB Online 中打开

If you don't specify sheet name, you must define xlsrange in rectangular shape. If you write only the starting point as 'F1:F1', only the first matrix entry is written. Instead if you write the column 'F:F', the column F is filled with matrix values and then other values are filled with N/A values.

You can overcome this problem by specifying sheet name:

xlswrite('testset.xlsx',classval','sheetname','F1');

In this way you can indicate only the starting point without taking care of matrix dimension.