poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cheenu <sm88il-nore...@yahoo.com>
Subject Re: how to combine two workbooks
Date Sat, 26 Aug 2006 05:36:31 GMT
Yaahhhoooooooooo!!

Found a perfectly working copySheet code for POI - atleast for my needs.
http://jxls.cvs.sourceforge.net/jxls/jxls/src/java/org/jxls/util/Util.java?view=markup

method copySheets.

Nice job jXLS contributors, in this case Leonid Vysochyn.
Thanks.

On 8/25/06, Cheenu < sm88il-noreply@yahoo.com> wrote:
>
> Something like the cloneSheet method cannot be used, as it seems like the
> BIFF fileformat is more complicated than that.
> I think it would be more safer and API compliant to do something like the
> attached code.
> But, it is far from complete - one main problem is that there is no way to
> copy over Workbook styles.
> Seems like in BIFF all styles are kept at workbook level and not at sheet
> level.
>
>
> On 8/25/06, Sebastian Frehmel < uhbdz@stud.uni-karlsruhe.de> wrote:
> >
> > I'm sorry, but I dont't think I will be able to post code here within
> > the next 3 weeks because I've got other, way more important stuff to do.
> > But what came in to my mind is the cloneSheet method.
> > This method is used to clone a sheet within a workbook But if someone
> > looked into the source code a little deeper, this someone might probably
> >
> > find a way to return the sheet to another workbook.
> > Do you have time and knowledge for this?
> >
> > Cheenu schrieb:
> > > Sebastian,
> > > Seems like there is no way to do this than copying cell by cell.
> > > JExcelApi does not provide a way as well -
> > > http://groups.yahoo.com/group/JExcelApi/message/8069
> > >
> > > Can we exchange code to get the best possible way to do this?
> > > I will code something up and post it here.
> > >
> > > Cheenu
> > >
> > > On 8/24/06, Sebastian Frehmel <uhbdz@stud.uni-karlsruhe.de > wrote:
> > >>
> > >> This is a feature I miss, too.
> > >> Just the possibility to say something like:
> > >> wb.addSheet(HSSFSheet a)
> > >>
> > >> Until now I had to copy all cells manually....
> > >> Does anyone know how?
> > >>
> > >> Cheenu schrieb:
> > >> > I have two HSSFWorkbook objects, each having one HSSFSheet.
> > >> > I want to create a third HSSFWorkbook containing two sheets (one
> > from
> > >> > each
> > >> > of the workbooks).
> > >> >
> > >> > I could not find a way to do this from the API - am I missing
> > >> something.
> > >> >
> > >> > A code snippet to explain the same:
> > >> >
> > >> > HSSFWorkbook hrWorkBook = getDepartmentDetails("HR");
> > >> > HSSFWorkbook financeWorkBook = getDepartmentDetails("Finance");
> > >> >
> > >> > HSSFWorkbook finalWorkBook = ???;   // I want to somehow create
> > this
> > >> > finalWorkBook with the one sheet from the hr and finance workbook
> > >> >
> > >> > Thanks
> > >> > Cheenu
> > >>
> > >> ---------------------------------------------------------------------
> > >> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > >> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> > >> The Apache Jakarta Poi Project:   http://jakarta.apache.org/poi/
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project:   http://jakarta.apache.org/poi/
> >
> >
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message