How can write multiple Excel sheets into one excel file?

Hi Everyone,

I am stuck with writing multiple Excel sheets into one Excel file. I have 31 sheets contained 1 Excel workbook and successfully imported them with " readtable" function with the help of for loop of of course.

However, when I try to add them horizontally and create a single workbook, it seems impossible. I have just wrote a simple function to do that task as follows:

function sheetss(filename,portion) % I Enter the file name as 'filename.xls' and the portion as 'A2:D1002' to extract only a part of the values.

sheets = sheetnames(filename);

 T = cell(1,31); % preallocation

 for i = 1:31
   
     
   T{i} = readtable(filename,'Sheet', sheets{i},'Range',portion);

 end
    
  table(T{:}); % trying to extract all embedded tables in cell arrays 
  
writetable(T,'Result.xlsx')

Answer 1

[meghannmarie]

I do not know if this is best way, but try this after your for loop:

C = cellfun(@table2cell,T,'UniformOutput',false); % Converts all the tables in the cells to cell arrays
C = [C{:}]; % Horizontally concatonates all the cell arrays into one cell array.
writecell(cells,'Result.xlsx'); %Writes cells to excel

[AHMET TALHA UZUMCU]

Hi,

Thank you so much for this.

I am not sure this was the best way, but it certanly did what I want !