Excel's named range through Matlab

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!

[Braden]

I have the same question. I cannot find anything in the help menu. Any help would be much appreciated.

[Image Analyst]

What about the help Friedrich gave?

Answer 1

[Friedrich]

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.

[Aitor Vitoria]

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.