You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When trying to export an ontology with more than 64,000 classes into an Excel file, ROBOT (v1.9.4) export generated an error "The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook", which I believe is coming from the POI library. I think it is caused by the the CellStyle style = wb.createCellStyle(); call in robot.export.Row.addToWorkbook() which creates a new CellStyle for each row. The export works fine when exporting to text and html.
The text was updated successfully, but these errors were encountered:
Unfortunately, the team is not yet set up for public github forks/PRs. We actually have a couple of simple additions to ROBOT we've developed in house for our own purposes e.g. we want to be able to export-edit-template lossless round trips. We would like to generate PRs for those when we get out act together.
thanks
dlutz2
added a commit
to dlutz2/robot
that referenced
this issue
Sep 9, 2023
When trying to export an ontology with more than 64,000 classes into an Excel file, ROBOT (v1.9.4) export generated an error "The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook", which I believe is coming from the POI library. I think it is caused by the the
CellStyle style = wb.createCellStyle();
call in robot.export.Row.addToWorkbook() which creates a new CellStyle for each row. The export works fine when exporting to text and html.The text was updated successfully, but these errors were encountered: