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')
Best Answer