'Workbook' object has no attribute 'fullname'

[kmatt]

Simple fix perhaps: 'fullname' -> 'name' (https://github.com/datasaur/xlwings/commit/318d889df2573940372fb461ad8b5595d560b920)

I combined that change with an additional example in database.py, and don't want to combine both into a single PR.

[fzumstein]

What's the error message you're getting with fullname?

[IWillNinja]

I get the same issue when running the database.py example. The error message I get is "AttributeError: 'Workbook' object has no attribute 'fullname' "

[fzumstein]

hm... does the suggested fix 'fullname' -> 'name' help? What version of Python and Excel are you using?

[IWillNinja]

Python version - 2.7.8 :: Anaconda 2.1.0 (32- bit)
Excel 2007.

If I apply the suggested fix I get another error for line 29 of the code. I'm unable to copy the error from the dialog box, but it's along the lines of : " \Anaconda\lib\site-packages\win32com\client\dynamic.py", line 511 in getattr ....... 'Unable to get the Object property of the OLEObject class'

I am trying to replicate this example on my mac using Python 2.7.5 and Excel 2011 and I also get the 'fullname' problem.

[IWillNinja]

Correction getattr

[fzumstein]

Indeed, it's a bug, for now just replace this line: db_file = os.path.join(os.path.dirname(wb.fullname), 'chinook.sqlite') with the path of your database file, i.e. db_file = r'C:\...\chinook.sqlite and you should be good at least to run it.

[fzumstein]

I've troubles converting the HFS path as returned by wb.xl_workbook.properties().get(k.full_name) into POSIX path. This would be needed if the Worbook is created with an xl_workbook object instead of with a fullname.