Results 1 to 4 of 4

Thread: How can i export datatable to excel

  1. #1
    Join Date
    Dec 2007
    Posts
    38

    How can i export datatable to excel

    Hi,
    I want to know that how can i export the datatable to ms excel?
    Is there any quice way to do this? or delimited the file?
    Where is the appropriate Microsoft monitored group to ask about
    writing reports in SQL Reporting services or SQL Server
    Business Intelligence Development Studio or whatever it's called?

  2. #2
    Join Date
    May 2008
    Posts
    115

    Re: How can i export datatable to excel

    It's going to be slow compared to native VBA code. There are a few ways to
    do thiis...the best of which is to query the DataBase
    directly from Excel.
    If you check out www.aspnetPRO.com (October 2003) they discuss Exporting to
    Excel in depth, albiet primarily from the perspective of ASP.NET.

  3. #3
    Join Date
    Dec 2007
    Posts
    38

    Re: How can i export datatable to excel

    I should have made this clearer. I mean a datatable in VB.net.
    dim mydt as new datatable
    myodbcdataadapter.fill(mydt)
    do some processing then export to excel.

  4. #4
    Join Date
    May 2008
    Posts
    115

    Re: How can i export datatable to excel

    If we want to use the System.Web.UI.WebControls in the console or windows
    form VB.NET application. We need to add a reference to System.Web assembly.
    To reference this assembly in VB.NET 2008, we open the Solution Explorer
    Window, right click our project and choose Add Reference option. Then, the
    Add Reference dialog pops up. In the .NET tab, we find and select the
    System.Web, and click the OK button. Afterwards, we can use the
    System.Web.UI.WebControls.DataGrid.

Similar Threads

  1. How to export ical to excel
    By Xmen in forum Windows Software
    Replies: 5
    Last Post: 02-09-2010, 07:41 AM
  2. php export to excel
    By Derwin in forum Software Development
    Replies: 3
    Last Post: 25-08-2009, 06:25 PM
  3. Export OLE object to Excel?
    By Kelsey in forum Windows Software
    Replies: 3
    Last Post: 31-03-2009, 09:29 PM
  4. Exporting datatable to excel with ADO.net
    By Sanket07 in forum Software Development
    Replies: 2
    Last Post: 03-02-2009, 05:52 PM
  5. Export to Excel
    By nehal_serpa in forum Microsoft Project
    Replies: 6
    Last Post: 11-12-2008, 12:44 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,642,741,254.82155 seconds with 17 queries