Modifying existing excel using jxl

by

jxl is designed for increased read efficiency (since this is the primary use of the API). In order to improve performance, data which relates to output information (eg. all the formatting information such as fonts) is not interpreted when the spreadsheet is read, since this is superfluous when interrogating the raw data values.

However, if we need to modify this spreadsheet a handle to the various write interfaces is needed, which can be obtained using the copy method.

Workbook workbook = Workbook.getWorkbook(new File("myfile.xls"));
WritableWorkbook copy = Workbook.createWorkbook(new File("temp.xls"), workbook);

This copies the information that has already been read in as well as performing the additional processing to interpret the fields that are necessary to for writing spreadsheets. The disadvantage of this read-optimized strategy is that we have two spreadsheets held in memory rather than just one, thus doubling the memory requirements.

But after this, you can do whatever you want. Like:

WritableSheet sheet2 = copy.getSheet(1); 
WritableCell cell = sheet2.getWritableCell(1, 2); 

if (cell.getType() == CellType.LABEL) 
{ 
  Label l = (Label) cell; 
  l.setString("modified cell"); 
}
copy.write(); 
copy.close();
workbook.close();

Note: this is directly taken from Andy Khan’s tutorial page.

More Related Contents:

  1. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  2. get specific data filed from returned object in java
  3. Take a result of two long numbers using an array in Java [closed]
  4. Setting Singleton property value in Firebase Listener
  5. How do you find all subclasses of a given class in Java?
  6. Getting RSA private key from PEM BASE64 Encoded private key file
  7. How can I make Java print quotes, like “Hello”?
  8. Protected in Interfaces
  9. Killing thread after some specified time limit in Java
  10. Why do I need Transaction in Hibernate for read-only operations?
  11. Serializing with Jackson (JSON) – getting “No serializer found”?
  12. Asynchronous IO in Java?
  13. What is the difference between Class.this and this in Java
  14. Java regex: Repeating capturing groups
  15. How to make a JButton in a JTable cell click-able?
  16. dragging a jlabel around the screen
  17. Java FileInputStream ObjectInputStream reaches end of file EOF
  18. BigDecimal – to use new or valueOf
  19. How to convert Java assignment expression to Kotlin
  20. DOM XML Parser Example
  21. how to parse a huge JSON file without loading it in memory
  22. Cannot assign requested address using ServerSocket.socketBind
  23. How to change Swagger-ui URL prefix?
  24. HTTP Status 406. Spring MVC 4.0, jQuery, JSON
  25. How to set SWT button foreground color?
  26. How to specify function types for void (not Void) methods in Java8?
  27. Android – Read Only File System IOException
  28. How to use Scanner to read silently from STDIN in Java?
  29. Generating hashCode() and equals() when creating Java classes using Mojo Jaxb2 maven plugin
  30. UnreachableBrowserException Caused by: java.lang.NullPointerException when “webdriver.firefox.marionette” is used

Leave a Comment