Issue in importing Excel input sheet into flexsim model

Question

question

gilbert jerald asked Jan 25, '18 Jacob Gillespie edited Jan 26, '18

Issue in importing Excel input sheet into flexsim model

Hi,

In the following attached model, I am facing a problem while importing the excel Input data.In my Excel input sheet "Product_Name" details are stored in string format but when i try to import into my flexsim model the "Product_Name" field is imported as Number format. I have used Automatic option to import the excel data from input sheet but even though I am facing this problem.

Note: The key thing which I am expecting is I want to import the format(string or number) as it is used in excel input sheet.

I have attached the sample model and my input sheet(input sheet in zip format) for your reference have a look at it.

sample-model.fsm

input-data.zip

Thank you.

Software Version:

FlexSim 18.0.0

excel importing

image1.png (57.5 KiB)

sample-model.fsm (41.8 KiB)

input-data.zip (6.0 KiB)

· 2

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.

Kari Payton commented · Jan 25, 2018 at 03:33 PM

This doesn't solve the issue but you can hilight the column, right click and assign data as string.

0 ·

gilbert jerald Kari Payton commented · Jan 25, 2018 at 04:00 PM

Thanks for your comment,

yes, you are correct but when I give my build flexsim model to my customer he use to test by importing different input data at that time he is facing this issue and he asks for fixing this issue. so I am expecting to solve this issue through the forum.

0 ·

Answer 1 · 2018-01-25T17:16:27Z

Jacob Gillespie answered Jan 25, '18 Jacob Gillespie edited Jan 26, '18

Did you try using the Values Only (very fast) option?

Here is what it says it does:

All data will be imported as defined by Excel (numbers or strings)

EDIT: @gilbert jerald

The problem is with your Excel sheet. Our Excel importer doesn't get the cell formatting but the actual data that a cell is storing. To make this work correctly you will have to convert that column to Text.

Using Format Cells... doesn't work. This answer from superuser.com is the best way I found:

How do I convert all the cells of an excel sheet to text?

Highlight the numbers and use the Data > Text to Columns command. In Page 1 of the wizard, choose the appropriate type (this will probably be Delimited). In Page 2, remove any column dividers that may have shown up to keep the data in one column. In Page 3, click Text under Column data format to indicate that this column is text.

· 1

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.

gilbert jerald commented · Jan 26, 2018 at 02:51 PM

@Jacob Gillespie

I have tried it out your solution, but the problem remains the same. i am still get the same issue.

0 ·

question