topic Re: Problem of exporting to Excel in FlexSim Forum

Problem of exporting to Excel

Jenny12 — Mon, 21 Aug 2023 15:13:33 GMT

[ FlexSim 23.1.3 ]

Hello,

I have question about exporting to Excel. If I export the data from "Statistics Collector" to Excel, there're some garbled characters. But, if the data from "Global Table", the data can be displayed correctly. Is't because the data from "Statistics Collector" cannot be exported in Traditional Chinese?

I have another question about tracker. I link the tracker to the parameters, and set Dashboard Control Value. I drag the tracker to control value when the simulation is stopped, and after the simulation starts, the tracker return to initial positions.

How should I do above two questions?

Thanks in advance!

DataTest.fsm

Re: Problem of exporting to Excel

jason_lightfoot_adsk — Mon, 21 Aug 2023 17:12:22 GMT

As a workaround for the export for now you can change the stats collector to store either the numeric excel value (fractional days since 1900) or the string value. You can convert the date time using the Datetime methods.

Re: Problem of exporting to Excel

Jenny12 — Tue, 22 Aug 2023 02:40:20 GMT

Hi Jason,

Thanks for your quick reply, appreciate!

If the string value is Traditional Chinese, exporting the data from "Statistics Collector" to Excel, the data can't be displayed correctly.There're also some garbled characters.

Datatest_2.fsm

Re: Problem of exporting to Excel

JordanLJohnson — Thu, 31 Aug 2023 18:18:41 GMT

Thank you for reporting this issue. I have added this bug to the dev list. Unfortunately, there's not a straightforward workaround. If it is critical to get the data to Excel, you could change the Statistics Collector (or create a second one) that collects times in Excel format. You can use the convert() command for this.

https://docs.flexsim.com/en/21.1/Reference/CodingInFlexSim/CommandReference/Commands.html#convert

Re: Problem of exporting to Excel

Matthew_Gillespie — Fri, 08 Sep 2023 18:59:19 GMT

@Jenny This issue has been fixed in 23.0.11 and 23.2.1 released today.