•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 392,094 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,867 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our VB.NET advertiser:
Views: 1280 | Replies: 4
 |
•
•
Join Date: Dec 2006
Location: United States
Posts: 612
Reputation: 
Rep Power: 3
Solved Threads: 14
DaniWeb Expert
hi,
I want to export data to Excel from Dataset and DataGrid and format the output excel file like "Auto Fit" for coulns, Bold headers and also control the Cells.
Please dont suggest using Interop Calls.
I understand that we can use the RenderControl to write to the htmltextwriter so may be someone can enhance on this.
I need the .NET equivalent.
I want to export data to Excel from Dataset and DataGrid and format the output excel file like "Auto Fit" for coulns, Bold headers and also control the Cells.
Please dont suggest using Interop Calls.
I understand that we can use the RenderControl to write to the htmltextwriter so may be someone can enhance on this.
I need the .NET equivalent.
Last edited by binoj_daniel : Aug 16th, 2007 at 3:07 pm.
•
•
Join Date: Dec 2006
Location: United States
Posts: 612
Reputation:
Rep Power: 3
Solved Threads: 14
DaniWeb Expert
I have a limitation. i cannot use any thirdparty component. Any other idea?
•
•
Join Date: Apr 2008
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by binoj_daniel 
hi,
I want to export data to Excel from Dataset and DataGrid and format the output excel file like "Auto Fit" for coulns, Bold headers and also control the Cells.
Please dont suggest using Interop Calls.
I understand that we can use the RenderControl to write to the htmltextwriter so may be someone can enhance on this.
I need the .NET equivalent.
you can export from datagridview to excel
For i = 0 To DataGridView1.RowCount - 2
For j = 0 To DataGridView1.ColumnCount - 1
xlWorkSheet.Cells(i + 1, j + 1) = _
DataGridView1(j, i).Value.ToString()
Next
Next
follow this :
http://vb.net-informations.com/excel...w_to_excel.htm
•
•
Join Date: Dec 2006
Location: United States
Posts: 612
Reputation:
Rep Power: 3
Solved Threads: 14
DaniWeb Expert
As i wrote in my original post Please dont suggest using Interop Calls. Also Iam looking for formatting techniques.
•
•
•
•
Originally Posted by ericsonvv
you can export from datagridview to excel
For i = 0 To DataGridView1.RowCount - 2
For j = 0 To DataGridView1.ColumnCount - 1
xlWorkSheet.Cells(i + 1, j + 1) = _
DataGridView1(j, i).Value.ToString()
Next
Next
follow this :
http://vb.net-informations.com/excel...w_to_excel.htm
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb VB.NET Marketplace
Linear Mode
- Need help on export asp.net table to excel (ASP.NET)
- export excel sheet as a csv (Perl)
- Export to Excel from ASP.NET app (ASP.NET)
- help needed to show Excel graphs (only) in VB window (Visual Basic 4 / 5 / 6)
- Exporting Data from App To Excel c# (C#)
- Specify row/columns when export to Excel from DataGrid? (ASP.NET)
- Export from Excel help needed (Mac Software)
- How to export excel data to a search engine? (MS Access and FileMaker Pro)
Other Threads in the VB.NET Forum
- Previous Thread: Go to specific control
- Next Thread: How do I get msi net installer to register 3rd party ocx
