Benny-/Yahoo-ticker-symbol-downloader

TypeError: cell() takes at least 3 arguments (2 given)

Opened this issue · 3 comments

Alberms commented

Hello,

I get this error when exporting:

Exporting stocks symbols
Traceback (most recent call last):
File "C:\Python27\Scripts\YahooTickerDownloader.py", l
main()
File "C:\Python27\Scripts\YahooTickerDownloader.py", l
f.write(data.xlsx)
File "C:\Python27\lib\site-packages\tablib\formats_xl
rt_set
dset_sheet(dataset, ws, freeze_panes=freeze_panes)
File "C:\Python27\lib\site-packages\tablib\formats_xl
t_sheet
cell = ws.cell('%s%s' % (col_idx, row_number))
TypeError: cell() takes at least 3 arguments (2 given)

Any idea?
Thanks a lot

Benny- commented

Please show me the version of the dependencies using pip freeze.

Benny- commented

Problem has been identified and delegated to https://github.com/kennethreitz/tablib/issues/323

For now I might implement a way to switch the export to .xlsx off, or switch it off by default or switch to another library to export to .xlsx.

Benny- commented

A tiny little change in my code. The latest version (2.2.0) of Yahoo-ticker-symbol-downloader should skip over the export function and continue on with the next file formats if one export fails.

While at the moment you still would not get a .xlsx file you won't get a big stack trace in your face. It now also exports the next two file formats (json and yaml). Can you confirm it exports .json and .yaml now?

The export of the xlsx file should be automatically work again once the tablib library resolved their issue.