getting excel variable in a loop

1 次查看（过去 30 天）
wesso Dadoyan
wesso Dadoyan 2016-6-27
编辑： Walter Roberson 2016-6-29
Folder=pwd;
d = dir('bhcf*.xlsx');
N_File=numel(d);
e = actxserver ('Excel.Application');
h=waitbar(0,'Progress...');
for o = 1:N_File
waitbar(o/N_File,h);
ExcelWorkbook = e.workbooks.Open(fullfile(Folder,d(o).name));
there is a column called BHCK5481 in each of these excel files where the sheet is called Sheet1. How can I download it? I tried Sheet=ExcelWorkbook.Sheet1.item('BHCK5481'); but it didn't work Any help is appreciated
  3 个评论
显示 1更早的评论
Image Analyst
Image Analyst 2016-6-27
I guess you have a "named range" in each workbook and that range is named BHCK5481. Is that correct? And that range might be in any column, not some fixed column like column #3. Is that correct?

请先登录，再进行评论。

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

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