ATTENTIONThis FlexSim Community Forum is read-only. Please post any new questions, ideas, or discussions to our new community (we call it Answers) at https://answers.flexsim.com/. Our new Question & Answer site brings a modern, mobile-friendly interface and more focus on getting answers quickly. There are a few differences between how our new Q&A community works vs. a classic, threaded-conversation-style forum like the one below, so be sure to read our Answers Best Practices. |
flexsim.com |
#1
|
|||
|
|||
Excel Multiple Table Import Problem
I'm having an issue with the way Flexsim is importing Excel data when the the Windows Regional and Language Settings are anything except English (United States). The problem is that with the US setting Excel uses a decimal point to start the decimal part of a number (e.g. 1.32), however, in European countries this same number uses a comma (e.g. 1,32). The behavior in Flexsim is such that when using US settings decimal values are imported correctly but with European setting the decimal part of the number is being truncated. Does anybody have a solution to this issue, I'm sure I'm missing some setting when I'm doing the Import. I've attached a simple Excel file that will demonstrate the problem.
|
#2
|
||||
|
||||
I just tested your little Excel example and in my eyes I can just read the Excel table into a Global Table in Flexsim by just using the Excel Interface and the Single Table Import.
As far as I know most of the issue we had regarding Excel are gone since Flexsim changed the communication from DDE to OLE. I using the current Version 4.32! I will try to attach a screen shot to this post and hope it will work that you can see, that it is working. I read the post again and read that you like to use Multiple Table Import and tried this too and it is working too. So in my case everything is working.
__________________
tom the (A)tom: "We have solved our problems ... now we have to fight the solutions." |
#3
|
|||
|
|||
Thanks for your reply, I'm attaching a screen shot of what I get. The only thing that I see different is the version of Excel unless there is another setting in Flexsim that I'm unaware of (normally I work in English but I support some users who are in Europe)
|
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Data Import | Sung Kim | Q&A | 2 | 07-16-2010 10:41 AM |
how to import excel in source? | qin tian | Q&A | 6 | 01-11-2010 10:58 PM |
Problem with importing Excel data | David Chan | Q&A | 5 | 03-05-2009 01:49 AM |
Can I make a column of a global table to type table? | qin tian | Q&A | 0 | 10-01-2008 09:27 PM |
Problems with Excel-Import | tobias.biemueller | Q&A | 1 | 06-18-2008 06:17 AM |