Create an Excel book instead of open one

Hello All.
I´m facing an issue, I would like to create an Excel book with 5 sheets every sheet will be a Global table data exported from a GUI in FlexSim, this book will contain all the data for analize of the scenario, the idea is to run 5 scenario, and export the data for each scenario. "5" it just for say a number maybe 20 scenarios or more
and I don´t know how to do this.


and the other hand, a little time ago I wrote a Class (DLL) for Excel or Open Office Calc than allow me create and manipulate for exporting data using Excel or Calc, using automation I just need to have Excel or Calc installed.
but I don´t know how to use the DLL in FleXsim.

When I do things like this, I have my model open an empty Excel file that has one or two sheets already in it. I generally call this file OutputTemplate.xls, or something similar. The sheets that already exist are ones that I know I will need. I'll put as many row or column headers in as I can when the workbook is created, and then my model populates it with data.

When my model needs to export to Excel I open this "template" file, write data to it, possibly create new tabs (using the excelcreatesheet() command) and then save it with a new name (either with excelsave() or with excelmacro()).

This approach to Excel output has worked very well for me in a number of projects.

Thanks!, AJ Bobo. I will try this.
I´m trying to figure out how to use my own DLL for exporting data to Excel with FlexSim.
because I want to make something more sophisticate like give format to the rows an columns.

Thanks

I've done cell formatting in two ways, both of which use the excelmacro() command:

1) I'll put code to format specific sheets/cells in VBA functions in my OutputTemplate.xls file. Then I call the VBA functions like this:

excelmacro("RUN(\"ThisWorkbook.FormatTabs\",false) ");

2) I'll run the formatting code directly from my model export code like this:

excelmacro("SELECT(\"r2c1\")");
excelmacro("STYLE(FALSE,TRUE)"); // Make text italic
excelmacro("SELECT(\"r1c1\")");