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

2 vues (au cours des 30 derniers jours)

Saravanakumar le 13 Avr 2023

Réponse apportée : dpb le 13 Avr 2023

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

dpb le 13 Avr 2023

Read the rest of the doc, specifically the <named parameters for spreadsheets only> section, you'll be particularly interested in AutoFitWidth — Automatically adjust column width

true (default) | false

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

En savoir plus sur Spreadsheets dans Help Center et File Exchange

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

Translated by