We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Unable to Install Python Library "openpyxl" into D3S Analyze

Follow
Avatar
Thomas Wong

Hi,

I'm not sure what the reason was... but there seem to be a error when I try to import the openpyxl (see attached).

Is there a version which I should go to for Python 2.7?

0

Comments

4 comments

Sort by Date Votes
  • Avatar
    Thomas Wong

     

     

    Attached files

    error_openpyxl.PNG

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    When I try installing the package into a Python 2.7.15 environment it installs successfully and can be imported in a Python shell session:

    How did you install the package? I used the following from the cmd line (not within the Python shell):

    python -m pip install openpyxl

     

    0
    Comment actions Permalink
  • Avatar
    Thomas Wong

    Thanks Adrian, got it to work after removing the initial install and reinstalling.

    The reason for using the "openpyxl" lib is to create password-protected xls, xlsx.... 

     

    1. Are there recommended ways to do this, such as other libs?

    2. Will this feature be incorporated in future D3S Releases? I prob heard that we may be able to open password protected excel, not sure about creating one.

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Re. your first point, there aren't really any recommended libraries for creating password-protected Excel files in Analyze. You should check whether the password protection afforded by the openpyxl package meets your security needs - i.e. whether it prevents opening an encrypted file or just preventing editing of a protected file. 

    As an alternative you may want to consider an alternative approach of creating an un-encrypted Excel file and then creating a password-protected ZIP archive that contains the Excel file. This use case was recently discussed in another community forum post:

    https://support.infogix.com/hc/en-us/community/posts/360038476854-Unzip-with-password

     

    Re. your second point, we do have a roadmap candidate item to support reading and writing password-protected Excel files, however it is not a priority for delivery in the short-run.

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post