RecalcXSLProcessor

de.isdss.util.processors.RecalcXSLProcessor

Top  Previous  Next

Parameter

class = de.isdss.util.processors.RecalcXSLProcessor

 

Recalculates the HSSFSheet ${sheet} in the .xls file ${filein}, from ${startcellid} to ${endcellid}, and saves the recalculated to the .xls file ${fileout}, located in the folder ${targetdir} Note: startcell must be to the (upper)left of endcell Note: formulas get changed to the values they calculate to.

 

Note: String formulas are not supported. attention: formulas that where extended across multiple cells in excel by dragging and letting excel automatically change the cells referenced in the formula don't recalculate properly, i suspect a bug in the HSSF library.

 

 

 

RecalcXSLProcessor