Import Excel Values Only by code

Question

question

Nil Ns asked Jul 30, '24 Przemyslaw Pasich commented Jul 31, '24

Import Excel Values Only by code

Hello,

We are trying to import an Excel file that is located in a network location. The Excel interface returns an error because it does not expect paths that point to a network location and instead interprets it as a relative path.

However, we found that using excelopen we can open the file without problems. But now we want to read it as Values Only (to do it faster) and we don't know how to do that.

We have been testing with excelrangeread, which seems to not be working. It only works with 3 parameters and the table as a string, which is deprecated.

Category Command Reference (flexsim.com)

The example code returns a message that says there are too many parameters.

Even if it works, how can we read with values only?

Thank you in advance.

Software Version:

FlexSim 24.1.1

excel import values only

· 1

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.

Joerg Vogel commented · Jul 31 at 05:34 AM

@Nil Ns, have you considered to assign a drive letter to a network path in your windows system?

0 ·

Answer 1 · 2024-07-31T05:47:10Z

Joerg Vogel answered Jul 31, '24 Przemyslaw Pasich commented Jul 31, '24

I tried my suggested approach and imported data from a network source, that I have assigned before a drive letter for. The import succeeded.

· 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.

Joerg Vogel commented · Jul 31 at 05:55 AM

You can assign a drive letter for a network source by net command on windows system command shell.

0 ·

Przemyslaw Pasich Joerg Vogel commented · Jul 31 at 10:40 AM

Hi Joerg, thanks for the solution - I've just tested it on my setup and it indeed works.
One thing I'm concerned about though is that in a scenario where the model is shared with clients, they all need to have the network location mapped to a drive letter, which can be a logistical challenge. Do you have any ideas for such scenario?

0 ·

question