I guess it's easy with Matlab but I couldn't find any solution. Basically I have 67 files in excel, in each of them I have 1 column of numbers I want to copy in a single excel file i.e.:
file01.xls A1:A10 —–> copied in fileX.xls A1:A10
file02.xls A1:A10 —–> copied in fileX.xls B1:B10
file03.xls A1:A10 —–> copied in fileX.xls C1:C10
file03.xls A1:A10 —–> copied in fileX.xls D1:D10
I'm creating a for loop to read from xls files and write in fileX.xls but I don't know how to increment the letters of the range of fileX.xls
Any help?
Stefano
Best Answer