Java read excel file report Duplicate PageSettingsBlock record (sid=0x29) error

< H1 > question < / H1 >

poi reports an Duplicate PageSettingsBlock record exception when reading the xls file exported by the company"s reporting system.

org.apache.poi.hssf.record.RecordFormatException: Duplicate PageSettingsBlock record (sid=0x29)

    at org.apache.poi.hssf.record.aggregates.PageSettingsBlock.checkNotPresent(PageSettingsBlock.java:224)
    at org.apache.poi.hssf.record.aggregates.PageSettingsBlock.readARecord(PageSettingsBlock.java:189)
    at org.apache.poi.hssf.record.aggregates.PageSettingsBlock.addLateRecords(PageSettingsBlock.java:636)
    at org.apache.poi.hssf.model.InternalSheet.<init>(InternalSheet.java:191)
    at org.apache.poi.hssf.model.InternalSheet.createSheet(InternalSheet.java:127)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:291)
    at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:88)

then save the file as below and you can read it.
Source xls file is not convenient to upload.

Poi excel java

Feb.28,2021

Previous: Did npm pack up and report This is probably not a problem with npm's fault?

Next: Wget 403forbidden?

Java POI implements the excel table drop-down box to select a value, and another cell to automatically fill in the content.
suppose there is item number P1PowerP2and its price 10d20, the first column of the excel table generated by is a drop-down list, the median value of which is P1 or P2, select P1, the first row and the second column automatically populate the price 10 ...

Poi excel java

Mar.23,2021
Java exported Excel to browser timed out
timeout passed to the browser due to slow query speed or large amount of data because the default connection timeout for HTTP requests is 30 seconds, do you have any good methods? POI used by the development package ...

Poi excel java

Aug.11,2021