Excel's named range through Matlab
11 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
GSM
el 1 de Feb. de 2012
Comentada: Aitor Vitoria
el 16 de Mayo de 2016
Hello,
I have an Excel file which uses excel named range (I've gave the named range prior to using Matlab). I use xlsread(file,sheet,'RangeName',mode,customFun) to read the named range which is called - 'RangeName'. Now I would like to create Excel file through Matlab using xlswrite, then to write values to several cells and give them name, meaning give those cells a named range. How do I do that through Matlab?
Thank you!
2 comentarios
Braden
el 8 de En. de 2014
I have the same question. I cannot find anything in the help menu. Any help would be much appreciated.
Respuesta aceptada
Friedrich
el 9 de En. de 2014
Hi,
this is not possible using xlswrite. You have to do that programatically afterwards using COM/ActiveX, e.g.
ex = actxserver('excel.application');
ex.Workbooks.Open(fullfile(pwd,'Mappe1.xlsx'));
ex.Range('A1:C3').Name = 'RangeName';
ex.ActiveWorkbook.Save
ex.Quit
ex.release
So do a xlswrite to write down the data and afterwards create the named ranges.
1 comentario
Aitor Vitoria
el 16 de Mayo de 2016
Hi Friedrich,
thanks for the answer.
with your answer, I tried to write in different ways the Range in Excel but always write in the book. there any way to write the ranges in the Sheets?
as it is seen in the image, How I can write a name on the sheet3?
Thank you.
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import from MATLAB 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!