This is the error message:
----------------------------------------------------------
Exception in thread "main" java.lang.NoClassDefFoundError:
org/openxmlformats/schemas/spreadsheetml/x2006/main/CTDxfs$1
at
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxfs.<clinit>(Unknown
Source)
at
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxfs$Factory.newInstance(Unknown
Source)
at
org.apache.poi.xssf.model.StylesTable.writeTo(StylesTable.java:362)
at
org.apache.poi.xssf.model.StylesTable.commit(StylesTable.java:377)
at
org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:177)
at
org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:181)
at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:214)
at
org.apache.poi.hssf.usermodel.examples.ReadWriteWorkbook.main(ReadWriteWorkbook.java:41)
Caused by: java.lang.ClassNotFoundException:
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDxfs$1
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
... 8 more
Java Result: 1
BUILD SUCCESSFUL (total time: 1 second)
----------------------------------------------------------
TIA,
-Ramon
This is the modified version:
------------------------------------
package org.apache.poi.hssf.usermodel.examples;
import org.apache.poi.xssf.usermodel.*;
import org.apache.poi.ss.usermodel.*;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
/**
* This example demonstrates opening a workbook, modifying
* it and writing the results back out.
* @author Glen Stampoultzis (glens at apache.org)
*/
public class ReadWriteWorkbook {
public static void main(String[] args) throws IOException {
FileInputStream fileIn = null;
FileOutputStream fileOut = null;
XSSFWorkbook wb;
try {
fileIn = new FileInputStream("1-Tab.xlsx");
wb = new XSSFWorkbook(fileIn);
Sheet sheet = wb.getSheetAt(0);
Row row = sheet.getRow(2);
if (row == null)
row = sheet.createRow(2);
Cell cell = row.getCell(3);
if (cell == null)
cell = row.createCell(3);
cell.setCellType(XSSFCell.CELL_TYPE_STRING);
cell.setCellValue("a test");
// Write the output to a file
fileOut = new FileOutputStream("workbookout.xlsx");
wb.write(fileOut); // Crashes here, creating an empty file
} finally {
if (fileOut != null)
fileOut.close();
if (fileIn != null)
fileIn.close();
}
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
