J
Jimmy
I have an Excel template (e.g. template.xls) file which has only 1
sheet, plus some macro codes. The sheet contains empty fields and
needed to be replicated (multiple sheet) w/ value filled in. Then,
remove the sheet (at index 0) at the end.
It was working fine till the macro codes updated. I'm getting
exception when trying to clone the sheet. Updated from 2.0.1 to
3.0.1, still not working.
Can I just clone sheet manually by copy cell-by-cell from template on
created-sheet, then populate the field? It should have no impact on
the macro cuz it's for the HSSFWorkbook. Is there a better way to do
it? There's no picture in the sheet but how can we have POI ignore
cell that it can't clone? Rather than just throw exception?
Thanks,
Jimmy
sheet, plus some macro codes. The sheet contains empty fields and
needed to be replicated (multiple sheet) w/ value filled in. Then,
remove the sheet (at index 0) at the end.
It was working fine till the macro codes updated. I'm getting
exception when trying to clone the sheet. Updated from 2.0.1 to
3.0.1, still not working.
Can I just clone sheet manually by copy cell-by-cell from template on
created-sheet, then populate the field? It should have no impact on
the macro cuz it's for the HSSFWorkbook. Is there a better way to do
it? There's no picture in the sheet but how can we have POI ignore
cell that it can't clone? Rather than just throw exception?
Thanks,
Jimmy