THANKS! I attach you an OpenXML file format. Bye Roberto ----- Segue Messaggio Originale ----- Da : MSB <[email protected]> A : [email protected] oggetto : Re: Error with a XLS file Data : Fri, 29 May 2009 04:33:44 -0700 (PDT)
> Sorry about that, can you let me know what messages you > are receiving at compile/run time please. > > The real problem I face in helping you out is that I do > not have access to many - indeed to any whilst I am at > work - OpenXML files. So, I will try to put together some > code that should work for both HSSF and XSSF (using the > ss.usermodel interfaces). I can only really test it with a > binary file and will have to ask you to test it against an > OpenXML file yourself. > > Will try to get something to you in an hour or so - work > allowing!! > > > Roberto Santini wrote: > > > > The code tha you post me yesterday doesn't works... > > there is some errors with the dependencies... > > ----- Segue Messaggio Originale ----- > > Da : MSB <[email protected]> > > A : [email protected] > > oggetto : Re: Error with a XLS file > > Data : Thu, 28 May 2009 09:57:40 -0700 (PDT) > > > >> Well that very much depends upon EXACTLY what you want > to >> do. The simplest way to read a file is to do > something >> like the following; > >> > >> import org.apache.poi.xssf.usermodel.*; > >> import java.util.Iterator; > >> > >> Iterator<org.apache.poi.ss.usermodel.Row> rowIterator = > >> null; Iterator<org.apache.poi.ss.usermodel.Cell> > >> cellIterator = null; // > >> // Enter the name and location of your file into the > >> // quotes below. > >> // > >> XSSFWorkbook workbook = new XSSFWorkbook(""); > >> XSSFSheet sheet = null; > >> XSSFRow row = null; > >> XSSFCell cell = null; > >> int numSheets = workbook.getNumberOfSheets(); > >> // For loop to iterate over the sheets in the workbook > >> for(int i = 0; i < numSheets; i++) { > >> sheet = workbook.getSheetAt(i); > >> rowIterator = sheet.iterator(); > >> // While loop to iterate over the rows on the > sheet >> while(rowIterator.hasNext()) { > >> row = rowIterator.next(); > >> cellIterator = row.iterator(); > >> // While loop to iterate over the cells in > the >> row. > >> while(cellIterator.hasNext()) { > >> cell = cellIterator.next(); > >> > >> // And then it all depends what you want > to >> do with the cell. > >> // This will show the contents of the > cell >> as a String > >> System.out.println(cell.getStringValue()) > ; >> > >> } > >> } > >> } > >> > >> Try this code, it will print out the contents of each > cell >> as a String. I do not use the OpenXML version of > Excel so >> cannot test the code, but I am fairly > confident it works. >> Am leaving for home now so will not > be logging on again >> this evening in all likelihood, > good luck and I hope this >> helps. > >> > >> > >> Roberto Santini wrote: > >> > > >> > Thanks for your answer. > >> > The code the i found on the link, is to write a file, > >> > and I need to read a file. > >> > So, can you post me an example?? I have very few time > to >> > finish the application (1, 2 hours) and I haven't > time >> > to read all the docs... :D > >> > > >> > Thanks a lot > >> > Roberto > >> > ----- Segue Messaggio Originale ----- > >> > Da : MSB <[email protected]> > >> > A : [email protected] > >> > oggetto : Re: Error with a XLS file > >> > Data : Thu, 28 May 2009 07:49:44 -0700 (PDT) > >> > > >> >> Hello Roberto, > >> >> > >> >> I have been following your conversation with Fillipo > >> and >> would like to ask a couple of questions please. > >> >> > >> >> In one of your replies, you said; > >> >> > >> >> Hi, I don't know how the file is saved (is > >> automatically >> generated by an ASPX page, with excel > xml >> format) because >> i download it from the web.... > >> >> > >> >> If the file is in the xml format then you do not > want >> to >> be using HSSF to process it but XSSF. HSSF > is >> designed to >> work with the older binary file > format not >> the new OpenXML >> based file format. You > need to change >> the code that you >> have written to use > XSSFWorkbook, >> XSSFSheet, XSSFRow, >> XSSFCell, etc. I > do not think that >> the file's extension >> should be a > problem but you could >> easily change it from >> .xls to > xlsx. >> >> > >> >> If you think that you may need to process both BIFF8 > >> and >> OpenXML (binary and xml) files then you can use > the >> >> techniques described here; > >> >> > >> >> http://poi.apache.org/spreadsheet/converting.html > >> >> > >> >> under the heading; 'New, generic SS Usermodel Code' > >> >> > >> >> Hopefully, that should solve the problem though you > do >> >> need to be aware that Microsoft made an earlier > attempt >> >> with an xml based file format - in Office > 2003. If the >> web >> site has created a file using this > format then POI >> cannot >> open it - at least not as far > as I am aware. >> >> > >> >> > >> >> Roberto Santini wrote: > >> >> > > >> >> > Hi to all, I0m a new ITALIAN member. > >> >> > I've a problem reading an XLS file; this file is > >> >> > automatically generated by an ASPX page. > >> >> > The error I'm getting is: > >> >> > > >> >> > java.io.IOException: Invalid header signature; > read >> >> > 7813033141555149807, expected > -2226271756974174256 >> >> > > >> >> > There is a way to solve or the file is generated > with >> an >> > error so I can't read it? > >> >> > If i try to open the same file with Office, it > run! >> >> > > >> >> > Bye > >> >> > Roberto > >> >> > > >> >> > > >> >> > >> > ---------------------------------------------------------- > >> >> > --------- Roberto Santini >> > > www.lasfidacontinua.it >> >> > > >> >> > MSN: [email protected] > >> >> > Skype: cent89 > >> >> > > >> >> > > >> >> > >> > ---------------------------------------------------------- > >> >> > ----------- To unsubscribe, e-mail: >> > >> > [email protected] For additional commands, > >> >> > e-mail: [email protected] >> > >> >> > > >> >> > >> >> -- > >> >> View this message in context: > >> >> > >> > > >> > > > http://www.nabble.com/Error-with-a-XLS-file-tp23757478p23763310.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] >> >> > > >> > > >> > ---------------------------------------------------------- > >> > --------- Roberto Santini >> > www.lasfidacontinua.it > >> > > >> > MSN: [email protected] > >> > Skype: cent89 > >> > > >> > > >> > ---------------------------------------------------------- > >> > ----------- To unsubscribe, e-mail: >> > > [email protected] For additional commands, > >> > e-mail: [email protected] >> > > >> > > >> > >> -- > >> View this message in context: > >> > > > http://www.nabble.com/Error-with-a-XLS-file-tp23757478p23765811.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] >> > > > > > ---------------------------------------------------------- > > --------- Roberto Santini > > www.lasfidacontinua.it > > > > MSN: [email protected] > > Skype: cent89 > > > > > ---------------------------------------------------------- > > ----------- To unsubscribe, e-mail: > > [email protected] For additional commands, > > e-mail: [email protected] > > > > > > -- > View this message in context: > http://www.nabble.com/Error-with-a-XLS-file-tp23757478p23778360.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] > ------------------------------------------------------------------- Roberto Santini www.lasfidacontinua.it MSN: [email protected] Skype: cent89
dmgg5o5e.xls
Description: MS-Excel spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
