VB .NET Excel Manipulation

Posted on 2006-03-30
Last Modified: 2008-02-01
I'm looking for really good online resources on manipulating excel documents. I need to open existing excel documents and perform tasks such as unhiding hidden columns/rows, change print settings such as landscape/protrait, hiding cell borders, and a bunch more.

I'm googling, but nothing specific as yet, or titles of resources such as ebooks would help. I'm sure some of you guys got some links handy or have worked on similar projects.

Give me some help guys......
Question by:Squig
    LVL 14

    Expert Comment

    Try creating a reference to:
    Microsoft Excel 10.0 Object
    (it's a com object)

    From there you can create excel stuff.

    Actually I've never used it, but it seems like a way you might try out.
    LVL 48

    Expert Comment

    LVL 14

    Expert Comment

    LVL 14

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
    The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now