Help with exporting tables, as separate tabs, into an Excel Sheet
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi, would anyone please be able to assist with this.
I have written several lines of code that generate specific tables. These are the lines of code with their generated tables all in one script.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1453822/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1453827/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1453832/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1453837/image.png)
At at the end, I have written additional code that exports the tables into an Excel sheet but doesnt seem to be working. How can I use the 'writetable' function correctly to export both of these tables as seperate tabs into 1 excel sheet?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1453842/image.png)
Any help would be freatly appreciated. Thankyou.
7 commentaires
Stephen23
le 9 Août 2023
Modifié(e) : Stephen23
le 9 Août 2023
% Create a cell array to hold your tables
tables = { Total_Drivehsaft_Torque , Driveshaft_Speed };
names = {'Total Driveshaft Torque','Total Driveshaft Speed'};
% Specify the filename for the Excel file
excelFilename = 'Excel Export from SRDC_MIDAS_Simulations.xlsx';
% Write each table to a separate sheet in the Excel file
for k = 1:numel(tables)
writetable(tables{k}, excelFilename, 'Sheet',names{k})
end
Réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!