Hi everyone,
When i remove a sheet from the workbook,the named cell are not removed.
How can i remove all named cell of one Sheet ?
In my workbook, i have severals sheet with the same named cell name.
For example:
Sheet1 with named cell "MyCell" at $A10
Sheet2 with named cell "MyCell" at $C12
i try to use wb.getNameIndex("Sheet1!$A10") to get the index and then call
wb.removeName()
but it always return -1
i also try with wb.getNameIndex("Sheet1!MyCell") but it doesn't work.
Thank you
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/How-to-delete-named-cell-tp5710624.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]
