excelapache-poinotimplementedexception

Using cloneSheet with poi SXSSF

I am using SXSSF to write large numbers of data in one excel-File.

I have seen that 'cloneSheet' method isn't implemented:

/**
 * Create an Sheet from an existing sheet in the Workbook.
 *
 * @return Sheet representing the cloned sheet.
 */
public Sheet cloneSheet(int sheetNum)
{
    throw new RuntimeException("NotImplemented");
}

But I don't understand why. Is it logically correct that it's missing? Or is it a bug?

I look forward to your answers and help to be able to clone sheets with SXSSF.

Best Regards, Louisa.

Solution

  • Thank you @Gagravarr: "SXSSF only does things that can work in a streaming manner, which cloning can't."

    I resolve it to have all sheets in my Excel template first, and when I don't use them, I remove them....