Excel's named range through Matlab

13 次查看（过去 30 天）
GSM
GSM 2012-2-1
评论： Aitor Vitoria 2016-5-16
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 个评论
Braden
Braden 2014-1-8
I have the same question. I cannot find anything in the help menu. Any help would be much appreciated.
Image Analyst
Image Analyst 2014-1-9
What about the help Friedrich gave?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Friedrich
Friedrich 2014-1-9
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 个评论
Aitor Vitoria
Aitor Vitoria 2016-5-16
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by