Import data to excel with password

Question

question

Patryk asked Feb 24, '23 Kavika F answered Feb 28, '23

Import data to excel with password

Is it possible to import and export data from excel protected with a password without having to enter them each time?

Software Version:

FlexSim 22.2.2

code excell pasword

· 2

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Kavika F ♦ commented · Feb 27, 2023 at 09:35 PM

Hey @Patryk, could you please provide some more information? I'm trying to replicate the issue you're running into but am unable to right now. I've tried protecting the workbook, the sheet, and a range, but every time I try to export to an excel sheet from the Excel Interface in FlexSim, it either lets me without trouble or it prompts me telling me I wasn't able to write to the file (without giving me the option to put in a password).

Please provide replication steps so I can better assist you. Thank you!

0 ·

Jason Lightfoot ♦♦ Kavika F ♦ commented · Feb 28, 2023 at 01:19 AM

This is the option from the file menu to protect and encrypt the workbook I believe.

0 ·

Answer 1 · 2023-02-28T18:26:32Z

Kavika F answered Feb 28, '23

I don't think it is possible. The password protection is an Excel feature that FlexSim and its APIs don't account for. Even if you try to do "excelopen" in FlexScript, it will require a password.

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question