Overwrite an existing excel file (multiple sheets)
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Francesca Danielli
el 28 de Dic. de 2021
Comentada: Francesca Danielli
el 29 de Dic. de 2021
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.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/846290/image.png)
The following figure shows how each cella array is made.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/846295/image.png)
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).
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/846300/image.png)
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 comentario
Stephen23
el 28 de Dic. de 2021
"Do you have any suggestion?"
Do NOT use the variable name DIR, because this will shadow the very important inbuilt DIR function.
Respuesta aceptada
Image Analyst
el 28 de Dic. de 2021
You can call xlswrite() or writetable() one sheet at a time. It should add the new sheets and retain the existing sheets.
4 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!