Excelwrite in Custom object

General Simio discussions. THIS IS *NOT* A GOOD PLACE FOR SUPPORT QUESTIONS.
To limit spam this and all Public Forums have very limited ability to attach files. We recommend that support issues and more technical topics be initiated inside one of the Simio Insider (SI) forums below where you can attach your model and see example solutions. See above Welcome forum to join Simio Insiders.

General Simio discussions. THIS IS *NOT* A GOOD PLACE FOR SUPPORT QUESTIONS.
To limit spam this and all Public Forums have very limited ability to attach files. We recommend that support issues and more technical topics be initiated inside one of the Simio Insider (SI) forums below where you can attach your model and see example solutions. See above Welcome forum to join Simio Insiders.

I created a custom object with a process that uses the Excelwrite step. I created a Reference property for the Excel Workbook in the Excelconnect Element as well as a reference property for the Worksheet in the Excel Write step.

The idea is that when I use the custom object in my main model, I can define to which Excel Workbook and Worksheet the data must be written.

The problem I have is that if I have two (or more) custom objects in my main model referencing the same workbook, but different worksheets, the data only gets written to one sheet for one of the custom objects. In other words, the other custom objects' data is not being written down. If I then delete the other worksheets and only try one custom object writing to one worksheet,it works fine.

Should I have the data written down to multiple workbooks or is there a way to have multiple custom objects write to the same workbook on different sheets.

You can accomplish writing to the same workbook but different sheets by doing the following:
1. Create an ExcelConnect on the top Model (not in custom object) and set the Workbook path.
2. On the ExcelWrite step in the custom object, right click "ExcelConnect" and select "Create New Referenced Property" this will add an Element type Reference Property to the Object. Also create a String Reference Property for the ExcelWrite step's WorkSheet property.
3. When you add an instance of the custom object to the top level model, set the Element property to "ExcelConnect1" and the String property to "SheetName"

There seems to be a problem with setting multiple ExcelConnects to the same excel file. I will talk to our Development team about this.

Favorites

About us

Simio Simulation and Scheduling Software is the most advanced solution on the market. With simulation, it is the only software that is fully object oriented with process and objects being defined graphically with no programming. Unlike other scheduling software, Simio allows you to introduce risk into your production schedule with its patented Risk Based Planning and Scheduling. This dual function in Simio not only helps you improve your business performance from a facility design perspective, but also helps you maximize business results by optimizing the use of critical resources and assessing the risk associated with operational decisions. Learn more at simio.com