Datatable to Excel
-
We have got the implementation to get excel document from the datatable. But want to format the cells and rows that datatable in the excel document. How?:confused: Sriharsha R
-
We have got the implementation to get excel document from the datatable. But want to format the cells and rows that datatable in the excel document. How?:confused: Sriharsha R
Hi Shrihari, You need to use Cell or Range object in Excel Object Model which you can do by creating automation clients for excel by adding reference of Excel Type liabrary to your project. Use the Liabrary to Create and modify the ExcelSheets according to your need. With warm regards, KEDAR
-
Hi Shrihari, You need to use Cell or Range object in Excel Object Model which you can do by creating automation clients for excel by adding reference of Excel Type liabrary to your project. Use the Liabrary to Create and modify the ExcelSheets according to your need. With warm regards, KEDAR
Thank you very much.. I got the perfect idea. But we are using Excel 2000 and hence we were not able to use that code. Thank u.... Regards Sriharsha R