Thursday, November 10, 2011

Java API To Access Microsoft Excel Format

HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format. HSSF and XSSF provides ways to read spreadsheets create, modify, read and write XLS spreadsheets. They provide: low level structures for those with special needs an eventmodel api for efficient read-only access a full usermodel api for creating, reading and modifying XLS files Please Go to http://poi.apache.org/spreadsheet/index.html

Eclipse upgrading Subversion to 1.7

I found out this morning that the latest round of Eclipse upgrades includes an upgrade of the Subversion client (not sure if it’s Subclipse or Subversive) to use the Subversion 1.7 libraries. Installing this upgrade and using the new Subversion client on your working copy will render the working copy unable to be read by 1.6.x Subversion clients like the command-line svn or Tortoise. The symptom will be a popup, when trying to use e.g. Tortoise on your working copy, that “This working copy appears to have been created by a Subversion client version 1.7 or greater.” IF AND ONLY IF you are experiencing this issue, I have placed the Subversion 1.7.1 command-line and TortoiseSVN installers in J:\WOL\svn_1.7 . If you are a TortoiseSVN user, I suggest one precaution before installing the new version. In Windows Explorer, browse to a Subversion working copy, right-click on a folder and choose “TortoiseSVN -> About”. Check the first line of the Version Information in the popup; it should say something like “TortoiseSVN 1.6.12….”. If the current version is 1.6.9 or less, then after upgrading with the 1.7.1 Tortoise installer, you will need to run the installer again and choose “Repair Install”. If you are already at Tortoise version 1.6.10 or later you don’t need to worry about repairing. Note that IntelliJ IDEA will not support Subversion 1.7 until they release IDEA Version 11, so IDEA users definitely should NOT upgrade their Subversion clients at this time. Make sure You restart the system.

Thursday, November 3, 2011