First of all i'm sorry for my bad english :) I have apache POI API in my struts2 webb app and it's works !
However i face problems. I have to read (and | or) generate excel (xls) files. My files have several identical sheets with the same named cell. for example : -Sheet1 have a named cell "MyCell" at $A$12 -Sheet2 have a named cell "MyCell" at $A$40 -Sheet2 have a named cell "MyCell" at $A$14 how i can select my cell with this name ? (like : i want "MyCell" on sheet1 OR sheet2) i try the example given in the apache guide but it return a wrong position (it's return MyCell position of one sheet but not the one i would like). Secondly, when i try to clone a sheet, it works (content and style) but not named cell. I try to write it myself but apache POI doesn't accept to create named cell already existing in the workbook... So how can i create cell name in a specific sheet and not workbook, in excel i just have to write Sheet!MyCellName Thank you for helping me -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Same-named-cells-in-several-sheets-tp5683541.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]
