Hi Giuseppe, Spreadsheets are not a great way to do large-scale data manipulation and analysis, in my experience.
I do this kind of thing by converting the spreadsheets to CSV (obviously this only works for single-page spreadsheets) then processing with Python or Ruby. You can use gnumeric to convert most spreadsheets to CSV, something like: $ for i in *.xls; do echo "converting $i ..."; ssconvert $i $i.csv; done I analyse the results of proteomic experiments this way and it works well for me. John On 14 October 2013 14:27, Giuseppe <[email protected]> wrote: > Dear All, > > I am working with kind of 1000 files that I would like to load in one single > spreadsheet. I looked up online but no way to get what I want to. I also > checked if there was a way to have it done with Python, but still nothing. I > wonder whether there is a way to load multiple file in just one single > spreadsheet. > > Cheers > > Giuseppe > > -- > Giuseppe Cannone > University of Edinburgh > Darwin Trust > Institute of Structural Molecular Biology > King's Buildings Campus > Darwin Building, Room 521 > Mayfield Road > Edinburgh EH9 3JR > United Kingdom > > > The University of Edinburgh is a charitable body, registered in > Scotland, with registration number SC005336. > > _______________________________________________ > gnumeric-list mailing list > [email protected] > https://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
