Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
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.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - export grid to excel

Reply
 
Old 11-25-2008   #1 (permalink)
Rob


 
 

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 SpecsSystem Spec
Reply

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


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46