Write Cell _Error Occurs

CHAN_Hiu_Fung_Victor_Stud · November 19, 2023, 6:30pm

Hello guys, anyone know what’s wrong is it? Thank you

Shiva_Nikhil · November 19, 2023, 6:56pm

Check whether the dt1 has data or not

And you are writing on the Cell B1 means is the headers of the excel is it right you are expecting

Nguyen_Van_Luong1 · November 20, 2023, 1:14am

Hi @CHAN_Hiu_Fung_Victor_Stud ,
Let check by messages box first
dt1.row(0).item(3).toString

Or simple you can try write cell with activity of workbook or excel classic

Can use If, check if dt1.row(0).item(3).toString not null before write to cell
regards,

Yogeesh_G · November 20, 2023, 2:59am

Hi

Check the data “dt1.row(0).item(3).toString”
before writing into excel table having any data or not and then write into excel

Thank you

sanjay3 · November 20, 2023, 4:25am

Put a breakpoint in that activity and run in debug mode
check the value in local or watch panel
check which variable having null value