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!
2 个评论
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
2014-1-9
What about the help Friedrich gave?
采纳的回答
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
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
