"Error: java.sql.SQLException" When exporting database table to excel AnyLogic

Question

I am trying to export a table from AnyLogic's database to an excel file in a parameters variation using this code:

Database myFile = new Database(this, "A DB from Excel", "DataBaseExport.xlsx");
ModelDatabase modelDB = getEngine().getModelDatabase();
modelDB.exportToExternalDB("flowchart_stats_time_in_state_log", myFile.getConnection(), "Sheet 1", true, true);

I am then given this error

With this after

NickA · Accepted Answer · 2022-03-27 17:28:03Z

1

It turns out that the name of the excel sheet "sheet1" is the culprit. Upon removing the "1" and creating matching column names in the excel file, the data is able to be exported.

answered Mar 27, 2022 at 17:28

NickA

4432 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Benjamin · Accepted Answer · 2022-03-27 16:40:08Z

0

Not sure about your issue, but maybe try this instead:

create a database object as below:
Call this code at runtime:

answered Mar 27, 2022 at 16:40

Benjamin

13.2k4 gold badges19 silver badges34 bronze badges

1 Comment

NickA Over a year ago

Unfortunately PLE does not allow Database. But, the problem has been solved.

Collectives™ on Stack Overflow

"Error: java.sql.SQLException" When exporting database table to excel AnyLogic

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related