Method for automatically operating Excel based on Microsoft COM component

An excel and component technology, applied in natural language data processing, instruments, calculations, etc., can solve problems such as low compression rate, Excel size limit, poor performance, etc., to achieve stability and efficiency improvement, improve stability and efficiency , parameter prompt clear effect

An excel and component technology, applied in natural language data processing, instruments, calculations, etc., can solve problems such as low compression rate, Excel size limit, poor performance, etc., to achieve stability and efficiency improvement, improve stability and efficiency , parameter prompt clear effect

CN113627140APending Publication Date: 2021-11-09金华八达集团有限公司 +1
0 Cites 1 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for automatically operating Excel based on Microsoft COM component
  • Method for automatically operating Excel based on Microsoft COM component
  • Method for automatically operating Excel based on Microsoft COM component

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0024] Embodiment: This embodiment provides a kind of technical scheme: a kind of component module and the design fragment of editor software that are included in the method for automatically operating Excel based on Microsoft COM components are as follows: figure 1 as shown,

[0025] Start to create a new table, and then insert a list of names of Shanghai districts into the table template: Songjiang District, Baoshan District, Jinshan District, Jiading District, Nanhui District, Qingpu District, Pudong New District, Fengxian District, Minhang District, Xuhui District, Jing’an District, Huangpu District , Putuo District, Yangpu District, Hongkou District, Zhabei District, Changning District, Chongming County, Luwan District.

[0026] A method for automatically operating Excel based on Microsoft COM components includes the following steps: Step 1: Pull an "open / new" Excel table component to the RPA editor into the flow chart, and give Excel the name "test.xlsx", refer to figu...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for automatically operating Excel based on a Microsoft COM component. The method comprises the following steps: pulling an 'open / new' Excel table component into a flow chart for an RPA editor, and giving an Excel name 'test.xlsx'; executing a corresponding code block, and creating an excel object of text.xlsx through a Microsoft Excel native API; inputting a name needing to be input into a first column of text.xlsx; pulling a 'write-in area' component into the flow design drawing; and starting the process, and enabling the RPA robot to execute the components arranged according to the RPA automation software in sequence. According to the method, the stability and the efficiency of the RPA software on the automatic operation of the Excel are improved, and operations which are originally supported, such as automatically editing various styles of the Excel, filling and modifying formulas, outputting a data perspective table and executing a macro file, are supported.

Description

technical field [0001] The invention relates to the technical field of robotic process automation software, and more particularly to a method for automatically operating Excel based on Microsoft COM components. Background technique [0002] Robotic process automation (RPA for Robotic process automation) is a set of software products. RPA can replace or assist humans to complete repetitive work and tasks in digital devices such as computers and RPA mobile phones. [0003] Most of the highly repetitive work in the enterprise is related to the operation and processing of Excel. At present, most of the RPA products on the market that automate the operation of Excel rely on third-party packaged API libraries such as OpenPyXL and POI. However, these third-party encapsulated API libraries cannot be compared with the native Microsoft Excel API. And this is the technical core point of the patent application in this case. [0004] Defects in the existing technology: Traditional RP...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
09 Nov 2021
Publication
CN113627140A
IPC
G06F40/18; G06F40/174
CPC
G06F40/18; G06F40/174
Inventors
贺燕; 宋红芳