java - apache poi how to refresh the entire workbook -
my workbook contains more 10 sheets, sheets formulated takes data odd numbered sheet.
i'm writing data odd numbered sheet (1 3 5 7.....) @ end, want refresh entire workbook automatically all, numbered (0,2,4,6...) sheets data next page.
i have tried hssfformulaevaluator.evaluateallformulacells
(workbook) not working.
how refresh entire workbook, formulated cells evaluated @ once?
are able use *.xlsx format instead , work code?
xssfformulaevaluator.evaluateallformulacells(workbook);
this solved similar problem having.
Comments
Post a Comment