No auto complete options show for Openpyxl

[luabud]

From MicrosoftDocs/intellicode#199 by @Blotuxs

Hi

About a month ago Intellicode showed me recommendations for the Openpyxl library in Python. And since a few days ago it does not show all the recommendations (As seen in the image it does not show the Cell recommendation or others).

Try reinstalling Visual Studio Code, Openpyxl, Python and Intellicode but it doesn't work.

Try to delete the Extensions folder and download it again.

Settings:
"python.jediEnabled": false
"python.languageServer": "Microsoft"

I would appreciate any recommendation. Thank, in advance.

Update:

If I dont click on "Enable it and Reload Windows", appear all the suggestions

[MoonBrain1]

Hi,
Did you find a solution to this? I have the same problem.

[ghost]

I had the same problem when I was getting sheet by name sheet = wb["Sheet1"]
but when I accessed the sheet by index like this sheet = wb.worksheets[0] all the suggestions were there

[jakebailey]

I'm not sure this is related to Pylance, if the old "Microsoft" language server setting was being used. Try with pylance enabled, perhaps?

[luabud]

@MoonBrain1 and @84tom, we have recently released a new and more performant language server called Pylance which likely solves these issues you are reporting. You can download Pylance from the marketplace and install it alongside the core Python extension. Would you be able to try it out and let us know if it's working?

[jakebailey]

It's been over a month since we asked for info and added the "waiting for info label"; I'm going to close this. If this is still a problem and you can provide more info, we can reopen this issue.

[ptrobot555]

Any update regarding this issue? I'm using Pylance 2021.5.1 but the issue is still there.

Not working with wb["Sheet1"]

But works with wb.worksheets[0]

[jakebailey]

Thanks. This appears to be a case where we can't infer the type of the result of the index expression; it's likely this library needs to be better stubbed (or have stubs written) to capture what that operator does.

[ptrobot555]

Thanks for the input, @jakebailey. I have installed the openpyxl-stubs and it seems to be working fine now (tested both in Windows 10 and Linux).

$ pip install openpyxl-stubs
https://github.com/MartinThoma/openpyxl-stubs

[jakebailey]

Thanks for that link; we may be able to bundle those stubs like we do a few other stub packages.

[jakebailey]

This issue has been fixed in version 2021.5.3, which we've just released. You can find the changelog here: https://github.com/microsoft/pylance-release/blob/main/CHANGELOG.md#202153-19-may-2021