Thanks Mark B! I'm automation tester and I need to automate the test: to get information from this xml file and compare with something. I can use jdom as tool which can helps me to parse this xml. But POI is easiest lib for navigate by table :)
MSB wrote: > > Hello, > > You have got an Office 2003 xml file there, not an OpenXML file; it is an > early attempt by Microsoft to create an xml based file format for Excel > and it is in that sense a 'valid' Office file format. > > Sadly, POI cannot interpret this file at all and that is why you saw the > exception when you tried to wrap it up in the InputStream and pass it to > WorkbookFactory(s) constructor. You do however have a number of options; > > * You could use Excel itself and manually open and save each file you wish > to convert, as you already have done. > * If you have access to Visual Studio and can write Visual Basic or C# > code then you could use a control that will allow you to control Excel > programmatically. This way you could automate a file conversion process > using Excel itself. Then once the file has been converted wither to the > binary or OpenXML formats, POI can be used to process it. > * If you are running on a stand alone PC on which a copy of Excel is > installed and using the Windows operating system, then you could use OLE > to do something very similar from Java code. As above, POI can be used to > process the file following the conversion. > * If you have access to OpenOffice, it has a rather good API that is > accessible from Java code. You could use it to convert between the file > types for you - it is simply a matter of discovering the correct filter to > use in this case. OpenOffice is good for all except the most complex files > and you should be able to use POI to process the file following > conversion. However, if you choose this route, it may be best to do all of > the work using OpenOffice's UNO api. > * Depending upon what you want to do with the file's contents, you could > create your own parser using core java code and either the SAX or Xerces > parsers. If you simply open the original xml file using a simple text > editor, you can see that the structure is not complex and, if all you wish > to get at is the raw data it contains, this could be your best option. > > Hope that helps, > > Yours > > Mark B > -- View this message in context: http://www.nabble.com/How-to-convert-xml-to-xls-tp23852396p23868139.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
