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]
