Excel Read and Excel Write Steps Example

Do you have objects, models, libraries, path decorators, textures, symbols, custom API code, documentation, or anything else others might find useful? Please attach it here with a brief description.
Post Reply
gtwirth
Simio Team Member
Posts: 156
Joined: Mon Jun 09, 2008 4:42 pm

Excel Read and Excel Write Steps Example

Post by gtwirth » Wed Dec 19, 2012 4:31 pm

NOTE....Code has been removed from this post. Please use the Excel Read and Excel Write steps that are provided when Simio is installed. There is a ExcelReadWrite simbit. The code is provided in C:\Users\Public\Documents\Simio\Examples\UserExtensions\ExcelReadWrite
Attachments
ExcelReadWrite.zip
(157.6 KiB) Downloaded 941 times
Glen Wirth
Simio LLC

jdoran
Posts: 700
Joined: Tue Dec 06, 2011 6:47 am
Location: Brisbane, QLD

Re: Excel Read and Excel Write Steps Example

Post by jdoran » Sun Dec 23, 2012 5:45 pm

Great addition! If only this were here a few weeks ago, to save us creating our own... then again ours also auto generates a graph of the data.
James Doran
Resident Problem Synthesiser

jdoran
Posts: 700
Joined: Tue Dec 06, 2011 6:47 am
Location: Brisbane, QLD

Re: Excel Read and Excel Write Steps Example

Post by jdoran » Tue Jan 01, 2013 11:16 pm

I finally got around to testing this, and the immediate restriction I see is that you can only use states and not functions.

I.e. TimeNow, or custom math statements.
James Doran
Resident Problem Synthesiser

gtwirth
Simio Team Member
Posts: 156
Joined: Mon Jun 09, 2008 4:42 pm

Re: Excel Read and Excel Write Steps Example

Post by gtwirth » Wed Jan 02, 2013 6:49 am

Good point...We will make an adjustment for the Excel Write and DB Write steps to handle expressions. This way it work work the same way as the Write (text) step.
Glen Wirth
Simio LLC

MEagar
Posts: 341
Joined: Thu Feb 14, 2013 12:56 pm
Location: Australia
Contact:

Re: Excel Read and Excel Write Steps Example

Post by MEagar » Tue Feb 19, 2013 8:05 pm

Hi,

I am getting a file corrupted message when trying to open the model. Is there something I need to run or compile beforehand ?

I am using version 5.

Mark
Mark

www.simutech.com.au

mgragert
Posts: 6
Joined: Mon Jul 15, 2013 3:12 pm

Re: Excel Read and Excel Write Steps Example

Post by mgragert » Fri Aug 23, 2013 9:32 am

Hi,
we would like to write the results of mutiple replications in one excel file (row=run.replicationNumber). We tried to change the excel connect and excel write step but we didn't find a solutuion. Do you have any suggestions for us in order to solve this problem?

Best reg.
Markus Gragert

MEagar
Posts: 341
Joined: Thu Feb 14, 2013 12:56 pm
Location: Australia
Contact:

Re: Excel Read and Excel Write Steps Example

Post by MEagar » Sun Aug 25, 2013 8:16 pm

Ditto, I would also like to know...This is a request that I had requested but still no answer....

CSVs and Macros works....yet its a pain...please support the post under the SI Ideas & Suggestions section...
Mark

www.simutech.com.au

gtwirth
Simio Team Member
Posts: 156
Joined: Mon Jun 09, 2008 4:42 pm

Re: Excel Read and Excel Write Steps Example

Post by gtwirth » Fri Oct 18, 2013 7:47 am

I don't think there is a solution around this. The Excel Write step could be setup to to handle replication number, but you would only be able to run one replication at a time. The same worksheet cannot be opened more than once. The way the Excel Write setup works, it opens the worksheet into memory, writes the data into memory during the replication and saves the worksheet when the replication completes.

I recommend using the DB Write step and a MySQL database. MySQL is easy to setup and free to use. We provide instructions on how to setup it up in the DBReadWrite simbit. With the DBWrite, multiple replications can write to the database simultaneously and all the replication can be written to the same table. Once the experiment completes, you can import the data from the database into excel. In the end, the DB is the quickest way to get all your experiment results into one place.
Glen Wirth
Simio LLC

hugo
Posts: 42
Joined: Fri Feb 24, 2012 1:41 am
Location: South Africa
Contact:

Re: Excel Read and Excel Write Steps Example

Post by hugo » Tue Sep 30, 2014 2:24 am

Hi Glen,

I have been using the DBWrite step in my current model with MySQL.

It works like a charm, but it slows the model down considerably. (Can take almost 50% to 70% more time)

Is there any reason why it is slowing the model down so much? Any work around suggestions?

Thank you and regards,

H

Post Reply