changed your action mappings during the upgrade?
May be you can get some ideas from here
http://wiki.apache.org/struts/StrutsFileDownload
Regards,
Tahir Akhtar
-Original Message-
From: Jon Wynacht [mailto:[EMAIL PROTECTED]
Sent: Monday, May 28, 2007 2:57 AM
To: poi-user@jakarta.apache.org
OTH, if the stacktrace suggests the exception originates at the line
containing response.setHeader/response.setContentType the problem might be
upstream.
In both cases the struts users list will be more helpful than poi.
Regards,
Tahir Akhtar
-Original Message-
From: Tahir Akhtar
Use org.apache.poi.hssf.util.CellReference. Simply create a new instance
passing the string in the constructor then call getRow(), getCol().
-Original Message-
From: Sebastian Frehmel [mailto:[EMAIL PROTECTED]
Sent: Monday, May 21, 2007 3:09 PM
To: poi-user@jakarta.apache.org
Adriana,
It is tough to say anything about your problem without looking at the
exception stack trace.
For null pointer exception, it is crucial to know which reference was null
(and this information can only be guessed by stacktrace)
Regards,
Tahir
-Original Message-
From: Adriana Rozo
.
Any help would be highly appreciated.
Regards,
Tahir Akhtar
:
http://www.cpearson.com/excel/array.htm
http://www.ozgrid.com/Excel/arrays.htm
[1]
http://svn.apache.org/viewvc/jakarta/poi/trunk/src/java/org/apache/poi/hssf/
record/formula/ArrayPtg.java?view=markup
[2]
http://issues.apache.org/bugzilla/buglist.cgi?product=POI
Regards,
Tahir Akhtar
It could be because of version incompatibility. May be user machine have
upgraded to newer version of excel. Try opening the file in excel and
save-as a new file paying attention to format (Excel 97 etc). Then try
running your program on newly saved file.
-Original Message-
From: Sara
I guess no.
Are you talking about some Microsoft Excel specific templating system or
general templating engines like velocity?
Regards,
Tahir Akhtar
-Original Message-
From: Tarek Nabil [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2007 4:34 PM
To: poi-user@jakarta.apache.org
, attachment;
filename=report.xls );
Wassalam
Tahir Akhtar
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 16, 2007 3:02 AM
To: [EMAIL PROTECTED]
Subject: Re: Excel Export
Hello, Tahir,
I've seen your name in an Apache/Tomcat thread regarding a problem
For setting a sheet's selected status (Helpful, for example, when you want
the user to print only selected sheets):
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFShee
t.html#setSelected(boolean)
For setting the selected tab of workbook
Zep,
I agree with Mike. Your solution will require
* Excel installed on each client pc
* Users must (temporarily) save the file on there PC
* File will need to be uploaded.
You may find browser security issues when trying to do local-save and upload
behind the scenes (without user noticing
Yegor,
Thanks for implementing the much needed functionality.
Is it possible to somehow auto-size only those columns that are not wide
enough to display there content but leave those columns that are wider than
required? I mean that I don't want to shrink the columns that can show there
content
to export data to excel spreadsheet?
Vishal
From: Tahir Akhtar [mailto:[EMAIL PROTECTED]
Sent: Thu 1/25/2007 2:17 AM
To: 'POI Users List'
Subject: RE: How to use POI (Newbie)
Hi Rohilla
1. Its advisable to use the latest release poi
Happened to me too
-Original Message-
From: A. Rick Anderson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 7:48 PM
To: POI Users List
Subject: POI Source code carrying a virus
When I download the POI source code, my Symantec virus checker goes
nuts. It reports that, at
I am willing to contribute if you provide some initial pointers.
Regards
Tahir
-Original Message-
From: Avik Sengupta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 6:08 PM
To: poi-user@jakarta.apache.org
Subject: Re: Autosizing question:
Since VBA have this function to
Hi Rohilla
1. Its advisable to use the latest release poi-bin-3.0-alpha3-20061212.
2. There is nothing special about poi jars. Just use it as you use any java
library i-e include it in your classpath(or out it in your WEB-INF/lib) and
reference the classes via import statement or fully qualified
=region.getRowTo()-region.getRowFrom()+1;
}
Regards,
Tahir Akhtar
-Original Message-
From: Karr, David [mailto:[EMAIL PROTECTED]
Sent: Monday, January 08, 2007 11:38 PM
To: poi-user@jakarta.apache.org
Subject: How to read single value from merged cells
I haven't used
In my knowledge only feasible method of doing such stuff is through Open
Office API. You will need a running instance of open office listening for
requests.
-Original Message-
From: Nick Burch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 08, 2006 8:08 PM
To: POI Users List
Simplest way to go is to write the formula in the cell. When the user opens
the workbook excel will calculate the values. IMO, formula evaluation
support in POI 3.0 is for scenarios where you want to find out what value a
formula cell will contain upon evaluation within you Java Application.
Another solution would be to add a macro to automatically call the print
function of excel right after loading the excel file. But it will cause a
lot of security warnings to user.
-Original Message-
From: Anthony Andrews [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 6:53
Hi Bao,
Sorry I was not able to write back to you earlier. I haven’t solved this
problem yet but plan to do this with Jasper Report library. My solution will
most likely revolve around a custom Jasper data source that will read from a
POI work book object and expose data to Jasper Library. The
class(PrecentPtg for example) how i can get to know which sid is free?
by loking through all Ptg classes?
What is the number of the bug with this attachment-
http://issues.apache.org/bugzilla/attachment.cgi?id=17998 ?
Tahir Akhtar wrote:
Well, I found your patch at
http://issues.apache.org
another
patch to go with it.
Regards,
Tahir
-Original Message-
From: Tahir Akhtar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 20, 2006 4:16 PM
To: 'POI Users List'
Subject: RE: Turn off warning in POI
Well, I found your patch at
http://issues.apache.org/bugzilla/attachment.cgi?id=17998
Do
http://encore.torchbox.com/poi-svn-build/ builds against the svn HEAD and
may not include patches submitted in bugzilla.
I think Ramesh needs 2.5.1 branch with all the patches. I am interested in
this too. Anyone?
-Original Message-
From: Erich W. Schasse [mailto:[EMAIL PROTECTED]
-
From: Nick Burch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 3:07 PM
To: POI Users List
Subject: RE: How To Get POI JAR With Patches
On Wed, 21 Jun 2006, Tahir Akhtar wrote:
I think Ramesh needs 2.5.1 branch with all the patches. I am interested
in this too. Anyone?
Ah, but which
Daniel,
I am using POI 2.5 release and I am generating workbooks based on user
input. If my user provide a formula with % such as A3*10% it appears in
excel as A3*10. The percent symbol is chopped off.
Can I instruct POI to simply write the formula into the cell without trying
to parse it? If
Well, I found your patch at
http://issues.apache.org/bugzilla/attachment.cgi?id=17998
Do you recommend using this patch with POI 2.5?
-Original Message-
From: Tahir Akhtar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 20, 2006 4:12 PM
To: 'POI Users List'
Subject: RE: Turn off warning
Hi All,
I am having trouble checking-out poi from svn. Do we have nightly snapshots
somewhere?
Thanks
Tahir
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 6/14/2006
Tons of thanks.
-Original Message-
From: Nick Burch [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 15, 2006 8:32 PM
To: POI Users List
Subject: Re: Getting the latest source
On Thu, 15 Jun 2006, Tahir Akhtar wrote:
I am having trouble checking-out poi from svn. Do we have nightly
But I am against all things Viral, like viral marketing etc. And on top of
that I cannot pronounce Epidemiology. Let the Myanh handle it alone ;)
-Original Message-
From: Phillip W Virgo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 7:02 PM
To: POI Users List
Subject: Phillip W
.
You can also get the latest development version from the dev directory. Both
release and development versions are available in source and binary forms.
Your problems seems to be related to handling of encoding. But I do not have
anything to say about it :).
Regards,
Tahir Akhtar
-Original
: Birendar Waldiya [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 4:34 PM
To: 'Tahir Akhtar'; poi-user@jakarta.apache.org
Subject: RE: Major Problem With POI Excel reader: Urgent Help Needed
Hi Tahir,
I have done all the activities , the character on my eclipse console are
printed
development version.
Development versions are work in progress while release is stable.
_
From: Birendar Waldiya [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 4:34 PM
To: 'Tahir Akhtar'; poi-user@jakarta.apache.org
Subject: RE: Major Problem With POI Excel reader: Urgent Help Needed
, browser is not getting proper headers in http
response. It can be due to mal-functioning proxy among other things. Try
different browsers to see if anyone get its right.
Regards,
Tahir Akhtar
-Original Message-
From: Prasanna Balaji [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 04, 2006 10
) mod_gzip/1.3.26.1a PHP/4.3.11
Vary: Host
X-Powered-By: PHP/4.3.11
Content-Type: text/html
Content-Encoding: gzip
Content-Length: 3916
X-Cache: MISS from proxy.your-isp.net
Connection: keep-alive
200 OK
Regards,
Tahir Akhtar
-Original Message-
From: Tahir Akhtar [mailto:[EMAIL PROTECTED
Sorry, forgot to mention, you must have web developer extension installed.
HYPERLINK
http://chrispederick.com/work/webdeveloper/http://chrispederick.com/work/w
ebdeveloper/
-Original Message-
From: Tahir Akhtar [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 1:46 PM
the dev directory. Both
release and development versions are available in source and binary forms.
Your problems seems to be related to handling of encoding. But I do not have
anything to say about it :).
Regards,
Tahir Akhtar
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
I think you must try to get help in some weblogic related group as this
issue is most probably not related to poi.
Regards,
Tahir Akhtar
-Original Message-
From: Prasanna Balaji [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 5:07 PM
To: 'POI Users List'
Subject: RE: Excel Export
Most probably issue is related to Content Type header. What happens if you
write to a file on weblogic server with xls extension and open from there?
If you can get it to work by writing to a file but not through servlet
output stream, you need to check if web
-Original Message-
From:
Could be due to cell styles. You may be creating different style objects for
each formatted cell even though there style is same.
Just a guess :)
-Original Message-
From: Goswami, Sachin (IT) [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 30, 2006 6:39 PM
To: poi-user@jakarta.apache.org
from an input stream,
attempting to read further data will return nothing. If your application is
expecting certain amount of data (like a header in poifs) than it's going to
crash with an exception.
Hope that helps.
Regards,
Tahir Akhtar
-Original Message-
From: Sawant, Ramdas (IT) [mailto
will work:
Loop over the rows
-Put the value of the column in a set
You will have to put value objects not the complete HSSFCell object. Rest is
upto the equals method implementation of values :)
Regards,
Tahir Akhtar
-Original Message-
From: Sawant, Ramdas (IT) [mailto:[EMAIL
From http://jakarta.apache.org/poi/hssf/eval.html:
This code currently lives the scratchpad area of the POI CVS repository.
Ensure that you have the scratchpad jar or the scratchpad build area in your
classpath before experimenting with this code.
I am not sure about how to get scratchpad jar.
Go to download
* poi/dev/bin/poi-bin-3.0-alpha1-20050704.tar.gz
* extract the jar files from archive including the
poi-scratchpad-3.0-alpha1-..
Regards,
Tahir Akhtar
-Original Message-
From: Tahir Akhtar [mailto:[EMAIL PROTECTED]
Sent: Monday, March 13, 2006 1:46 PM
To: 'POI Users
, attachment; filename= +
filename);
But not IE. IE just show the servlet name as before.
Thanks again.
Jody
Tahir Akhtar [EMAIL PROTECTED]
03/08/2006 10:04 AM
Please respond to
POI Users List poi-user@jakarta.apache.org
To
'POI Users List' poi-user@jakarta.apache.org
cc
Subject
RE
Hi,
How can I get a cell from HSSFSheet with a cell address in excel notation
like A10 or a collection of cells by specifying a range like A1:A10.
Is it possible?
Regards,
Tahir
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database:
Well you can't export to PDF from POI you need to load the file into
e.g. OpenOffice using UNO and let OO do the Job for you. How this can be
done is shown in the codesnippet here:
http://codesnippets.services.openoffice.org/Office/Office.ConvertDocuments.s
nip
Tom
Tahir Akhtar wrote:
Hi
the Job for you. How this can be
done is shown in the codesnippet here:
http://codesnippets.services.openoffice.org/Office/Office.ConvertDocuments.s
nip
Tom
Tahir Akhtar wrote:
Hi,
If I generate an excel sheet using POI, and have an instance of
HSSFWorkbook
on hand, what are my options
.
Thanks again.
Jody
Tahir Akhtar [EMAIL PROTECTED]
03/08/2006 10:04 AM
Please respond to
POI Users List poi-user@jakarta.apache.org
To
'POI Users List' poi-user@jakarta.apache.org
cc
Subject
RE: Excel Sheet Title
Jody,
You need to set content-disposition header
// Set the headers
. If I use:
response.setContentType(application/vnd.ms-excel);
response.setHeader(Content-Disposition, attachment; filename= +
filename);
I get a view dialog but the header doesn't take in I.E.
Maybe I will not be able to do this?
Jody
Tahir Akhtar [EMAIL PROTECTED]
03/08/2006 12:12 PM
] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 10:28 AM
To: POI Users List
Subject: [NEW] - RE: Excel Sheet Title - Message is from an unknown
sender
That didn't do it either but thanks for trying.
Jody
Tahir Akhtar [EMAIL PROTECTED]
03/08/2006 01:07 PM
Please respond to
POI Users List
Hi,
I am trying to use FormulaParser class to parse excel formula. I understand
following constructor can be used for parsing formulas.
HYPERLINK
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/model/FormulaPars
er.html#FormulaParser(java.lang.String,
Hi,
I am trying to use FormulaParser class to parse excel formula. I understand
following constructor can be used for parsing formulas.
HYPERLINK
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/model/FormulaPars
er.html#FormulaParser(java.lang.String,
Hi,
If I generate an excel sheet using POI, and have an instance of HSSFWorkbook
on hand, what are my options for generating a PDF file?
Any ideas will be really helpful.
Regards,
Tahir
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 /
54 matches
Mail list logo
