How to export FlexSim Table to Excel File?

Question

question

Khalid Kayal asked Oct 31, '18 tannerp commented May 28, '20

How to export FlexSim Table to Excel File?

I am trying to utilize the excelexporttable() function to simply export a table from flexsim to an excel file, but it doesn't work with me as it works with excelimporttable() function.

Here's my code:

excelopen (FilePath);

excelsetsheet ("Sheet1");

excelexporttable ("Test" ,1,1,37,1);

excelclose (0);

What am I doing wrong here?

Thanks

Software Version:

FlexSim 18.1.2

excel export

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.

Answer 1 · 2018-10-31T21:59:46Z

Joshua S answered Oct 31, '18 tannerp commented May 28, '20

You need to use

excelclose(1);

to save the data to the file, a 0 closes the connection without saving changes.

· 3

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.

Khalid Kayal commented · Oct 31, 2018 at 10:19 PM

Worked, thanks Joshua

0 ·

asb.p commented · May 28, 2020 at 05:59 PM

Hello Joshua,

How to get column headers also included in the export?

Thanks,

Praneeth Akondi

0 ·

tannerp asb.p commented · May 28, 2020 at 06:50 PM

@asb.praneeth,

You might have better luck asking a new question so that more people can see it. This question is rather old and many users will not see your comment here. To try and answer your question, however, I would recommend testing different numbers of starting rows and columns (the second and third parameters in the excelexporttable command). If that doesn't work, you can use an exporttable command separate from Excel and put 1 in both the third and fourth parameters to indicate the use of the row and column headers. This will save a CSV file with all the information you need that you can open in Excel.

0 ·

export-table-help.png (10.7 KiB)

question