posted 12 years ago
have a working program that creates a spreadsheet. great. i'm trying to add some simple bells and whistles based on the Busy Developer's Guide examples, such as the autofilter and footer examples.
I can get it them to compile, but i don't see any results in the spreadsheet. I don't see what I'm doing wrong.
here's the relevant code for the autofilter and footers....
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFFooter;
....
HSSFSheet sheet = wb.createSheet("My Report");
sheet.setAutoFilter(CellRangeAddress.valueOf("N5:N65000"));
.........deleted bunch of code that creates the individual rows of the spreadsheet
HSSFFooter footer = sheet.getFooter();
footer.setCenter("Center footer");
footer.setLeft("Left footer");
footer.setRight("Right footer");
like i said - the program runs but i don't see the autofilter button or the footers in the resulting spreadsheet.
i'm using poi 3.7
anybody have any idea what the problem might be?
i may be missing something obvious. i'm new at this......
thanks!