2009•Unpublished venueRequires access

Automation Programming of Excel in VB.NET

Feng Guang-yan

Abstract

This paper introduces briefly the automation programming of Excel and discusses in derail the technique base and thoughts in implementation. By a VB.net program instance, the importation of data in a database into Microsoft office excel is realized,the Excel worksheets are formatted and the data processing is implemented by using the built-in functions of Microsoft office excel.This paper gives the V-B.NET program which realizes the automation function.

About this research paper

What this paper is about

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: Computer science, Automation, Microsoft excel, Programming language, Operating system, Software engineering, Visual Basic for Applications, Office automation