PJ, Thank you! That is very helpful and aligns very well with the XSSFSheet copyRows method in regards to use of CellCopyPolicy and CellCopyContext.
On Mon, May 12, 2025 at 5:49 PM PJ Fanning <fannin...@apache.org> wrote: > 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 <dsti...@gmail.com> 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/list?user@poi.apache.org:dfr=2020-1-1|dto=2025-5-12:HSSFSheet%20copy > <https://lists.apache.org/list?user@poi.apache.org:dfr=2020-1-1%7Cdto=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? > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > >