read data from excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ilbossmancato
    New Member
    • Apr 2010
    • 2

    read data from excel

    Hi everyone,

    I need to write a code in C# that can read data inserted in excel file and the tool have to find all the same information in the columns and then have to group this in an other sheet.

    I want to know if is it possible and if anyone can help me.
    I am avaible for more details.

    Thank you in advance!
  • donbock
    Recognized Expert Top Contributor
    • Mar 2008
    • 2427

    #2
    From Excel, store a copy of the spreadsheet in CSV (comma separated value) format.
    Have your program read that file and output a revised spreadsheet, also in CSV format.
    Open the outputted CSV file in Excel and save it back as an Excel file.

    Comment

    Working...