When I select a range of cells in Excel and copy and paste into a global table, values with commas become values without commas.
Please tell me how to avoid this.I want to paste the data with the commas still included.
I have confirmed that it is possible to import correctly using the Excel import function, but since it is not possible to import correctly because Excel uses cell merging, I would like to deal with this by copying and pasting by specifying a range.
Thanks in advance.
Import of excel Data is restricted to strings or numbers. Perhaps you must only tell an import condition to import this cell values as a string. Then you can convert the string into a structure of an array in FlexSim.
Thank you for your reply.
I forgot to mention in my post that I do allocate strings in advance in the global table. However, this does not improve the situation.
@Ryusuke T it is an option you can change in import settings in FlexSim. I attach examples. But maybe they don't work in your localization:
Please adjust directory paths after downloading the files.
I have confirmed that the values can be reflected correctly using the import function. As I mentioned in my post, in this case I cannot use the import function, so I would like to deal with it by copying and pasting.
11 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
