search

openplans / openblock

OpenBlock is a web application and RESTful service that allows users to browse and search their local area for "hyper-local news
61 stars 26 forks source link

Support for excel XLSX files #270

Open slinkp opened 12 years ago

slinkp commented 12 years ago

There is a package for csv.dictreader-style access to old Excel files here: ebdata/ebdata/parsing/excel.py And it is used (largely untested) in the spreadsheet scraper (ebdata/scrapers/general/spreadsheet/retrieval.py) and in the admin UI import view (obadmin/obadmin/admin/views.py).

We should add support for new-style xslx files. There's a python library for this: http://www.lexicon.net/sjmachin/README.html but it doesn't provide a DictReader-style interface, so one would have to be created.

slinkp commented 12 years ago

Ticket imported from Trac: http://developer.openblockproject.org/ticket/277 Reported by: slinkp