Hi,
In my project we allow users to download excel file (generated by using aspose) to get data from database unsing importDataTable.
While exporting data to excel for one column i created formula so that when user changed value in other cells it will be summed.
Ex:
worksheet.Cells(“M4”).Formula() = "=SUM(N4 “:BD4”)"
So after getting report if i change value then it is working perfectly.
Same report(Modified) should be imported to data base again.
So i imported changed data to dataTable and by reading from datatable i am saving the data.
But while reading column “M4” it is throwing error as “Input string was not in a correct format”
Can some one please help on fix