TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Alun
NA
3
0
Newbie needs help...Find a line in xls file and display other columns
Dec 12 2006 6:09 PM
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.
Reply
Answers (
2
)
Crystal Reports
Help automatcally updating an inherited field variable whenever any other field is changed?