val d = new File(s"$complexReportPhysicalPath/$resourceId")
val file = d.listFiles.filter(_.isFile).find(file => file.getName.endsWith("xlsx") ||
file.getName.endsWith("xlsm"))
val inputStream = fileSystemUtil.getFileInputStream(file.get.getPath)
val wb = new Workbook(inputStream)
inputStream.close()
val designer = new WorkbookDesigner(wb)
designer.setCalculateFormula(true)
designer.process()
val fileBaseName = "s"$complexReportPhysicalPath/$resourceId""
val opts = new HtmlSaveOptions
opts.setExportImagesAsBase64(true)
opts.setExportGridLines(true)
designer.getWorkbook.save(fileBaseName + ".htm", opts)
hi above is a simple smart marker process scala code, its process excel template document is as below:
pxtest1.xlsx.zip (8.8 KB)
it has two hidden columns C and D, and row 1 is merged from A to D, after process the hidden columns
are still visible in rendered html result. Is this is a bug ? I would like a result in which hidden columns are still hidden. Hope your help. please I will be thankful