Hi all, a test of mine generates random Excel sheet names to see if my code is robust.
For sheet names containing the character 0x1f (and others in that names), POI can export an Excel workbook without any exception or warning, but the workbook cannot be loaded anymore using WorkbookFactory.create(...) nor opened (or repaired) with Excel (2010) itself. I would expect POI to fail when writing the workbook - had the test case not tried to load a file (e.g., tested the workbook directly), I would not have noticed this behavior. The sheet name is created using XSSFWorkbook.createSheet(String). My system's encoding is UTF-8, my POI version is 3.9. Is this a known issue? Shall I file a bug? Best regards, Robert PS: Yes, I know, this is definitely an edge case. ;)
