I am trying to perform excel activities when I appending the input to excel, Its showing me error “Number saved in Text Format”, as shown in below image.
When I am trying to convert range format using below vb code the format is changed to custom or general but this error is still persisting.
Dim excel As Microsoft.Office.Interop.Excel.Application 'Init Excel application
Dim wb As Microsoft.Office.Interop.Excel.Workbook ’ Init Excel Workbook
Dim ws As Microsoft.Office.Interop.Excel.Worksheet 'Init Worksheet
Dim ob As Microsoft.Office.interop.Excel.ListObject 'Init ListofObject
excel = New Microsoft.Office.Interop.Excel.ApplicationClass’create the instance of excel work book’
wb = excel.Workbooks.Open(“ExcelPath”)‘Open the excel the file’
ws=CType(wb.Sheets(“Sheet1”),Microsoft.Office.Interop.Excel.Worksheet)‘select a sheet and activiates’
Hi @AS07 !
I think you should work on the assign on that specific column before writing/appending range.
For instance, if you already have a loop in this specific datatable, using assign activity:
row(“nameofcolumn”) = myvalue (without the .tostring after it because this is what converts into a string)
If you did not put a .tostring, then maybe you should put CDbl(myvalue)
Would you mind sharing with us a screenshot on the assign for that specific column ?