I am facing a issue while Exporting the Excel-Shhet.

DataTable.Value("Step_name",3) = Step_name

DataTable.Value("Status",3) = Trim(Status)

DataTable.Value("Expected_Result",3) = Trim(Expected)

DataTable.Value("Actual_Result",3) =trim( Actual)

DataTable.Value("Comment",3) = Comment

DataTable.Value("Date_Time",3) = Now

'Save the sheet to Report.xls
DataTable.ExportSheet Data_Sheet ,4

Now while Export ,the Comment coloumn is coming as blank.

I cheket it with Debug Viewer..and we are getting the Expecting value of Comment..but while Exporting it..In excel-sheet the Respective Column is coming Blank.