Re: How to copy an HSSFSheet into another HSSFSheet which belongs to a different HSSFWorkbook.
PJ Fanning <[email protected]> Mon, 12 May 2025 22:48:50 +0100
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Message-ID | <CAMRKCNG431NrP6=KuNYbYqvoFe__crQCfwONumTwLHN0H6tQXw@mail.gmail.com> |
There is copyRowFrom in HSSFRow. https://poi.apache.org/apidocs/dev/org/apache/poi/hssf/usermodel/HSSFRow.html#copyRowFrom-org.apache.poi.ss.usermodel.Row-org.apache.poi.ss.usermodel.CellCopyPolicy-org.apache.poi.ss.usermodel.CellCopyContext- On Mon, 12 May 2025 at 21:54, Dan S <[email protected]> wrote: > > XSSFSheet has a copyRows method which allows for copying the contents of > one XSSFSheet to another one. I do not see an equivalent method for an > HSSFSheet. I see from this post > <https://lists.apache.org/[email protected]:dfr=2020-1-1|dto=2025-5-12:HSSFSheet%20copy> > a solution which allows copying for HSSFSheet and XSSFSheet. I just want to > make sure if that is a recommended way for HSSF and if not has there been > any change to POI that provides methods for this?