Hi,
I think you can use *JExcel API* for that as I have used that too earlier.
What you can do is read one of the excel file (report1 or report2, prefer
one which has less data) and then write the data in another excel sheet say
report 2.
JExcel is better than POI when comparing in certain situations, don't
remember the exact scenarios. You can google and find the same.
Thanks,
Nirmal
\\\///
/ \
| \\ // |
( | (.) (.) |)
----------o00o--(_)--o00o-------------------
Stand up,be bold,be strong.
Take the whole responsibility on
ur own shoulders and know that
U are the creator of ur own destiny.
------ooo0-------------------------------------
( ) 0ooo
\ ( ( )
\_) ) /
(_/
On Wed, Mar 31, 2010 at 12:12 PM, Dainis Brjuhoveckis <
[email protected]> wrote:
> I have used http://poi.apache.org to generate Excel files from Java.
> It worked very well.
>
> Also http://jexcelapi.sourceforge.net looks good do to me.
>
> On Tue, Mar 30, 2010 at 2:05 PM, suren <[email protected]> wrote:
> > I have two different report files(say report1 and report2) in excel. I
> > want to merge these two excel files in single excel file with sheet1
> > for report1 and sheet2 for report2. Is there any way to do this in
> > java? if you have sample code please post it.
> >
> > --
> > To post to this group, send email to
> [email protected]
> > To unsubscribe from this group, send email to
> [email protected]<javaprogrammingwithpassion%[email protected]>
> > For more options, visit this group at
> http://groups.google.com/group/javaprogrammingwithpassion?hl=en
> >
> > To unsubscribe from this group, send email to javaprogrammingwithpassion+
> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> ME" as the subject.
> >
>
> --
> To post to this group, send email to
> [email protected]
> To unsubscribe from this group, send email to
> [email protected]<javaprogrammingwithpassion%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/javaprogrammingwithpassion?hl=en
>
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/javaprogrammingwithpassion?hl=en
