Continue export to an excel without overwriting

Question

question

Cetim C asked Oct 18, '22 Jason Lightfoot edited Nov 3, '22

Continue export to an excel without overwriting

Hello,
I am carrying out an emulation process and I want to save in a excel the value that the variables have been taking over time. If I do the export every time I reset the model, the data will be overwritten, unless I tell it the row number where I want the export to start. Is there any way, from the flexsim code, to know how many rows the excel already has, and therefore, continue on the next row?

Software Version:

FlexSim 22.2.1

export

· 1

Jacob W2 ♦ commented · Oct 27, 2022 at 04:21 PM

Hi @Cetim C, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 ·

Answer 1 · 2022-10-20T19:37:35Z

Jason Lightfoot answered Oct 20, '22 Jason Lightfoot edited Nov 3, '22

Try this where the row number is your excel export's rank in the list and the numrows is the number of rows you'll have exported each time.

Table exports=Model.find("Tools/ExcelAuto>variables/exporttable")
exports[1]["Start_Row"]+=numrows;

· 8

Cetim C commented · Oct 21, 2022 at 09:08 AM

Thank you for your answer, but I don´t understand you very well. Where would you put that code?

Are "Start_Row" and "numrows" variables?

I did this code in a reset model trigger but it does not work

filas is a global variable

Export.fsm

0 ·

1666347060910.png (4.5 KiB)

export.fsm (25.5 KiB)

Jason Lightfoot ♦ Cetim C commented · Oct 21, 2022 at 01:00 PM

You said you were exporting to Excel so I described how to use that tool.

If you're writing to csv files can't you just write a new file and concatenate the file using a command line operation?

0 ·

Cetim C Jason Lightfoot ♦ commented · Oct 21, 2022 at 02:22 PM

In my real model I am creating a time series and therefore I want the excel to continue on the same sheet.

I have improved the previous model (I think). I have modified the trigger on model reset and I have made the export customized, but it still does not work.

question