I'm using poi-3.8-beta5. I've created a spreadsheet that writes out fine and now I'm trying to add some styling/formatting. I would like to hide the first two rows. Based on the docs it seems like the following should work:
CellStyle hidden = out_wb.createCellStyle(); // Create a new style in the workbook hidden.setHidden(true); // make it hidden out_sheet.getRow(0).setRowStyle(hidden); // Set the style on the row. But the above does not work. I did a little Googling and found a stackoverflow answer recommending the above, but it is not working for me. It would be nice if the HOWTO for POI showed some examples of hiding rows, columns, & cells - assuming it works by some method other than what I'm doing. - Jasen. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Trouble-with-hiding-rows-in-Excel-tp5590626p5590626.html Sent from the POI - User mailing list archive at Nabble.com.
