how to export datagrid data into excel ??

Question

Hi, I m developing WINDOWS application. In this I m using XML to fill DATAGRID. Now I want to export this datagrid data into Excel sheet. But I have no idea how to do it? Can one guide me ??? send me code please. Thank you, bhavin

Answer 1

excelSheets = excelWorkBook.Sheets("Sheet1")

excelSheets.Activate()

excelSheets.Shapes.Item(1).ControlFormat.List

Like this way you can find the different shapes (controls). Put a break point and check the values..