search

scraperwiki / spreadsheet-download-tool

A ScraperWiki plugin for downloading data from a box as a CSV or Excel spreadsheet
BSD 2-Clause "Simplified" License
2 stars 1 forks source link

Dates are appearing incorrectly in Excel #29

Open fawkesley opened 11 years ago

fawkesley commented 11 years ago

@IanHopkinson Can you elaborate based on the problems you saw at the training session you ran? I haven't witnessed this yet.

IanHopkinson commented 11 years ago

I believe the problem was that dates in Excel files became numbers when uploaded to ScraperWiki and those numbers were most likely Excel's underlying date representation.

I've just tried downloading a spreadsheet from the original scraper we were looking at today and the dates look OK to me. Start Date and End Date come out ok in Excel for the new scraper

fawkesley commented 11 years ago

OK looks like we can't reproduce at the moment.

Please re-open with an example URL if anyone encounters this again.

frabcus commented 11 years ago

This is based on an example from the customer, and I think has the problem: http://seagrass.goatchurch.org.uk/~francis/tmp/dates.xlsx

However, right now I'm getting this when I try to test it:

Oh no! We received an unexpected error while structuring your spreadsheet: TypeError open_workbook() got an unexpected keyword argument 'ragged_rows'