topic Re: excelcreateworkbook Command Not Working in FlexSim Forum

excelcreateworkbook Command Not Working

arunTTT2P — Sun, 29 Oct 2023 17:37:08 GMT

[ FlexSim 23.2.1 ]

excelcreateworkbook();
excelsetsheet("Sheet1");
excelwritenum(1,1,1);
excelsave("NewWorkBook.xlsx");
excelclose(0);

Hi, On using this script I'm not able to create an Excel workbook with the specified sheet and data.

Regards,

Arun KR

Re: excelcreateworkbook Command Not Working

JordanLJohnson — Mon, 30 Oct 2023 16:27:09 GMT

Looks like the Excel Interface expects paths with windows-style slashes for the file path. So I made a test model (so that modeldir() becomes valid) and then used string.replace() on the slashes:

excelcreateworkbook();
excelsetsheet("Sheet1");
excelwritenum(1,1,1);
excelsave(modeldir().replace("/", "\\", 1) + "NewWorkBook.xlsx");
excelclose(0);

With this change, it seems to work.

I'll add a case to the dev list to improve this in the future.

Re: excelcreateworkbook Command Not Working

jason_lightfoot_adsk — Fri, 03 Nov 2023 11:06:19 GMT

Hi @Arun Kr, was Jordan Johnson'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 comment back to reopen your question.

Re: excelcreateworkbook Command Not Working

Matthew_Gillespie — Tue, 05 Dec 2023 19:21:02 GMT

@Arun Kr This issue is fixed in 23.0.13 and 23.2.3 released today.