Re: loading multiple file in one spreadsheet
- From: jcupitt gmail com
- To: Giuseppe <s0978189 sms ed ac uk>
- Cc: "gnumeric-list gnome org" <gnumeric-list gnome org>
- Subject: Re: loading multiple file in one spreadsheet
- Date: Mon, 14 Oct 2013 16:22:43 +0100
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
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]