Hi All, I've been tasked with writing an app that can extract data from an .xlsx excel file and generate a .csv file from it , I've achieved it using interop but as ever my clients have introduced some business rules which blow the interop method out of the equation so I will have to find a way of reading the excel file row by row and cell by cell, I've googled and found a lot of free libraries such as NPOI which seems fairly good but the examples they provide are mainly for creating the files not processing them so I thought I would ask you people if you had any recommendations as to how to approach this.
Regards,
Peter J. Kane
Pete