0

I have two different spreadsheets that include grades of project groups of students and another three spreadsheets that include students' ID's with respect to sections.

I want to combine these two different sheets to give individual grades of students near their ID's. I intend to write a script instead of doing it manually. Thus, I'm looking for a good library to use with Ruby or Python. Is there any such library that might work for my purpose?

David Cain
  • 16,484
  • 14
  • 65
  • 75
erogol
  • 13,156
  • 33
  • 101
  • 155
  • What exactly is wrong with this question? I am willing to rewrite it, but for me it ask its question very clearly, so I need to know what would nned to be corrected. – gorn Nov 19 '14 at 00:21

2 Answers2

1

This looks like it's been answered here Python - Reading a spreadsheet

I think saving as .csv and using python's built in .csv support is the best option: http://docs.python.org/library/csv.html

Community
  • 1
  • 1
oathead
  • 452
  • 2
  • 5
1

Python libraries:
* for ODS files you can try: http://simple-odspy.sourceforge.net/
* for Excel files: http://scienceoss.com/read-excel-files-from-python/

oz123
  • 27,559
  • 27
  • 125
  • 187