Export arrays of unknown lengths to next available excel column

Question

Shana Hartel 2015-8-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/233294-export-arrays-of-unknown-lengths-to-next-available-excel-column

评论： Shana Hartel 2015-8-13

Hello, I am running a loop such that a new array of size (m,1) or possibly (m,2) is generated. Note, m will vary with each loop. I would like matlab to export that array to excel. When this loop runs again to create another array, I want it to export that new array to the next available column in excel. I don't want it to overwrite the last array I exported. If I use xlswrite, how do I vary the range to be a new column with every loop? Or should I be using a different function? Thanks.

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

请先登录，再进行评论。

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

Answer 1

Varun Bhaskar 2015-8-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/233294-export-arrays-of-unknown-lengths-to-next-available-excel-column#answer_189248

Hello,

Use the File Exchange submission in the following link to retrieve the Excel column index from the column number in each iteration of the for loop:

Excel Column Conversion

Then, you can use the column index to write starting from the first cell in the column using the 'xlswrite' function. It will populate as many rows in each column as the number of data elements to be written.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Shana Hartel 2015-8-13

Thanks Varun! I will have to check this out. I ended up concatenating the cell arrays and exporting that to excel as one output. I just recently learned Matlab can pad cell arrays if you don't preallocate memory. (This was my problem as all my arrays are different sizes and I don't easily know how many rows or columns I need.) Padding the new global array is a bit slower, but it worked. Maybe this Excel Column Conversion will be faster. Thanks again!

请先登录，再进行评论。