Will it be possible to use XLSWRITE to write formulas to the excel sheet which would be calculated altomatically when they are written?
36 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I need to create an XLS sheet from MATLAB using the XLSWRITE command. However, I want to export data and the cell formulas to the xls sheet
For example, I might want to write to a cell:
cell F5: =sum(F1:F4)
Would this be possible when I use the XLSWRITE Command?
Respuesta aceptada
MathWorks Support Team
el 27 de Jun. de 2009
You can write formulas to cells as regular strings. Below are some commands that can be used for declaring a cell array and then writing it to Excel.
a={'1','2','=sum(a1,b1)'}
a(2,:)={'4' '5' '=sum(a2,b2)'}
a(3,:)={4, 5 ,'=sum(a3,b3)'}
xlswrite('Book2.xls',a)
0 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!