Re: loading multiple file in one spreadsheet

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.


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



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

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]