Exporting Dashboards to Excel

Question

question

Idoia A asked Apr 2, '19 Joshua S commented Apr 19, '19

Exporting Dashboards to Excel

Hello,

I was wondering if it is possible to export several dashboards to one Excel file. For now, I have only been able to use "Export All Dashboards to CSV option", which creates separate files. Is it possible to export the data to specific cells in a specific excel file?

Thank you in advance,

Idoia

Software Version:

FlexSim 19.0.2

export data 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 · 2019-04-03T19:31:24Z

Joshua S answered Apr 3, '19 Joshua S commented Apr 19, '19

To do this you will need to go to each of the templates in your dashboards and install them. This will create a stats collector for them if you do not already have them referencing a stats collector.

Then you can go to the Excel import/export interface, and then create a new export Table for each stats collector you have. Select the same excel workbook for each of them, but set each to a different sheet. Also deselect "Use Column Headers" and then use the sampler to select each stats collector.

pic1.png (10.6 KiB)

pic2.png (16.8 KiB)

· 4

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.

Idoia A commented · Apr 04, 2019 at 12:48 PM

Thanks for the explanation. Unfortunately, I have not been able to see the output of the dashboards in the Excel file. I think it has to do with the format of the stats collectors created. If I export them individually to a CSV file it works, but if I do it using the Excel import/export interface, it doesn't export them and nothing shows in the file. Any idea about what I'm doing wrong?

Thanks.

0 ·

Joshua S Idoia A commented · Apr 05, 2019 at 07:15 PM

Can you upload your model so I we can take a look at it and waht you want exported?

0 ·

Idoia A Joshua S commented · Apr 12, 2019 at 11:23 AM

Sorry for late answer, I attach an example of what I want to do. There are 3 different dashboards that need to be exported to different sheets in the excel file. I installed them into a statistic collector as explained but I haven't been able to export them to Excel.

question