You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Vikas Pathak <vp...@qwest.com> on 2002/12/04 14:41:22 UTC
Excel File Problem--See the Attachment...
Hi,
Chart is not changing according to the change of data in the Excel Sheet.
Just see the Excel Sheet Attachment...In this for the Second row i modified data for the 11/2 = 25.00
11/3 = 9.50
11/4 = 8.00. inside the excel Sheet.
But in the chart those values are becoming zero i.e See the GUI IRTM line chart.
The modified values are not replicating in the Line chart.
Could u please reply me about this. I am waiting for your reply.
Thanks & Regards
kalpana.k
Avik Sengupta wrote:
> Charts are pretty much work in progress. The best thing to do would be
> to add a bug to bugzilla with the minimum amount of code needed to
> replicate the problem and attach the relevant worksheets
>
> Regards
> -
> avik
>
> On Wed, 2002-12-04 at 12:56, Vikas Pathak wrote:
> > Hi Avik,
> >
> > Thanks for your information and imeeediate reply me.
> > I added classpath properly and it's compiling.
> >
> > I need one more clarification::::
> >
> > I am able to insert data inside my excel sheet which is already having graph. If i modify the
> > data inside the excel sheet , the new value is not replicating in the graph. The chart line for the new
> > value is going to Zero instead of taking the new value.
> >
> > Could u please reply me about this issue.
> >
> > Thanks & Regards
> > kalpana.k
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Avik Sengupta wrote:
> >
> > > Maybe, if you could send the error message, it would be useful.
> > >
> > > But before you do that, please re-check your classpath, and the version
> > > of POI you have in it.
> > >
> > > Regards
> > > -
> > > Avik
> > >
> > > On Tue, 2002-12-03 at 18:32, Vikas Pathak wrote:
> > > > Hi ,
> > > >
> > > > I downloaded the jakarta-poi-1.8.0-dev-bin.zip for the latest verion
> > > > jakarta-poi-1.8.0-dev-20020919.jar jar file.
> > > > I added the jar file inside my classpath.But while executing my program i am getting the follwing
> > > > error for the follwing commands.
> > > >
> > > > File f = new File(sheet_path);
> > > > FileInputStream fis = new FileInputStream(f);
> > > > HSSFWorkbook w = new HSSFWorkbook(fis);
> > > > HSSFSheet sheet = w.getSheet(0);
> > > > int rows = sheet.getLastCellNum();
> > > > HSSFCell c1,c2,c3;
> > > >
> > > >
> > > > Error:
> > > >
> > > > [Image]
> > > >
> > > >
> > > >
> > > > Can u please look into this prblem. I am waiting for your reply.
> > > >
> > > > Thanks & Regards
> > > > kalpana.k
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > poi-user-help@jakarta.apache.org wrote:
> > > >
> > > > > Hi! This is the ezmlm program. I'm managing the
> > > > > poi-user@jakarta.apache.org mailing list.
> > > > >
> > > > > I'm working for my owner, who can be reached
> > > > > at poi-user-owner@jakarta.apache.org.
> > > > >
> > > > > To confirm that you would like
> > > > >
> > > > > vpathak@qwest.com
> > > > >
> > > > > added to the poi-user mailing list, please send
> > > > > an empty reply to this address:
> > > > >
> > > > > poi-user-sc.1038839761.obhedlinaipjakjgepjo-vpathak=qwest.com@jakarta.apache.org
> > > > >
> > > > > Usually, this happens when you just hit the "reply" button.
> > > > > If this does not work, simply copy the address and paste it into
> > > > > the "To:" field of a new message.
> > > > >
> > > > > or click here:
> > > > > mailto:poi-user-sc.1038839761.obhedlinaipjakjgepjo-vpathak=qwest.com@jakarta.apache.org
> > > > >
> > > > > This confirmation serves two purposes. First, it verifies that I am able
> > > > > to get mail through to you. Second, it protects you in case someone
> > > > > forges a subscription request in your name.
> > > > >
> > > > > Some mail programs are broken and cannot handle long addresses. If you
> > > > > cannot reply to this request, instead send a message to
> > > > > <po...@jakarta.apache.org> and put the
> > > > > entire address listed above into the "Subject:" line.
> > > > >
> > > > > --- Administrative commands for the poi-user list ---
> > > > >
> > > > > I can handle administrative requests automatically. Please
> > > > > do not send them to the list address! Instead, send
> > > > > your message to the correct command address:
> > > > >
> > > > > To subscribe to the list, send a message to:
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > To remove your address from the list, send a message to:
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > Send mail to the following for info and FAQ for this list:
> > > > > <po...@jakarta.apache.org>
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > Similar addresses exist for the digest list:
> > > > > <po...@jakarta.apache.org>
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > To get messages 123 through 145 (a maximum of 100 per request), mail:
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > To get an index with subject and author for messages 123-456 , mail:
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > They are always returned as sets of 100, max 2000 per request,
> > > > > so you'll actually get 100-499.
> > > > >
> > > > > To receive all messages with the same subject as message 12345,
> > > > > send an empty message to:
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > The messages do not really need to be empty, but I will ignore
> > > > > their content. Only the ADDRESS you send to is important.
> > > > >
> > > > > You can start a subscription for an alternate address,
> > > > > for example "john@host.domain", just add a hyphen and your
> > > > > address (with '=' instead of '@') after the command word:
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > To stop subscription for this address, mail:
> > > > > <po...@jakarta.apache.org>
> > > > >
> > > > > In both cases, I'll send a confirmation message to that address. When
> > > > > you receive it, simply reply to it to complete your subscription.
> > > > >
> > > > > If despite following these instructions, you do not get the
> > > > > desired results, please contact my owner at
> > > > > poi-user-owner@jakarta.apache.org. Please be patient, my owner is a
> > > > > lot slower than I am ;-)
> > > > >
> > > > > --- Enclosed is a copy of the request I received.
> > > > >
> > > > > Return-Path: <vp...@qwest.com>
> > > > > Received: (qmail 3060 invoked by uid 98); 2 Dec 2002 14:36:00 -0000
> > > > > Delivered-To: qmvirus-jakarta-poi-user-subscribe@nagoya.betaversion.org
> > > > > X-Antivirus: nagoya (v4218 created Aug 14 2002)
> > > > > Received: (qmail 2985 invoked from network); 2 Dec 2002 14:35:58 -0000
> > > > > Received: from daedalus.apache.org (HELO apache.org) (63.251.56.142)
> > > > > by nagoya.betaversion.org with SMTP; 2 Dec 2002 14:35:58 -0000
> > > > > Received: (qmail 40063 invoked by uid 500); 2 Dec 2002 14:34:52 -0000
> > > > > Delivered-To: apmail-jakarta-poi-user-subscribe@jakarta.apache.org
> > > > > Received: (qmail 40044 invoked from network); 2 Dec 2002 14:34:51 -0000
> > > > > Received: from uswgco34.uswest.com (199.168.32.123)
> > > > > by daedalus.apache.org with SMTP; 2 Dec 2002 14:34:51 -0000
> > > > > Received: from egate-ut2.uswc.uswest.com (mailgate.uswc.uswest.com [148.157.122.199])
> > > > > by uswgco34.uswest.com (8.10.0/8.10.0) with ESMTP id gB2EYqe01155;
> > > > > Mon, 2 Dec 2002 07:34:52 -0700 (MST)
> > > > > Received: from netmail3.uswc.uswest.com (localhost [127.0.0.1])
> > > > > by egate-ut2.uswc.uswest.com (8.10.0/8.10.0) with ESMTP id gB2EYpd25703;
> > > > > Mon, 2 Dec 2002 07:34:51 -0700 (MST)
> > > > > Received: from qwest.com ([157.227.22.233]) by netmail3.uswc.uswest.com
> > > > > (Netscape Messaging Server 3.61) with ESMTP id AAA477F;
> > > > > Mon, 2 Dec 2002 07:34:49 -0700
> > > > > Message-ID: <3D...@qwest.com>
> > > > > Date: Mon, 02 Dec 2002 20:10:55 +0530
> > > > > From: "Vikas Pathak" <vp...@qwest.com>
> > > > > X-Mailer: Mozilla 4.7 [en] (WinNT; I)
> > > > > X-Accept-Language: en
> > > > > MIME-Version: 1.0
> > > > > To: poi-user-return-@jakarta.apache.org, poi-user-subscribe@jakarta.apache.org,
> > > > > poi-user-owner@jakarta.apache.org, poi-user@jakarta.apache.org
> > > > > Subject: Excel Sheet Graph Problem.
> > > > > References: <10...@jakarta.apache.org>
> > > > > Content-Type: text/plain; charset=us-ascii
> > > > > Content-Transfer-Encoding: 7bit
> > > > > X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
> > > > >
> > > > > Hi,
> > > > > I like to Draw the Graph in Workbook XLS sheet.
> > > > >
> > > > > 1. Through java program using jxl.jar file i am able to enter the data inside the
> > > > > Excel Sheet.
> > > > > 2. But the Gragh already present inside the Excel Sheet is deleted.
> > > > > 3. But i like to do the way like,
> > > > > As soon the data entering into the Each Cell, Already present Graph inside
> > > > > Excel Sheet has to chane according to the New data.
> > > > > 4. I downloaded this file jakarta-poi-1.5.1-final-bin.zip. But i am not able to get
> > > > > the org.apache.poi.hssf.model.Sheet this jar file.
> > > > >
> > > > > I am not able to solve this problem.Can u please give Solution this problem.
> > > > > I am waiting for your Reply.
> > > > >
> > > > > Thanks & Regards
> > > > > Kalpana.k
> > > > >
> > > > > poi-user-return-@jakarta.apache.org wrote:
> > > > >
> > > > > > Hi! This is the ezmlm program. I'm managing the
> > > > > > poi-user@jakarta.apache.org mailing list.
> > > > > >
> > > > > > I'm working for my owner, who can be reached
> > > > > > at poi-user-owner@jakarta.apache.org.
> > > > > >
> > > > > > This is a generic help message. The message I received wasn't sent to
> > > > > > any of my command addresses.
> > > > > >
> > > > > > --- Administrative commands for the poi-user list ---
> > > > > >
> > > > > > I can handle administrative requests automatically. Please
> > > > > > do not send them to the list address! Instead, send
> > > > > > your message to the correct command address:
> > > > > >
> > > > > > To subscribe to the list, send a message to:
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > To remove your address from the list, send a message to:
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > Send mail to the following for info and FAQ for this list:
> > > > > > <po...@jakarta.apache.org>
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > Similar addresses exist for the digest list:
> > > > > > <po...@jakarta.apache.org>
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > To get messages 123 through 145 (a maximum of 100 per request), mail:
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > To get an index with subject and author for messages 123-456 , mail:
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > They are always returned as sets of 100, max 2000 per request,
> > > > > > so you'll actually get 100-499.
> > > > > >
> > > > > > To receive all messages with the same subject as message 12345,
> > > > > > send an empty message to:
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > The messages do not really need to be empty, but I will ignore
> > > > > > their content. Only the ADDRESS you send to is important.
> > > > > >
> > > > > > You can start a subscription for an alternate address,
> > > > > > for example "john@host.domain", just add a hyphen and your
> > > > > > address (with '=' instead of '@') after the command word:
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > To stop subscription for this address, mail:
> > > > > > <po...@jakarta.apache.org>
> > > > > >
> > > > > > In both cases, I'll send a confirmation message to that address. When
> > > > > > you receive it, simply reply to it to complete your subscription.
> > > > > >
> > > > > > If despite following these instructions, you do not get the
> > > > > > desired results, please contact my owner at
> > > > > > poi-user-owner@jakarta.apache.org. Please be patient, my owner is a
> > > > > > lot slower than I am ;-)
> > > > > >
> > > > > > --- Enclosed is a copy of the request I received.
> > > > > >
> > > > > > Return-Path: <vp...@qwest.com>
> > > > > > Received: (qmail 1565 invoked by uid 98); 2 Dec 2002 14:08:45 -0000
> > > > > > Delivered-To: qmvirus-jakarta-poi-user-help@nagoya.betaversion.org
> > > > > > X-Antivirus: nagoya (v4218 created Aug 14 2002)
> > > > > > Received: (qmail 1545 invoked from network); 2 Dec 2002 14:08:43 -0000
> > > > > > Received: from daedalus.apache.org (HELO apache.org) (63.251.56.142)
> > > > > > by nagoya.betaversion.org with SMTP; 2 Dec 2002 14:08:43 -0000
> > > > > > Received: (qmail 18141 invoked by uid 500); 2 Dec 2002 14:07:38 -0000
> > > > > > Delivered-To: apmail-jakarta-poi-user-help@jakarta.apache.org
> > > > > > Received: (qmail 18131 invoked from network); 2 Dec 2002 14:07:37 -0000
> > > > > > Received: from uswgne22.uswest.com (204.26.87.76)
> > > > > > by daedalus.apache.org with SMTP; 2 Dec 2002 14:07:37 -0000
> > > > > > Received: from egate-ut3.uswc.uswest.com (mailgate.uswc.uswest.com [148.157.122.201])
> > > > > > by uswgne22.uswest.com (8.10.0/8.10.0) with ESMTP id gB2E7YO24641
> > > > > > for <po...@jakarta.apache.org>; Mon, 2 Dec 2002 08:07:35 -0600 (CST)
> > > > > > Received: from netmail3.uswc.uswest.com (localhost [127.0.0.1])
> > > > > > by egate-ut3.uswc.uswest.com (8.10.0/8.10.0) with ESMTP id gB2E7Yx29074
> > > > > > for <po...@jakarta.apache.org>; Mon, 2 Dec 2002 07:07:34 -0700 (MST)
> > > > > > Received: from qwest.com ([157.227.22.233]) by netmail3.uswc.uswest.com
> > > > > > (Netscape Messaging Server 3.61) with ESMTP id AAA2FA0
> > > > > > for <po...@jakarta.apache.org>;
> > > > > > Mon, 2 Dec 2002 07:07:32 -0700
> > > > > > Message-ID: <3D...@qwest.com>
> > > > > > Date: Mon, 02 Dec 2002 19:43:30 +0530
> > > > > > From: "Vikas Pathak" <vp...@qwest.com>
> > > > > > X-Mailer: Mozilla 4.7 [en] (WinNT; I)
> > > > > > X-Accept-Language: en
> > > > > > MIME-Version: 1.0
> > > > > > To: poi-user-help@jakarta.apache.org
> > > > > > Subject: Download
> > > > > > Content-Type: text/plain; charset=us-ascii
> > > > > > Content-Transfer-Encoding: 7bit
> > > > > > X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > I am not able to download the latest version of
> > > > > > jakarata-poi-1.8.0-dev-20020919.jar.
> > > > > > Can u please give me the exact path to download this file.
> > > > > >
> > > > > > --
> > > > > > thanks and regards
> > > > > > kalpana.k
> > > > >
> > > > > --
> > > > > thanks and regards
> > > > > Vikas Pathak
> > > > > Ph no : 2540130 ext 2062,2063.
> > > >
> > > > --
> > > > thanks and regards
> > > > Vikas Pathak
> > > > Ph no : 2540130 ext 2062,2063.
> > > >
> > >
> > > --
> > > To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> > > For additional commands, e-mail: <ma...@jakarta.apache.org>
> >
> > --
> > thanks and regards
> > Vikas Pathak
> > Ph no : 2540130 ext 2062,2063.
> >
> >
> >
> > --
> > To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> > For additional commands, e-mail: <ma...@jakarta.apache.org>
> >
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
--
thanks and regards
Vikas Pathak
Ph no : 2540130 ext 2062,2063.