Re: loading multiple file in one spreadsheet

[jcupitt gmail com]

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 <s0978189 sms ed ac uk> 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
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list