Bear in ind that I have never needed to perfrom either operation when I say that I do not think thata there is an 'easy' soution to either problem.
Removing a column will be by far the easier operation to perform as all you will need to do is to iterate through all of the rows on the sheet and call the removeCell() method. This method is defined on the org.apache.poi.ss.usermodel.Row interface which HSSFRow and XSSFRow both implement. Adding a column will, I think, be a little more tricky. On the HSSFRow class there is a method called moveCell() which, as it's name suggestes, allows you to move an existing cell from one column to a new one. The only snag with tha method is that the javadoc says the following "Moves the supplied cell to a new column, which must not already have a cell there!". To insert a new column, I am guessing that you will again need to process each row iteratively. Staring with the final cell in the column, you will need to move this to the next column, possibly next to remove it from the column it once occupied and then repeat this process; however, I have never tried this so cannot promise any sort of success. If you are targeting the OpenXML based file format through XSSFRow, then you are likely to be in more trouble beacuse I cannot see any similarly named methods defined on that class. Further, even though XSSFCell allows you to get at the column index of the cell, the setCellNum() method - which you allow you to set the cells column index - is protected. Having said this, I will take the time to have a better dig around and post again if I manage to make any progress. Yours Mark B AR Williamson wrote: > > Good Day all. > > I am loving Apache POI at the moment, but i have some simple questions > that I am sure someone can help with. > > With respect to adding a new column; is it true I don't need to do this > explicitly, merely set a cell value in the given row/col position. > > On that logic, how does one remove a column? What is the recommended > approach here? > > thanks > > alan > http://alan.blog-city.com/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://www.nabble.com/Adding-Deleting-a-Column-tp25982828p25996500.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]
