Hello community,
to automate my calculations I would like to save results of a spreadsheet calculation as seen below to compute at display the results of further calculations with sagetex.
How could I save the data from a spreadsheet to use them with sagetex?
What for a data-structure/type would you suggest?
From your spreadsheet software, you can export your spreadsheet as a CSV file, then in Sage you can do :
sage: import csv
sage: file = '/path/to/your/file.csv'
sage: reader = csv.reader(open(file))
sage: L = []
sage: for row in reader:
....: L.append(row)
And the contents of your spreadsheet is stored in the list L. To get the entry located at the third row of the sixth column, just type:
sage: L[2][5]
Asked: 2013-05-08 14:54:29 +0100
Seen: 2,462 times
Last updated: May 08 '13
Copyright Sage, 2010. Some rights reserved under creative commons license. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
csv is pretty standard, and Python can import them pretty easily for further Sage/numpy processing, which can then be fed into SageTeX... more specifics of your current workflow would help SageTeX experts help you, of course.