excelcreateworkbook Command Not Working

Question

question

Arun Kr asked Oct 29, '23 Matthew Gillespie commented Dec 5, '23

excelcreateworkbook Command Not Working

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

Software Version:

FlexSim 23.2.1

excel export

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot ♦♦ commented · Nov 03, 2023 at 11:06 AM

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.

0 ·

Answer 1 · 2023-10-30T16:27:09Z

Jordan Johnson answered Oct 30, '23 Matthew Gillespie commented Dec 5, '23

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.

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Matthew Gillespie ♦♦ commented · Dec 05, 2023 at 07:21 PM

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

0 ·

question