[Advanced Excel] Any example of using this?

[Advanced Excel] Any example of using this?

Forge Component
Published on 2016-11-05 by João Rosado
22 votes
Published on 2016-11-05 by João Rosado
Any sample project showing getting the excel file as binary file then selecting the workbook then changing the cell value?
still no example?

Does anyone have an example of using this component. There was no sample in the download.



Any example to use this ?

There is a separate component in the Forge called AdvancedExcel_Sample that has a few examples. I managed to create a new Excel, fill a cell and download it. I'm now trying to get the action ExportUsingTemplate from the sample working, but haven't succeeded yet.

Oh, and I think I encountered a bug: Cell_WriteByIndex has parameters CellValue and CellType. In my testcase, the value of CellType ended up in the cell, and CellValue seems to be ignored.