V1.00 was uploaded to the first post. You can create number and formula cells.
hmmmCan you upload the excel file?
cell.InitializeFormula(3, i+4, "=OFFSET(INDIRECT(""RC"",FALSE),-1,0)") editSheet.AddCell(cell)
Dim FormulaString As String = "=OFFSET(INDIRECT(" "E & "RC" "E & ",FALSE),-1,0)"
cell.InitializeFormula(3, i+4, "=SUM(B5+B6)") cell.InitializeFormula(3, i+5, "=SUM(D6:D8)")
Dim FormulaString As String = "=OFFSET(INDIRECT('RC',FALSE),-1,0)"
cell.InitializeNumber(3, i+4, LastCausticLevel)
Dim FormulaString As String = "=OFFSET(INDIRECT(" "E & "RC" "E & ",FALSE),-1,0)" cell.InitializeFormula(3, i+4, FormulaString) editSheet.AddCell(cell)
Thank you Erel,According to this discussion: http://stackoverflow.com/questions/12030624/emptystackexception-for-formula-parsing-in-jexcel you should remove the equal sign.
On this page: http://stackoverflow.com/questions/10872112/jexcel-formula-calculation-error?rq=1When you add a formula, this formula will be computed, but only in Excel, when you open the generated file in Excel. The cell is not computed by JExcel.
As far as I know, you can only put numbers(double), strings and formulae(Excel) into a spreadsheet.Does this library allow importing HTML into a new sheet? For example I grab a report that is formatted in html (table) and I want to put it in excel format so user can so whatever they want with it.
Try Dim i As Intent i.Initialize(i.ACTION_VIEW, "file://" & File.Combine(File.DirRootExternal, "1.xls")) i.SetType("text/xls") StartActivity(i) Catch ToastMessageShow("No matching application.", True) Log(LastException) End Try