search

Benny- / Yahoo-ticker-symbol-downloader

A web scraper for ticker symbols from yahoo finance
https://pypi.python.org/pypi/Yahoo-ticker-downloader/
Other
250 stars 87 forks source link

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

Open Alberms opened 6 years ago

Alberms commented 6 years ago

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 6 years ago

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

Benny- commented 6 years ago

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 6 years ago

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.