Select method of Worksheet class failed
显示 更早的评论
Come up with error Select method of Worksheet class failed, when try to select a xcel sheet using xlswrite
sheet_source.Select;
Have tried all methods previously mentioned, disabling add ins in xcel, saving the directory in users/public, repairing xcel, closing all xcel instances using taskmanager, changing xslwrite to xlswrite1, giving Admin priveleges to Matlab though this has not solved the problem.
I am using code from reputable author on Github, from an academic pape, that has been validated on Matlab 2017b what I used (also tried on Matlab 2018a), so am stuck for ideas. ("On-demand serum-free media formulations for human hematopoietic cell expansion using a high dimensional search algorithm" by Julie Audet).
2 个评论
Guillaume
2019-11-26
Can you
- attach the problematic excel file. If content is confidential, you can remove the data from the spreadsheets as long as the spreadsheets are still there
- show us the exact xlswrite call that you use
- give us the entire text of the error message you get, without any edit.
Edward Contreras
2019-11-26
编辑：Edward Contreras
2019-11-26
回答（1 个）
Guillaume
2019-11-26
I'm sure the author is vey good at her research but a good programmer she's not. Global variables in every single function, what a nightmare!
I can't see why you'd get an error on line 40. It is probably something specific to your excel installation unfortunately. However, since it appears that the code succesfully loads the excel file and locates the worksheet (otherwise you'd get an error much earlier), you could simply delete the offending line. None of the
sheet_source.Activate; % activate the sheet
sheet_source.Select; % select the sheet
on line 39, 40, 47, 48 do anything useful. The code works exactly the same without these lines.
5 个评论
Edward Contreras
2019-11-28
Image Analyst
2019-11-28
What does this say if you put it before that for loop
whos Factors
whos factorNameList
What is the value for k when it throws the error?
Guillaume
2019-11-28
Which file is that in? It's clearly not in SaveExcelSheet.
On the other hand, the problem is most likely with factorNameList, and factorNameList is a global variable, so good luck findind which function may have messed up. It can be any, that's the problem with global, it's impossible to follow what happens to the variables.
The code has more than 220 global variables defined in main.m!
Edward Contreras
2019-11-28
Guillaume
2019-11-28
Doing a search in all files shows that factornamelist is created in line 15 of saveExcelSheet with:
[~,factorNameList,~] = xlsread(sourcefile,'Reagent Cf',allListRange);
So you'll have to look in the Reagent Cf tab of whichever file sourcefile is and see if it contains at least some text (in whatever range is specified by allListRange).
And since we're editing the code, in GenCocktailList you may as well replace the absurd
switch k
case 1, Factors(k).name = factorNameList{k,1};
case 2, Factors(k).name = factorNameList{k,1};
case 3, Factors(k).name = factorNameList{k,1};
case 4, Factors(k).name = factorNameList{k,1};
case 5, Factors(k).name = factorNameList{k,1};
case 6, Factors(k).name = factorNameList{k,1};
case 7, Factors(k).name = factorNameList{k,1};
case 8, Factors(k).name = factorNameList{k,1};
case 9, Factors(k).name = factorNameList{k,1};
case 10, Factors(k).name = factorNameList{k,1};
case 11, Factors(k).name = factorNameList{k,1};
case 12, Factors(k).name = factorNameList{k,1};
case 13, Factors(k).name = factorNameList{k,1};
case 14, Factors(k).name = factorNameList{k,1};
% case 15, Factors(k).name = factorNameList{k,1};
end
by
if k <= 14
Factors{k}.name = factorNameList{k, 1};
end
which does exactly the same.
类别
在 帮助中心 和 File Exchange 中查找有关 Environment and Settings 的更多信息
产品
2019-11-26
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
