Help with exporting tables, as separate tabs, into an Excel Sheet

3 次查看（过去 30 天）

Mahnoor 2023-8-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2006562-help-with-exporting-tables-as-separate-tabs-into-an-excel-sheet

评论： Mahnoor 2023-8-9

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.

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?

Any help would be freatly appreciated. Thankyou.

7 个评论
显示 5更早的评论隐藏 5更早的评论

Mahnoor 2023-8-9

Hello @Stephen23, thankyou for your support, would you please be able to assist with the below.

I have tried the below code for 1 table and seems to be working well but this table displays the Driveshaft Speed data and not the Drivehshaft Torque data.

% Create a cell array to hold your tables

tables = {Total_Drivehsaft_Torque, Driveshaft_Speed}; %{table1, table2, table3}; % Replace with your actual tables

% 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 i = 1:length(tables)

sheetName = ('Total Driveshaft Torque');

sheetNameTwo = ('Total Driveshaft Speed');

writetable(tables{i}, excelFilename, 'Sheet', sheetName, 'Range', 'A1');

end

I am struggling a bit with getting a second table on a second tab for Drivehshaft speed. I have tried a few combinations of code but the same data appears on the second tab of the Excel sheet.

% Create a cell array to hold your tables

tables = {Total_Drivehsaft_Torque, Driveshaft_Speed}; %{table1, table2, table3}; % Replace with your actual tables

% 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 i = 1:length(tables)

sheetName = ('Total Driveshaft Torque');

sheetNameTwo = ('Total Driveshaft Speed');

writetable(tables{i}, excelFilename, 'Sheet', sheetName, 'Range', 'A1');

writetable(tables{i}, excelFilename, 'Sheet', sheetNameTwo, 'Range', 'A1');

end

Stephen23 2023-8-9

编辑：Stephen23 2023-8-9

在 MATLAB Online 中打开

% 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