[Solved] How can I Export a datatable to an excel sheet with user-defined row no of the excel sheet from c#?
I tried this one I got the answer. For those who downvoted my question, there is a possible to do the way. First you should think the route and work private static Microsoft.Office.Interop.Excel.Workbook mWorkBook; private static Microsoft.Office.Interop.Excel.Sheets mWorkSheets; private static Microsoft.Office.Interop.Excel.Worksheet mWSheet1; private static Microsoft.Office.Interop.Excel.Application oXL; public static void ReadExistingExcel() { string path = @”C:\Tool\Reports1.xls”; … Read more