Parsing Excel documents with C#

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • svictorov@mail.ru
    #1

    Parsing Excel documents with C#

    Hello everybody,
    here is a question I have to deal with :

    In brief, I have an Excel document which consists of 3 sheets ( with
    the same names for each document ).
    The document always has fixed format except for number of rows, but it
    doesn't have a correct table
    format. I mean that each sheet has its own header ( filled with
    insignificant information ) and table of
    important data after header.
    How I can get an access to the data of the sheet row by row or is that
    possible to use
    SQL statements to get the data from table inside of Excel sheet. Note
    that the sheet doesn't have a correct table structure but I suppose it
    can't be represented as table of strind fields, but it's not a good
    idea because there are many formulas inside of the document.

    Thanks in advance.

    Tags: None
    • Fredo
      #2
      Re: Parsing Excel documents with C#

      Here's a basic explanation:

      http://www.codeproject.com/csharp/csharp_excel.asp


      Pete Davis

      <svictorov@mail .ruwrote in message
      news:1160996501 .971704.166580@ b28g2000cwb.goo glegroups.com.. .
      Hello everybody,
      here is a question I have to deal with :
      >
      In brief, I have an Excel document which consists of 3 sheets ( with
      the same names for each document ).
      The document always has fixed format except for number of rows, but it
      doesn't have a correct table
      format. I mean that each sheet has its own header ( filled with
      insignificant information ) and table of
      important data after header.
      How I can get an access to the data of the sheet row by row or is that
      possible to use
      SQL statements to get the data from table inside of Excel sheet. Note
      that the sheet doesn't have a correct table structure but I suppose it
      can't be represented as table of strind fields, but it's not a good
      idea because there are many formulas inside of the document.
      >
      Thanks in advance.
      >

        Comment

        • Frost
          #3
          Re: Parsing Excel documents with C#

          Thanks a lot !!!
          Very useful article.

          "Fredo писал(а):
          "
          Here's a basic explanation:
          >
          http://www.codeproject.com/csharp/csharp_excel.asp

          >
          Pete Davis
          >
          <svictorov@mail .ruwrote in message
          news:1160996501 .971704.166580@ b28g2000cwb.goo glegroups.com.. .
          Hello everybody,
          here is a question I have to deal with :

          In brief, I have an Excel document which consists of 3 sheets ( with
          the same names for each document ).
          The document always has fixed format except for number of rows, but it
          doesn't have a correct table
          format. I mean that each sheet has its own header ( filled with
          insignificant information ) and table of
          important data after header.
          How I can get an access to the data of the sheet row by row or is that
          possible to use
          SQL statements to get the data from table inside of Excel sheet. Note
          that the sheet doesn't have a correct table structure but I suppose it
          can't be represented as table of strind fields, but it's not a good
          idea because there are many formulas inside of the document.

          Thanks in advance.

            Comment

            Previous template Next
            Working...