Dear All, the method shift rows always fails for me:
Exception in thread "main" java.lang.RuntimeException: Could not find
'internal references' EXTERNALBOOK
at
org.apache.poi.hssf.model.LinkTable.checkExternSheet(LinkTable.java:433)
at
org.apache.poi.hssf.model.InternalWorkbook.checkExternSheet(InternalWorkbook.java:1796)
at
org.apache.poi.hssf.usermodel.HSSFSheet.shiftRows(HSSFSheet.java:1494)
at
org.apache.poi.hssf.usermodel.HSSFSheet.shiftRows(HSSFSheet.java:1343)
The code is extremely simple:
import java.io.*;
import org.apache.poi.hssf.usermodel.*;
/**
*
* @author are
*/
public class ExcelToolsBug {
public static void main(String[] args) throws FileNotFoundException,
IOException {
String
fileName="/home/are/.manticore/report/fxf_cbn/CNB_01_all.xls";
int rowOffset = 11;
String sheetName = "MBR302";
File file = new File(fileName);
InputStream inputStream = new FileInputStream(file);
final HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
HSSFSheet sheet = workbook.getSheet(sheetName);
for (int r = 0; r < 100; r++) {
sheet.shiftRows(rowOffset+1, sheet.getLastRowNum(), 1,
true, true);
}
}
}
I attached the Excel-File, which reproduces the problem. Please can
anyone help me on that? I do not understand unfortunately the purpose
and the functionality of the method "checkExternSheet".
Thank you and best regards
Andreas
CNB_01_all.xls
Description: MS-Excel spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
