Hi,
Please add the Following pakage in your program
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.*;
import org.apache.poi.hssf.usermodel.*;
Instead of using the file input stream u can use like this.....
public static void xlRDONLY(String tempargs, String xlvalarray[])
throws Exception
{
String f1 = "d:\\automate\\order\\test\\first.xls";
Workbook workbook = Workbook.getWorkbook(new File(f1));
Sheet sheet = workbook.getSheet(1);
}
If u have any query please let me know..
Thanks & Regards
Kalpana Kanniappan
[EMAIL PROTECTED] wrote:
> Hi,
> Thanks for your reply - I have got the program to compile and run but I
> have another set of questions - and I'm sorry if these are too basic.
> I'm trying to copy an Excel template, modify it and write it out - for
> this, how do I specify the FileInputStream and FilePutputStream- I
> specified the path where the template is stored but it looks like the
> program doesn't find it. Also no file is written out - not even a blank
> one and I think that I am not specifying the filepath correctly If you
> know of any examples or sample programs that I could look at that - that
> would be a big help. Thanks again for all your help!!
>
> -----Original Message-----
> From: Vikas Pathak [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 06, 2003 4:00 AM
> To: POI Users List
> Subject: Re: Trying to install POI-HSSF - cannot resolve symbol error
>
> Hi,
> For example if your file name is first.java
>
> Please install the JBuilder 1.3 in your machine. Move your java
> file having HSSF-API's into C:\\Jbuilder3\java\bin\first.java Then go to
> the command prompt \\c:\Jbulder3\java\bin\ Then type javac
> first.java.It will work perfectly.Still if u have any problem please let
> me know.
>
> Regards
> Kalpana Kanniappan
>
> Michael Zalewski wrote:
>
> > Might not be a classpath problem. Might be a JIT problem. Are you
> > running with JDK 1.2? I think POI runs best in 1.3 or greater. You
> > might try adding -Djava.compiler=NONE as in
> >
> > java -Djava.compiler=none Clfiles.Reqs.MyClass arg1 arg2
> >
> > Anyhow, the only thing you need is
> > jakarta-poi-1.5.0-FINAL-20020506.jar.
> > Don't even need the logging stuff if you don't turn on logging.
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, January 02, 2003 12:36 PM
> > To: [EMAIL PROTECTED]
> > Subject: Trying to install POI-HSSF - cannot resolve symbol error
> >
> > Hi,
> > I downloaded the POI-HSSF library from the web site and I put the
> > jakarta-poi-1.5.0-FINAL-20020506.jar , commons-logging.jar and
> > log4j-core.jar into the directory where other java files are and added
>
> > it to the Classpath D:\...\Clfiles\Reqs To my java file I added
> > import org.apache.poi.poifs.filesystem.*;
> > import org.apache.poi.hssf.usermodel.HSSFSheet;
> > import org.apache.poi.hssf.usermodel.HSSFWorkbook;
> > import org.apache.poi.hssf.usermodel.HSSFRow;
> >
> > I get numerous cannot resolve symbol errors.... what do I have to do
> > to fix this? I apologize for the very basic question and thanks in
> > advance for any help I can get.
> >
> > ----------------------------------------------------------------------
> > -
> >
> > This message is the property of Time Inc. or its affiliates. It may be
>
> > legally privileged and/or confidential and is intended only for the
> > use of the addressee(s). No addressee should forward, print, copy, or
> > otherwise reproduce this message in any manner that would allow it to
> > be viewed by any individual not originally listed as a recipient. If
> > the reader of this message is not the intended recipient, you are
> > hereby notified that any unauthorized disclosure, dissemination,
> > distribution, copying or the taking of any action in reliance on the
> > information herein is strictly prohibited. If you have received this
> > communication in error, please immediately notify the sender and
> > delete this message. Thank you.
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
> > <mailto:[EMAIL PROTECTED]>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
