在 afterWorkbookDispose 方法中无法获取 sheet 中的第一行数据

Quick Start, FAQ

Background:

I want to add drop-down boxes to a column, and the index of this column is not fixed. For example, if the column is named "Is a problem?", add drop-down boxes for "Is a problem" and "Not a problem". The current approach is to get the value of the first row of each sheet in the afterWorkbookDispose method of the writeHandler, and then match it. However, when the number of rows in the excel file is too large, sheet.getRow(0) will return null, and the value of the first row cannot be obtained.