org.apache.poi.hssf.usermodel.HSSFCellStyle.setHidden(true) to do the entire column, you may have to iterate over all rows and set style on cells in the required column.
Alternatively, you may choose to set the column width to 0 using: org.apache.poi.hssf.usermodel.HSSFSheet.setColumnWidth(colIndex, (short) 0); HTH, ~ amol > -----Original Message----- > From: news [mailto:[EMAIL PROTECTED] Behalf Of Shane > Sent: Monday, April 18, 2005 10:32 AM > To: [email protected] > Subject: Hiding or removing a column. > > > I didn't see in the documentation anywhere how to hide or > remove a cell. I saw > a removeRow in HSSFSheet but that was about it. What i need > to do is check on > a specific row for blank or null values, and then hide the > entire column that > is empty (id prefer to actually remove such column.) IS > there anyway to do > this using the API? > > thanks, > Shane > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
