poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramon F Herrera <ra...@patriot.net>
Subject Re: Trying to edit a spreadsheet using XSSF
Date Wed, 21 Apr 2010 23:40:50 GMT

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message