Newbie needs help...Find a line in xls file and display other columns
Hello one and all,
As will become evident, I'm a newbie at all this, however I have taken the plung to write an application for my own uses in C#! At the moment I have an application that runs, it has several textboxes and buttons, and I've set it so when I press certain buttons, I can browse to a xml file and read parts of the file and that data goes into some of the textboxes. other buttons then take the data form the textboxes and create .txt files. Happy with that!
What I would like to add is the abbility to have an Excel spreadsheet as a database so that when a button is pressed, the program checks the value of one of my textboxes (the value been alphanumeric) and searches down the first column of my xsl file and when it finds a match, it reads the other cells of that particular row and adds the values of those celles into seperate textboxes on my form. Not much eh?
Code with explanations would be muchly appreciated!
Cheers
Alun
P.S. if it's easier, I can export from Excel 2003 into csv or xml.