export the content of a DataGrid

**Alessio** · Aug 6th, 2003, 03:19 AM

how I can directly to export the content of a DataGrid from the VB project in an Excel file ?

**lintz** · Aug 6th, 2003, 03:42 AM

Here is some code from eimroda....

Code:

Open "TestFile.xls" For output As #1
For i=0 to Grid.Rows-1
      print #1, Grid.TextMatrix(i, 0) & vbTab & Grid.TextMatrix(i,1) 'and so on
Next i
Close #1

**Alessio** · Aug 6th, 2003, 06:18 AM

ther is an error. It does not recognize the property of the object Grid.TextMatrix (TextMatrix it is not in the list of property)...)

**lintz** · Aug 6th, 2003, 08:23 AM

Grid is the name of your DataGrid....

**Alessio** · Aug 6th, 2003, 08:26 AM

yes

Thread: export the content of a DataGrid

Thread Tools

Display

export the content of a DataGrid

Posting Permissions