Excel Range in specifies Sheet.

3 次查看（过去 30 天）
Aitor Vitoria
Aitor Vitoria 2016-5-17
评论： Rangan M K 2016-5-19
Hi, with the following code in the file xxxx I write a name in the A3 range. This name is saved in the Book Scope (1) and not in the Sheet (2).
ex = actxserver('excel.application');
ex.Workbooks.Open(fullfile(pwd,'XXXXXXX.xlsx'));
ex.Range('A3').Name = 'RangeName';
ex.ActiveWorkbook.Save
ex.Quit
ex.release
I can write the name on a specifies sheet??
Thanks

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

采纳的回答

Rangan M K
Rangan M K 2016-5-17
编辑：Rangan M K 2016-5-17
Hi, Just activating the particular sheet before adding range will solve it.
ex = actxserver('excel.application');
ex.Workbooks.Open(fullfile(pwd,'XXXXXXX.xlsx'));
Sheets = Excel.ActiveWorkBook.Sheets;
Sheet3 = get(Sheets, 'Item', 'Sheet3');
Sheet3.Activate
ex.Range('A3').Name = 'RangeName';
ex.ActiveWorkbook.Save
ex.Quit
ex.release
  2 个评论
Aitor Vitoria
Aitor Vitoria 2016-5-17
Hi Rangan, Thanks but with this code you are writing in the book and I want Write the name in the Sheet3.
Thanks
Rangan M K
Rangan M K 2016-5-19
Hi, Aitor Vitoria It does write in Sheet3. ex = actxserver('excel.application');
ex.Workbooks.Open(fullfile(pwd,'XXXXXXX.xlsx'));-> Open file and get handle
Sheets = Excel.ActiveWorkBook.Sheets; -> Gets hadle of the Sheets
Sheet3 = get(Sheets, 'Item', 'Sheet3');->Get handle of Sheet3
Sheet3.Activate ->Activate sheet3
ex.Range('A3').Name = 'RangeName'; ->Give name to the range
ex.ActiveWorkbook.Save ->Save changes
ex.Quit
ex.release
Hope this is what you wanted

请先登录，再进行评论。

更多回答（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