Hi,
I am trying to delete the content of Excel sheets I later want to fill with data. See the script window for the code. However, I get an error message that FlexSim is unable to delete Sheet1.
Is this a bug or am I using it the wrong way?
Regards,
Abel
Excel's interface is not displayed for user interaction, but you are using the optional 2nd parameter of exceldeletesheet() which requires the user to confirm the action. Because Excel's interface is not available, you can't confirm, and things freeze up. Here is what is going on in Windows Task Manager:
Even though you can't see Excel, it is waiting for your input, and so nothing happens.
Try removing the optional 2nd parameter from your call to exceldeletesheet(), or try explicitly setting it to 0.
Also, I did see the same error you mentioned the first time I tried your code ("FlexSim is unable to delete Sheet1"). However, after dismissing the error, I started Excel via double-clicking the test.xlsx file. Then after closing Excel (and making sure there were no remaining Excel processes listed in Task Manager) then your code seems to work properly (minus the optional 2nd param discussed above), and I haven't been able to duplicate the problem since.
Let us know what you find.
15 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
