How can I expoet a particular sheet to an existing excel and i need to append it to excel. not override...
DataTable.ExpostSheet filepath, "Global" with override existing data in excel.
There are no built in methods available. You can perform the appending operation after you export the data sheet, using Excel Object.
Import the sheet append the required data then export the sheet.
Winds of Change