I wonder if anybody has advice on file control where i want to actually read in the data from an excel spreadsheet, to my program for analysis. I have written data out to .xls no worries but it always writes the data just down the first column on the sheet, what if i wanted to fill the sheet across five cells then down ten for example.
My main query is with reading the data though, i will be copying and pasting figures into the sheet, nothing fancy, just numbers,
they will be divided into 10 blocks, or maybe ten sheets/files if thats easier.
thanks for any ideas!