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

Pending Publication Date: 2021-11-09
金华八达集团有限公司 +1
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 1. The size of Excel is limited, and the compression rate is not high;
[0006] 2. The style is not easy to control, and templates should be used, especially for large-scale data processing
[0007] 3. Poor performance;
[0009] 5. The support for Excel style is very poor, and the style cannot be easily adjusted;

Method used

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
View more

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
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F40/18G06F40/174
CPCG06F40/18G06F40/174
Inventor 贺燕宋红芳黄健周立伟程颖丁珊马蕾王森郑航刘明一
Owner 金华八达集团有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap