Browse by Tags

All Tags » Excel

  • VSTA and LINQ to XML with Excel

    VSTA 2 can be used to extend a host application to use LINQ in a variety of ways.  One example of this is to use LINQ to XML to use an XML file as input.  LINQ to XML is doubly convenient because Office products, such as Excel 2007, work well with XML files. Using LINQ to XML to input data that was created or manipulated in an ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on April 15, 2008

  • ShapeAppCSharp Add-In: Excel Data Entry- Updated with Beta Fix

    This sample demonstrates the use of VSTA to extend a host applicaiton to use a technology, Excel, without any changes being made to the host.  The add-ins included use an Excel 2003 spreadsheet as a data entry form.  To use Office applications in VSTA, add references to the appropriate assemblies.  For VSTA v 1, to add a ...
    Posted to VSTA Samples (FileGallery) by melody on January 22, 2008

  • Using VSTA to extend a host with Office

    VSTA can be used extend a host to use a new technology, like an Office application, without requiring any changes in the host.  One benefit of this is that the host is now compatible with any technology that can be accessed by an add-in.One example of this would be to use an Excel spreadsheet to enter data.  We have a simple example of ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on January 21, 2008