How do I read individual cell data from an excel sheet? I know how to extract the data from the .xls file and bind it to a gridview. But how do i extract data from a particular cell or column and save it in a local variable for instance.
I need this because i need to extract data from excel and insert it into a MySql database.
Read this : http://www.daniweb.com/forums/thread196171.html it has examples of write, but read should not be that hard.
There are many others on this site. Did you know this site has a search function? Try it out!
then read this too http://www.daniweb.com/forums/thread192620.html
i dont lack anything than ddanbe :)
Read this : http://www.daniweb.com/forums/thread196171.html it has examples of write, but read should not be that hard.
There are many others on this site. Did you know this site has a search function? Try it out!
Thanks. I'm new to this site. Didn't think of searching
Never to old to learn! Also look for the other "rules" and tips on how to post correctly.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.