Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > Visual Basic.Net > Office Documents
Search:
What's New - What's Hot
Listings for Excel Excel (12)
Listings for General General (9)
Listings for Power Point Power Point (2)
 


HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using Visual Basic .NET     
Total Hits: 98  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to build a tab-delimited text file dynamically from a database that can be opened in Microsoft Excel. The example in this article demonstrates how to connect to a Microsoft SQL Server database, to return a set of data from the Pubs database, and to create a tab-delimited text file with the data....

HOW TO: Modify XML Data by Using DOM in .NET Framework with Visual Basic .NET     
Total Hits: 123  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to use the System.Xml.XmlDocument class and the related classes to programmatically modify Extensible Markup Language (XML) documents.

XML content can be classified broadly into a collection of nodes and attributes of the nodes. You can modify the content by modifying the nodes or attributes. The System.Xml.XmlDocument class implements the core XML DOM parser of the .NET Framework. This class is compliant with the World Wide Web Consortium (W3C) Doc...

HOW TO: Access Protected Document in Document Function of XSLT Using Visual Basic .NET     
Total Hits: 92  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to create an instance of and supply a custom XmlUrlResolver class to resolve document() function references to external XML resources that are located on authenticated Web sites or folders....

How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays     
Total Hits: 154  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to automate Microsoft Excel and how to fill a multi-cell range with an array of values. This article also illustrates how to retrieve a multi-cell range as an array by using Automation....

The Dsofile.dll files lets you edit Office document properties when you do not have Office installed     
Total Hits: 148  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Dsofile.dll sample file is an in-process ActiveX component for programmers that use Microsoft Visual Basic .NET or the Microsoft .NET Framework. You can use this in your custom applications to read and to edit the OLE document properties that are associated with Microsoft Office files, such as the following:
• Microsoft Excel workbooks
• Microsoft PowerPoint presentations
• Microsoft Word documents
• Microsoft Project projects
• Microsoft Visio drawings
• Other files that a...

How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET     
Total Hits: 1237  |  Today: 0Author: Microsoft      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this article provides the information that you need so that you can use the Jet OLE DB provider when Excel is the target data source....

HOW TO: Send Raw Data to a Printer by Using Visual Basic .NET     
Total Hits: 1700  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article shows you how to use Win32 spooler functions from a program that you create by using Visual Basic .NET....

HOWTO: Handle PowerPoint Events With Visual Basic .NET     
Total Hits: 1403  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to automate PowerPoint and handle events using Visual Basic .NET.
...

HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET     
Total Hits: 10522  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to display data from an Excel worksheet through an ASP.NET (.aspx) page by using Visual C# .NET....

HOW TO: Transfer Data to an Excel Workbook by Using Visual Basic .NET (Q306022)     
Total Hits: 5025  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes numerous methods for transferring data to Excel 2000 or Excel 2002 from a Visual Basic .NET application. This article also presents the advantages and disadvantages of each method so that you can choose the solution that works best for your situation....

HOW TO: Handle Events for Excel by Using Visual Basic .NET (Q302814)     
Total Hits: 1575  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to handle Excel events from an Automation client that is developed with Visual Basic .NET....

HOWTO: Automate Excel From Visual Basic .Net To Fill or Obtain Data In a Range Using Arrays (Q302094)     
Total Hits: 2603  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to automate Excel and fill a multi-cell range with an array of values. This article also illustrates how to retrieve a multi-cell range as an array by using Automation....

HOW TO: Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET (Q316934)      
Total Hits: 4586  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this article provides the information that you need so that you can use the Jet OLE DB provider when Excel is the target data source.
...

HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET and Visual Basic .NET (Q311731)     
Total Hits: 3185  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to display data from an Excel spreadsheet through an ASP.NET (.aspx) page by using Visual Basic .NET....

HOWTO: Automate Microsoft Excel from Visual Basic .NET (Q301982)     
Total Hits: 3008  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to create an Automation client for Excel using Visual Basic .NET. Automation is a process that allows applications that are written in languages such as Visual Basic .NET to programmatically control other applications. Automation to Excel allows you to perform actions such as creating a new workbook, adding data to the workbook, or creating charts. With Excel and other Microsoft Office applications, virtually all of the actions that you can perform manually through ...

HOWTO: Use Automation to Get and Set Office Document Properties with Visual Basic .NET (Q303294)     
Total Hits: 3227  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article illustrates how to automate Word with Visual Basic .NET to retrieve and manipulate document properties. Although the sample in this article is specifically written to automate Word, the same concepts can be applied to Excel and PowerPoint....

Q304661 - BETA-HOWTO: Binding for Office Automation Servers with Visual Basic .NET     
Total Hits: 758  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you automate an application such as a Microsoft Office application, the calls to the properties and methods of the Office application's objects must be connected in some way to those objects. The process of connecting property and method calls to the objects that implement those properties and methods is commonly called binding. In Visual Basic .NET, the two types of binding that are available are early binding and late binding. The type of binding you choose can affect many aspects of your...

Q303871 - BETA-HOWTO: Create an Excel Macro Using Automation from Visual Basic .NET     
Total Hits: 2118  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how you can automate Excel from Visual Basic .NET to create a workbook that contains a new macro associated with a CommandBar button....

HOWTO: Use VB .NET to Create and Show a PowerPoint Presentation - Q303717     
Total Hits: 1396  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how you can automate PowerPoint from Visual Basic .NET to create and show a PowerPoint presentation....

Q302814 - BETA-HOWTO: Handle Events for Microsoft Excel Using Visual Basic .NET     
Total Hits: 933  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article illustrates how to handle Excel events from an Automation client that is developed with Visual Basic .NET....



Disclaimer - Privacy
© 2002-2017 DevASP.net