July 23, 2012

OLE Exception in Eclipse for MSOffice files

If you have got the above error message when you try to open a MS Office file in eclipse, that means your OLE editor is not working in eclipse. When i googled I found that this is a common problem for Excel files. So I suggest to set the Excel files to open in Excel editor instead of OLE editor. So, do the following ;

  1. Go to Eclipse -> Window -> Preference -> General -> Editors -> File Associations

  2. Add the .xls file type (or any other file type you want)

  3. Choose the Excel WorkBook 97-2003 WorkSheet (or any other file editor you want)

  4. Click OK-> OK

  5. Now the .xls file will opens in Ms Excel

July 4, 2012

JDOM Document to String

XMLOutputter outputter = new XMLOutputter(Format.getPrettyFormat());
String scenarioStr = outputter.outputString(jdomDoc);

Reference : http://cafeconleche.org/books/xmljava/chapters/ch14s04.html