Is there anyway that we can export only activated row from Datatable to a particular Excel sheet instead of Exporting entire sheet?
I guess there is no direct way to export a single row using the datatable methods.
But can be done using a temp datatable sheet.
May b u can try to get the ParameterCount, iterate through all the columns and retrieve cell values store them in an array and push them to excel.
Winds of Change