How to store a number of arrays in excel file?

Question

nl2605 2013-7-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/82553-how-to-store-a-number-of-arrays-in-excel-file

Hallo Everyone

I am writing data into an excel file. However, the range of the data to be stored keeps changing and I want to change the range in the xlswrite command accordingly. Any ideas what can be done?

For example:

A=data1; % 1 by 12 matrix(present). However, data1 is a matrix whose rows and column numbers keep on changing

xlswrite(filename,A,'sheet1','A1:A12');

I want to change this range 'A1:A12' as the data1 keeps changing.

Thanks a lot.

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

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Vishal Rane 2013-7-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/82553-how-to-store-a-number-of-arrays-in-excel-file#answer_92224

编辑：Vishal Rane 2013-7-19

在 MATLAB Online 中打开

Dim = size(data1); % output is [ m, n]
Range = ['A1:',strrep([char(64+floor(Dim(2)/26)),char(64+rem(Dim(2),26))],'@',''),num2str(Dim(1))] % Range required for data1
xlswrite( filename, data1, 'sheet1', Range);

You will have to put a check for upper and lower limit since excel 10 supports 256 cols and 65536 rows only.

2 个评论
显示无隐藏无

Jan 2013-7-19

编辑：Jan 2013-7-19

char(64+Dim(2)) is a very bad idea. E.g. what happens if Dim(2) is 65 ?!

Vishal Rane 2013-7-19

编辑：Vishal Rane 2013-7-19

oops ! evidently i did'nt think that through !

Answer updated !

请先登录，再进行评论。

Answer 2

nl2605 2013-7-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/82553-how-to-store-a-number-of-arrays-in-excel-file#answer_92225

I used sprintf instead. And its working too. Thanks a lot. Also, isn't there any other method by which we can write all the data being generated into an excel file without worrying about the dimensions?