Hi,
See the example below. I have the data sorted by name and need to show the break up amount for each name. There can be more than one name with different amount. So, I have to sum-up and show the total using POI. In this example, I did this using Excel functionality i.e. Data --> Subtotals. I need to do the same kind of thing using POI. Let me know, if there is any solution to this. Name Amount A1 10 A1 20 A1 56 A2 78 A2 34 A2 56 A2 45 A3 90 Output Name Amount A1 10 A1 20 A1 56 A1 78 A1 Total 164 A2 34 A2 45 A2 56 A2 Total 135 A3 90 A3 Total 90 Grand Total 389 Thanks & Regards Neeraj Jindal -----Original Message----- From: Anthony Andrews [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 10:26 AM To: POI Users List Subject: Re: Sub Total I think the only way you can do this is 'manually'. By this I mean, write Java code that will calculate the total for you and then place this figure into a cell of the spreadsheet. --- Neeraj Jindal <[EMAIL PROTECTED]> wrote: > Hi > > I need to do a Subtotal using POI > Can any body suggest me how to do that? > > Regards, > Neeraj Jindal > ###################################################################### > > NOTICE: > The contents of this e-mail and any attachments to > it may contain > privileged and confidential information from Jones > Apparel Group, Inc. > or its affiliates. This information is only for the > viewing or use > of the intended recipient. If you are not the > intended recipient, > you are hereby notified that any disclosure, > copying, distribution or > use of, or the taking of any action in reliance > upon, the information > contained in this e-mail, or any of the attachments > to this e-mail, > is strictly prohibited. If you have received this > e-mail in error, > please immediately notify the sender by replying to > this message and > delete it from your system. > > ###################################################################### > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > Mailing List: > http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: > http://jakarta.apache.org/poi/ > > __________________________________ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ ###################################################################### NOTICE: The contents of this e-mail and any attachments to it may contain privileged and confidential information from Jones Apparel Group, Inc. or its affiliates. This information is only for the viewing or use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of, or the taking of any action in reliance upon, the information contained in this e-mail, or any of the attachments to this e-mail, is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by replying to this message and delete it from your system. ######################################################################
