Ask Your Question

Revision history [back]

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 sixt column, just type:

sage: L[2][5]

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 sixt sixth column, just type:

sage: L[2][5]