Thanks for getting back to me
In the following code I create a datatable and thne use smart tags to place the fields in the spreadsheet. By default all the values are positive. If the value of field name Rejecteddebit, is >'0' I want to convert the values of fin_mnthtotalbrok, fin_monthly0, fin_pliab, fin_fun1, fin_ppa toa negative(-).
Could you explain how I can do this, and include them in the spreadsheet, using your previous suggestion.
Thank you so much for your help
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
'Instantiate an instance of license and set the license file through its path
Dim license As Aspose.Cells.License = New Aspose.Cells.License()
Dim myCommand As OleDbCommand
Dim dataReader As System.Data.OleDb.OleDbDataReader = Nothing
'Instantiating an WorkbookDesigner object
Dim designer As WorkbookDesigner = New WorkbookDesigner()
'Open a designer spreadsheet containing smart markers
designer.Open(Server.MapPath("~/reports/monthlyrecon.xls")) ' please make sure the file is placed on the correct path
'Set the data source for the designer spreadsheet
'Process the smart markers
designer.Workbook.Save("Report.xls", FileFormatType.Default, Aspose.Cells.SaveType.OpenInExcel, Response)