Show column Headers ImportDataGrid()



Is there a way to have the column headers added to a new excel sheet when using Excel.Worksheets(0).Cells.ImportDataGrid() like ImportDataTable()? Also, automatically import the DataGrid footer (where column totals are usually) would be great.

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />



I’m using version


Hi Randy,

I have checked MSDN but cannot find a way to get the column headers and footers.