You must use 2.0 or above to use HSSFFooter. In my first reply, I said it
exists in 1.5.1 but I was rong. It existed in CVS at the time 1.5.1 was
released, but was part of the next release (I guess).
Open source often calls *everything* beta. So don't be so concerned about
the release being beta. I think 2.0 has been stable since the Spring or
Summer. It certainly works better on spreadsheets that contain over a few
hundred rows of data (that will work in 1.5, but will usually cause Excel to
crash when it tries to open the file (unless the thousand rows are all
numeric).
What you should do is devise a set of unit tests to exercise the
functionality that you intend to use. If your unit tests pass, you can use
the beta version.
Here are some more suggestions:
1) Line 12 should be
short startRow = 1;
2) Line 16 (short startLine = 1) is not needed
3) Only one jar file is needed -- jakarta-poi-1.5.1-final-20020615.jar
4) Actually, you will want jakarta-poi-2.0-RC1-20031102.jar
-----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.*;
> import org.apache.poi.hssf.util.*;
> import org.apache.poi.hssf.record.*;
> import java.sql.*;
> import java.util.*;
>
> public class FooterTest
> {
>
> public FooterTest()
> {
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet sheet = wb.createSheet("Sheet1");
> startRow = 1;
>
> row = sheet.createRow(startRow);
>
> short startLine = 1;
> string = "abc";
>
> HSSFCell cell = row.createCell(col);
> cell.setCellValue(string);
> HSSFFooter footer = sheet.getFooter();
>
> xxxx
> }
>
> Compilation Error:
> {Note: Don't refer to the line number. I extracted
> the
> relevant program lines only.}
>
> FooterTest.java:35: cannot resolve symbol
> symbol : class HSSFFooter
> location: class FooterTest
> HSSFFooter footer = sheet.getFooter();
> ^
> FooterTest.java:35: cannot resolve symbol
> symbol : method getFooter ()
> location: class
> org.apache.poi.hssf.usermodel.HSSFSheet
> HSSFFooter footer = sheet.getFooter();
> ^
> 2 errors
>
> rgds,
>
>
>
> __________________________________
> 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]
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
__________________________________
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
