Export arrays of unknown lengths to next available excel column

2 次查看（过去 30 天）
Shana Hartel
Shana Hartel 2015-8-11
评论： 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.

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

回答（1 个）

Varun Bhaskar
Varun Bhaskar 2015-8-13
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 个评论
Shana Hartel
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!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by