search

scraperwiki / spreadsheet-upload-tool

A ScraperWiki tool for uploading structured data from a CSV or Excel spreadsheet
3 stars 5 forks source link

TypeError open_workbook() got an unexpected keyword argument 'ragged_rows' #16

Open epireve opened 11 years ago

epireve commented 11 years ago

Unexpected error while structuring and processing uploaded spreadsheet.

The xlsx file : http://d.pr/f/GGXa

drj11 commented 10 years ago

So I had a look at the spreadsheet... when running code/extract.py by hand we get:

{"errorMessage": "Your header row isn't the widest in the table", "errorType": "HeaderWidthError"}

It turns out that most of the rows have 4 columns, but some of them have 5, where the 5th column is an empty string (it comes out in python as u'').

Looking at the spreadsheet in LibreOffice, it looks entirely reasonable.

Is this something messytables will fix?

frabcus commented 10 years ago

As a user, I'd like messytables to even out ragged right hand edges.

I don't think it does yet though.

On Mon, Jul 08, 2013 at 06:12:03AM -0700, David Jones wrote:

So I had a look at the spreadsheet... when running code/extract.py by hand we get:

{"errorMessage": "Your header row isn't the widest in the table", "errorType": "HeaderWidthError"}

It turns out that most of the rows have 4 columns, but some of them have 5, where the 5th column is an empty string (it comes out in python as u'').

Looking at the spreadsheet in LibreOffice, it looks entirely reasonable.

Is this something messytables will fix?

Reply to this email directly or view it on GitHub: https://github.com/scraperwiki/spreadsheet-upload-tool/issues/16#issuecomment-20603966

drj11 commented 10 years ago

So we should remove right-hand blanks in this tool, and submit a pull-request / bug-report in messytables.

pwaller commented 10 years ago

@ehg and I just encountered this.

zarino commented 10 years ago

Me too:

screen shot 2013-09-23 at 12 35 51