• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

POI HSSF - Excel question

Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have an XML file generated from a PeopleSoft SQR that has a file extension of .xls. The file isn't truly a Microsoft .xls file and it can get very large depending on the amount of data in the spreadsheet. I wanted to know if it would be possible using the POI HSSF to read this XML based .xls file and resave it as a .xls file. I have tried doing this in Excel by opening my source file and resaving it. It dramatically decreases the file size. I didn't know if anyone was familiar with working with XML based Excel files.

My thinking is I could create a small Java application that would take the name of the file as an argument and simply open the file and resave it with the same file name. This would save it as a Microsoft .xls file, decrease the file size and make the end users a bit happier. Thanks.
Posts: 43011
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
POI handles XLS files (as well as DOC, PPT and some others), but not XML files. Whatever Excel can do with it, POI can't.
What's that smell? Hey, sniff this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!