How I connect to an Excel spreadsheet and search some value in it using VB.NET?
Talking to Office from .NET requires a little help. You'll need the Primary Interop Assemblies (PIA) for Office in order to easily make the calls from .NET. The PIA's are optimized to work with the managed to COM calls necessary to control Office. You can read more about them and download them by hitting the excellent article (with samples!) at MSDN library.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Get more information on VB.NET:
Learn how to access VB.NET Windows control on client side
Read about migrating to VB.NET
Get information about declarations in VB.NET
Get answers to you VB.NET FAQs
Read a guide about VB.NET development
Dig Deeper on .NET tutorials, guides and quizzes
Related Q&A from John Robbins
What is a JAD session? This term is referred to often in job postings and seems like some kind of brainstorm you carry out with a client to define IT...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.