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

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.

[Stephen23]

As the WRITETABLE documentation explains and shows, you need to precede the sheet name with the option name "Sheet". Here is an example from the WRITETABLE documentation:

writetable(T,'myData.xls','Sheet',1,'Range','B2:F6')
%                         ^^^^^^ you forgot this

This is also exactly what both answers to your earlier question showed/explained:

https://www.mathworks.com/matlabcentral/answers/2005797-how-to-export-a-set-of-tables-to-excel

It is unclear why you removed the "Sheet" option (which won't work).

[Mahnoor]

Hello @Stephen23. thankyou for your response. Do you mean like this below?

% 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 Output for SRDC_MIDAS_Simulations.xlsx'; % Replace with your desired filename

% Write each table to a separate sheet in the Excel file

for i = 1:length(tables)

sheetName = sprintf('Total Driveshaft Torque', 'Driveshaft Speed', i); % Change to your desired sheet names

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

end

[Jon]

Rather than using screenshots, please use the insert code button on the MATLAB Answers Toolbar to include code. That way it is easy to copy and paste code and we can actually using editing tools to look through the code.

[Stephen23]

"Do you mean like this below?"

The WRITETABLE call looks much better. But I doubt that SPRINTF call does anything useful for you:

i = 2;
sheetName = sprintf('Total Driveshaft Torque', 'Driveshaft Speed', i)

sheetName = 'Total Driveshaft Torque'

What is the intent of using SPRINTF?

[Mahnoor]

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]

% 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

[Mahnoor]

Thankyou very very much @Stephen23