System and method for Excel plug-in data batch extraction and based on Internet

An extraction system and excel technology, applied in the field of computer networks, can solve problems such as network bottlenecks, server requests crashing, and user experience reduction, and achieve the effect of improving extraction efficiency.

Inactive Publication Date: 2012-08-01
WIND INFORMATION TECH CO LTD
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, if this working mode is applied to the Internet, because the Internet network environment is relatively complex and the network bandwidth is relatively limited, this mode will cause network bottlenecks when dealing with some relatively large-scale spreadsheets, which will eventually lead to users using The experience is greatly reduced, or the server crashes due to too many requests

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
  • System and method for Excel plug-in data batch extraction and based on Internet

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0047] The invention discloses an Internet-based Excel plug-in data batch extraction system. The system includes: a VBA driver script module, a function collection module, a function analysis module, a function cache module, a function batch request module, and a function backfill module. The functions, functional relationships and implementation methods of each module are as follows:

[0048] The VBA driver script module generates a VBA driver script, which serves as a bridge between the Excel plug-in and the Excel function; the user's call to the Excel function is collected by the function acquisition module through the VBA driver script module; the VBA driver script is loaded by the plugin, and the VBA driver script The user function defined inside the module can be directly accessed by the user; inside the user function, the call to the user function is mapped to the function collection module; after the VBA driver script module completes the function mapping, it first retu...

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 system and a method for Excel plug-in data batch extraction and based on the Internet. The system comprises a visual basic for application (VBA) driving script module, a function collection module, a function analysis module, a function cache module, a function batch request module and a function backfill module. The VBA driving script module generates a VBA driving script, the function collection module collects user functions mapped by the VBA driving script module, the function analysis module analyzes functions requested by users in a queue, analyzes function parameter and analyzes whether the functions placed in the queue exist or not, results are directly returned on yes judgment, otherwise, the user functions are transmitted to a batch package module for packaging treatment. The function cache module caches requested function result data, the function batch request module packages analyzed functions, and the function backfill module triggers the recalculation process of the Excel by calling an Excel COM interface. The system and the method can improve data extraction efficiency.

Description

technical field [0001] The invention belongs to the technical field of computer networks, and relates to a data batch extraction system, in particular to an Internet-based Excel plug-in data batch extraction system; meanwhile, the invention also relates to an Internet-based Excel plug-in data batch extraction method. Background technique [0002] Excel in the Microsoft Office suite is currently the most widely used spreadsheet software, and the Excel plug-in can be used for data calculation and processing very conveniently. Excel supports third-party plug-ins, through which data can be easily integrated into Excel. [0003] Since Excel's built-in data processing method is driven by VBA (Visual Basic for Application), a single calculation of each cell can only process the data of one cell, and the calculation of one cell will cause A server request. If the extracted data source of this computing mode is in the user's local machine or in the user's internal network, due to t...

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): G06F17/24
Inventor 孙建
Owner WIND INFORMATION TECH CO LTD
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