topic Re: Language messed up when exporting from Global Table to Excel in FlexSim Forum

Language messed up when exporting from Global Table to Excel

tongsw — Wed, 27 Sep 2017 02:33:19 GMT

I have a question about excel output. When I export from the Global Table of FlexSim17.1.2 to Excel, the language code is messy. Could you tell me how to solve this problem? Thank you!

Re: Language messed up when exporting from Global Table to Excel

joerg_vogel_HsH — Wed, 27 Sep 2017 05:59:00 GMT

I can't reproduce the issue. I tested an export of a small table with german unique characters and different brackets all as strings. But perhaps you have to set the sheet file encoding to UTF-8. A workaround is to export a csv formated text file and import this file with the right encoding.

Maybe you can export the global table as a tree file from the model tree: right mouse button menu>Node > Save Node As... and append the file to your question. Then we are able to import your global table to an empty model and test, which settings are necessary to export the table.

Re: Language messed up when exporting from Global Table to Excel

philboboADSK — Wed, 27 Sep 2017 13:40:07 GMT

Please post an example model and the steps you are performing in order for us to replicate the issue you are seeing.

FlexSim has many ways to export data to Excel. We need more details in order to replicate the issue you are seeing.

Re: Language messed up when exporting from Global Table to Excel

tongsw — Mon, 16 Oct 2017 06:30:38 GMT

After opening the model,click the run button of script to achieve the export of global table.Then open demo1.xlsx in the modeldir(),you will find messys code.

Re: Language messed up when exporting from Global Table to Excel

tongsw — Mon, 16 Oct 2017 06:31:38 GMT

exceloutput.zip

Re: Language messed up when exporting from Global Table to Excel

philboboADSK — Mon, 16 Oct 2017 15:52:47 GMT

Thanks for the example model. I'm able to replicate the issue you are describing using your sample model.

This appears to be a bug. I'll add a case to the dev list.

For now, you could follow Jörg's suggestion to use exporttable() to export each table to a csv file. Then use Excel's "From Text/CSV" Data import feature, which enables you to specify the text encoding, to load the csv files. When you select UTF-8, it loads this table correctly. See the image below:

Re: Language messed up when exporting from Global Table to Excel

tongsw — Tue, 17 Oct 2017 09:51:00 GMT

The problem is solved, thank you very much!