I am using writetable for exporting the workspace variables into excel sheet

1 view (last 30 days)
I have a excel template in which I export the matlab workspace variables
I am using this code --> writematrix(variables_1,'result.xlsx','Sheet',1,'Range','B2');
After extraction the file changes its column width which I fixed earlier as a template

Answers (1)

dpb
dpb on 13 Apr 2023
Read the rest of the doc, specifically the <named parameters for spreadsheets only> section, you'll be particularly interested in AutoFitWidthAutomatically adjust column width
true (default) | false

Tags

Community Treasure Hunt

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

Start Hunting!