Hi, Thanks a lot. I will download 2.0 and try it.
rgds, --- Michael Zalewski <[EMAIL PROTECTED]> wrote: > > I noticed that startRow should be (short) and not > (int) > > as suggested. If I use (short), that error > disappears. > > Hmm actually, I think its short in 1.5.1, but was > changed to int in 2.0 > > -----Original Message----- > From: yangontha Maung [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 30, 2003 11:07 PM > To: POI Users List > Subject: RE: Footer > > Hi, > > Thanks for your suggestions. > > I have not tried version 2.0 since it is still RC. > > However, as you mentioned, I tried to compile the > basic minimum stage. But there are errors as before. > > It is run on RedHat Linux 9.0. > Java version is 1.4.2. > poi is 1.5.1 > (jakarta-poi-1.5.1-final.bin.tar.gz.tar) > > I noticed that startRow should be (short) and not > (int) as suggested. If I use (short), that error > disappears. > > HSSFFooter still has the same error. > > Does it mean that I must use version 2.0 to use > Footer? > > Just to make sure that I have the correct jar files, > here is my .jar files in poi/build directory > > jakarta-poi-1.5.1-final-20020615.jar > jakarta-poi-contrib-1.5.1-final-20020615.jar > jakarta-poi-examples-1.5.1-final-20020615.jar > jakarta-poi-scratchpad-1.5.1-final-20020615.jar > > +++++++++ > > import org.apache.poi.hssf.usermodel.*; > import java.io.*; > > public class FooterTest > { > > public FooterTest() > { > HSSFWorkbook wb = new HSSFWorkbook(); > HSSFSheet sheet = wb.createSheet("Sheet1"); > int startRow = 1; > > HSSFRow row = sheet.createRow(startRow); > > short startLine = 1; > String string = "abc"; > short col = 1; > > HSSFCell cell = row.createCell(col); > cell.setCellValue(string); > HSSFFooter footer = sheet.getFooter(); > > > try > { > FileOutputStream fileOut = > new > FileOutputStream("/www/htdocs/data/xls/footer.xls"); > > wb.write(fileOut); > fileOut.close(); > } catch(IOException ioex) > { > > // do something > } > > } > > > public static void main(String[] args) > { > FooterTest app = new FooterTest(); > } > } > > +++++++++ > Errors: > > > "FooterTest.java" 55L, 976C written > [EMAIL PROTECTED] domino]$ javac FooterTest.java > FooterTest.java:22: createRow(short) in > org.apache.poi.hssf.usermodel.HSSFSheet > cannot be applied to (int) > HSSFRow row = sheet.createRow(startRow); > ^ > FooterTest.java:30: cannot resolve symbol > symbol : class HSSFFooter > location: class FooterTest > HSSFFooter footer = sheet.getFooter(); > ^ > FooterTest.java:30: cannot resolve symbol > symbol : method getFooter () > location: class > org.apache.poi.hssf.usermodel.HSSFSheet > HSSFFooter footer = sheet.getFooter(); > ^ > 3 errors > > ++++ > rgds, > > > **************************** > > --- Michael Zalewski <[EMAIL PROTECTED]> wrote: > > This should work fine. > > > > 1) The HSSFSheet.getFooter() method exists in > 1.5.1, > > but you really might > > have better luck with 2.0. There are many serious > > bugs fixed in between > > 1.5.1 and 2.0. > > > > 2) Your import statements should work AFAIK. But > > 'import > > org.apache.poi.hssf.usermodel.HSSFWorkbook.*' is > > incorrect (there is no such > > package - HSSFWorkbook is a class). > > > > 3) Try compiling something as simple as what you > > have included below and > > work backwards. The code you supplied has many > > missing pieces (which shows > > that you have not yet done this). For instance, > > 'startRow = 1' s/b 'int > > startRow = 1'. Once you get a complete class to > > fail, you have something > > that we can reproduce and therefore help you. > > > > However, I was able to compile the following: > > > > import org.apache.poi.hssf.usermodel.*; > > > > public class TestFooter { > > > > public TestFooter() > > { > > HSSFWorkbook wb = new HSSFWorkbook(); > > HSSFSheet sheet = wb.createSheet("Sheet1"); > > int startRow = 1; > > > > HSSFRow row = sheet.createRow(startRow); > > > > short startLine = 1; > > String string = "abc"; > > > > short col = 1; > > HSSFCell cell = row.createCell(col); > > cell.setCellValue(string); > > HSSFFooter footer = sheet.getFooter(); > > } > > } > > > > See if the above compiles in your environment. > Note > > that you don't need all > > those import statements (although I don't think > > including them should hurt). > > > > Mike Zalewski > > > > -----Original Message----- > > From: yangontha Maung > [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, December 30, 2003 12:07 AM > > To: [EMAIL PROTECTED] > > Subject: Footer > > > > Hi, > > > > I am using poi version 1.5.1 on Red Hat Linux 9.0 > > Java version 1.4.2 > > > > The import statements and the errors are as > > follows:- > > > > > > import java.io.*; > > import org.apache.poi.hssf.usermodel.*; > > import > org.apache.poi.hssf.usermodel.HSSFWorkbook.*; > === message truncated === __________________________________ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
