Show column Headers ImportDataGrid()


#1

Hello

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" />

Thanks,

-Randy

I’m using version 2.5.5.2


#2

Hi Randy,

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