![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | export grid to excel Hi i'am trying to export the data of a datagrid into excel using a commandbuttum. I can open an empty excelfile , but i cannot put the dato into an excel worksheet. i found this on the web, but this opens only excel on worksheet1 How ca i put my data into the worksheet ? regards, ROb Try Dim oApp As New Excel.Application Dim oBook As Excel.Workbook = oApp.Workbooks.Add Dim oSheet As Excel.Worksheet = CType(oBook.Worksheets(1), Excel.Worksheet)--- oApp.Visible = True Catch ex As Exception MessageBox.Show("Source [" & ex.Source & "] Description [" & ex.Message & "]") End Try End Sub |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| RE: Export from AD to excel filter by group | VB Script | |||
| VB.NET: export query directly to Excel | .NET General | |||
| VB :Export datagrid to excel | .NET General | |||
| Export to Excel truncates numbers | .NET General | |||