Results 1 to 2 of 2

Thread: another read from excel question

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2001
    Posts
    138

    another read from excel question

    Hi gurus

    I need to read information from excel and them put them into a text file,I have the part for text file done and write to it but I dont know how to go and read from an excel file where every row is a diferent record, so I need to read the entire row and put every cell on variables so I can get my fixed text file done.

    Hope I make sense with my english 101

    Thanks a bunch gurus

    VS2003

  2. #2
    Frenzied Member mickey_pt's Avatar
    Join Date
    Sep 2006
    Location
    Corner of the Europe :)
    Posts
    1,959

    Re: another read from excel question

    Hello
    First you need to add reference to the Excel, project properties, add reference, microsoft.office.interop.excel, then you need to instantiate a new class of the excel, add vars to the workbook and to the worksheet, then just interact with the cells that you need.

    Samples HERE AT MSDN

    Good luck

    Rate People That Helped You
    Mark Thread Resolved When Resolved

Posting Permissions

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



Click Here to Expand Forum to Full Width