question

Ryusuke T avatar image
0 Likes"
Ryusuke T asked Joerg Vogel edited

How to properly set Excel range copy to global table

When I select a range of cells in Excel and copy and paste into a global table, values with commas become values without commas.

2024072501.jpg2024072502.png

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.

FlexSim 24.0.4
global tableexcel copy
2024072501.jpg (8.1 KiB)
2024072502.png (1.3 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered Joerg Vogel edited

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.

· 5
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Ryusuke T avatar image Ryusuke T commented ·

@Joerg Vogel ,

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.

2024072503.jpg


0 Likes 0 ·
2024072503.jpg (36.7 KiB)
Joerg Vogel avatar image Joerg Vogel Ryusuke T commented ·

@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:

excel-import-string.jpg

OneCell.xlsx

import_text_excel.fsm

Please adjust directory paths after downloading the files.

0 Likes 0 ·
excel-import-string.jpg (83.0 KiB)
onecell.xlsx (10.0 KiB)
import-text-excel.fsm (25.4 KiB)
Ryusuke T avatar image Ryusuke T Joerg Vogel commented ·

@Joerg Vogel ,

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.

0 Likes 0 ·
Show more comments