Overwrite an existing excel file (multiple sheets)

2021 12 28
1 个回答
回答已采纳
更新时间：2021 12 29
8 次查看（30 天）

0 个投票

Hi everyone!
I have imported an Excel file with N=20 sheets.
Each sheet contains two coloumns.
I create two cell arrays, Cf, Ci in the figure.
The following figure shows how each cella array is made.
Finally, the following figure shows how each table is made (in particular, Var1 e Var2 of Ci correspond to the 2 coloumn of esch excel sheet).
I would like to:
  • add Var1 and Var2 of Cf to each table of Ci;
  • overwrite the existing excel file with the modified sheets --> each sheet will have two coloumn corresponding to Ci and two coloumns corresponding to Cf.
Do you have any suggestion?
Thank you in advance!

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

Stephen23
Stephen23 2021-12-28
"Do you have any suggestion?"
Do NOT use the variable name DIR, because this will shadow the very important inbuilt DIR function.

请先登录，再进行评论。

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

 采纳的回答

Image Analyst
Image Analyst 2021-12-28

1 个投票

You can call xlswrite() or writetable() one sheet at a time. It should add the new sheets and retain the existing sheets.

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Francesca Danielli
Francesca Danielli 2021-12-28
I've already tried this but I'm trying to add new coloumns to the existing sheets
Image Analyst
Image Analyst 2021-12-28
Then you can specify the 'Range' which can be the upper left Excel cell, like 'C1', along with the sheet name of course.
Francesca Danielli
Francesca Danielli 2021-12-29
I tried :
for k = 1:N_sheet
xlswrite('filename.xlsx',Cf{k},'D1:E1')
end
but I obtained the following error message 'Input data must be a numeric, cell, or logical array.'
--------------------------------------------------------------------------------------------------------------------------------------------
Then, I tried
for k = 1:N_sheet
xlswrite('filename.xlsx',Cf,'D1:E1')
end
but nothing has been written in the Excel file
Francesca Danielli
Francesca Danielli 2021-12-29
SOLVED! I found the error.
Thank you :)

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by