Write table with UIPUT file

39 views (last 30 days)
Sai Gudlur
Sai Gudlur on 18 Feb 2020
Commented: Sai Gudlur on 18 Feb 2020
Hello,
I am having issues writing a table to a specific sheet in excel. The error i see is "Invalid parameter name: Sheet.". Also pasting part of my code any help is appriciated. Only pasting a part of it as it is huge code filtering a lot of data and i am only having issue when i am trying to write this table to a specific sheet.
Thanks
T2 = table(Text2,Value2,Unit2);
[fname,pname] = uiputfile('*.xls');
writetable(T1,'(pname,fname)','Sheet',1,'Range','A2:end,:');
writetable(T2,'(pname,fname)','Sheet',2,'Range','A2:end,:');

Answers (1)

Jakob B. Nielsen
Jakob B. Nielsen on 18 Feb 2020
Edited: Jakob B. Nielsen on 18 Feb 2020
Try typing this bit in the command window:
>> '(pname,fname)'
ans =
'(pname,fname)'
So your path is a string named (pname,fname) - not your actual path string.
In addition, your range syntax is bad. You have to specify endpoints as specific cell numbers... Although, if you write your entire table, you dont even need to specify end points - just give the start point.
If you dont want to write the entire table, specify which part of the table you want to write, instead of using the spreadsheet corners as constraints, its much more neat.
Here:
writetable(T1,[pname,fname],'Sheet',1,'Range','A2');
writetable(T2,[pname,fname],'Sheet',2,'Range','A2');
  3 Comments
Jakob B. Nielsen
Jakob B. Nielsen on 18 Feb 2020
Odd. I made a dummytable and tried writing it using the exact piece I posted, and it works just fine... Post the relevant script lines again? It seems odd that you get the error.
Sai Gudlur
Sai Gudlur on 18 Feb 2020
It seems strange to me too but made another change seemed redundant to me but worked. Pasting the code below. that worked
[fname,pname] = uiputfile('*.xlsx');
fullfilename2 = fullfile(pname,fname);(added fullfile built in function)
writetable(T1,(fullfilename2),'Sheet',1,'Range','A2');
writetable(T2,(fullfilename2),'Sheet',2,'Range','A2');
Thanks a lot for your it help Jakob.

Sign in to comment.

Products


Release

R2018b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!