Results 1 to 4 of 4

Thread: Import CSV to Excel with vb.net [2005]

Hybrid View

  1. Apr 6th, 2007, 11:22 AM #1
    campster
    campster is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2005
    Posts
    394

    Import CSV to Excel with vb.net [2005]

    If I want to import a CSV file into an Excel wooksheet do I have to move the data into a datatable first or can I place the data directly into Excel ?
    Reply With Quote Reply With Quote
  2. Apr 6th, 2007, 11:45 AM #2
    circuits2
    circuits2 is offline
    Frenzied Member circuits2's Avatar
    Join Date
    Sep 2006
    Location
    Kansas City, MO
    Posts
    1,027

    Re: Import CSV to Excel with vb.net [2005]

    You can do it either way, or you can program a macro to do it and then have your app fire the macro.
    Show the love! Click (rate this post) under my name if I was helpful.

    My CodeBank Submissions: How to create a User Control | Move a form between Multiple Monitors (Screens) | Remove the MDI Client Border | Using Report Viewer with Visual Studio 2012 Express
    Reply With Quote Reply With Quote
  3. Apr 6th, 2007, 11:50 AM #3
    campster
    campster is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2005
    Posts
    394

    Re: Import CSV to Excel with vb.net [2005]

    thanks

    I was pretty sure that it could be done but I'm having trouble finding examples of moving the file directly to Excel. I want to import the CSV to a worksheet and rename the worksheet. Do you have any links for examples?
    Reply With Quote Reply With Quote
  4. Apr 6th, 2007, 11:54 AM #4
    circuits2
    circuits2 is offline
    Frenzied Member circuits2's Avatar
    Join Date
    Sep 2006
    Location
    Kansas City, MO
    Posts
    1,027

    Re: Import CSV to Excel with vb.net [2005]

    Check out this thread by one of the moderators (RobDog):

    http://www.vbforums.com/showthread.php?t=358585
    Show the love! Click (rate this post) under my name if I was helpful.

    My CodeBank Submissions: How to create a User Control | Move a form between Multiple Monitors (Screens) | Remove the MDI Client Border | Using Report Viewer with Visual Studio 2012 Express
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width