- 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.
Select method of Worksheet class failed
5 次查看(过去 30 天)
显示 更早的评论
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
回答(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 个评论
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!