Extract data from excel

Discussion in 'ASP .Net' started by =?Utf-8?B?QmVnaW5uZXI=?=, Jun 30, 2005.

  1. hihi

    While I am developing ASP.NET using C#
    I want to import a excel file and make some modification and then generate a
    report
    however, I can't use SQL command as the excel file does not have a field name
    and so everytime I need to display the whole list

    And someone suggest me to use ODBC to solve it as the first row can be use
    as field name, is it work?And would you provide the code?I need to do some
    modification 'cause each time it will link to a distinct excel file

    Moreover, after I fill a DATATABLE, can i extract some data like an array?
    or can I set up field name of the table

    I am new in this field and would u mind explain more detail plz
    Thanks so much
    =?Utf-8?B?QmVnaW5uZXI=?=, Jun 30, 2005
    #1
    1. Advertising

  2. Hi there,

    Maybe you are interested in following URL:

    http://msdn.microsoft.com/library/d...tskcodeexamplereadingexceldataintodataset.asp

    HTH

    Elton Wang



    "Beginner" wrote:

    > hihi
    >
    > While I am developing ASP.NET using C#
    > I want to import a excel file and make some modification and then generate a
    > report
    > however, I can't use SQL command as the excel file does not have a field name
    > and so everytime I need to display the whole list
    >
    > And someone suggest me to use ODBC to solve it as the first row can be use
    > as field name, is it work?And would you provide the code?I need to do some
    > modification 'cause each time it will link to a distinct excel file
    >
    > Moreover, after I fill a DATATABLE, can i extract some data like an array?
    > or can I set up field name of the table
    >
    > I am new in this field and would u mind explain more detail plz
    > Thanks so much
    =?Utf-8?B?RWx0b24gVw==?=, Jun 30, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John Machin
    Replies:
    15
    Views:
    731
  2. Replies:
    3
    Views:
    878
    James Kanze
    Jun 20, 2007
  3. Prakash
    Replies:
    4
    Views:
    1,303
    Alan Meyer
    Oct 5, 2011
  4. anne001
    Replies:
    12
    Views:
    276
    Martin DeMello
    Nov 28, 2005
  5. FD3S

    Extract data from an Excel file

    FD3S, Jan 13, 2006, in forum: Perl Misc
    Replies:
    5
    Views:
    119
    Tim Berke
    Jan 25, 2006
Loading...

Share This Page