Excel's named range through Matlab

11 visualizzazioni (ultimi 30 giorni)
GSM
GSM il 1 Feb 2012
Commentato: Aitor Vitoria il 16 Mag 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 Commenti
Braden
Braden il 8 Gen 2014
I have the same question. I cannot find anything in the help menu. Any help would be much appreciated.
Image Analyst
Image Analyst il 9 Gen 2014
What about the help Friedrich gave?

Accedi per commentare.

Risposta accettata

Friedrich
Friedrich il 9 Gen 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 Commento
Aitor Vitoria
Aitor Vitoria il 16 Mag 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.

Accedi per commentare.

Più risposte (0)

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by