Method and system for exporting large-batch data to Excel files

A data export and large-volume technology, applied in the information field, can solve the problems of export data quantity limit, long waiting time, export content limit, etc., to reduce the time of data conversion, meet diversified needs, and improve the effect of speed

Pending Publication Date: 2018-06-12
北京拉近众博科技有限公司
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The amount of exported data supported by these export methods is limited, and the exported data files also have data errors and limited export content. Moreover, the waiting time is long during the process of data export and conversion into the target file format, which reduces the database data processing. The efficiency of the database cannot give full play to the efficiency of database data conversion

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 and system for exporting large-batch data to Excel files
  • Method and system for exporting large-batch data to Excel files

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] The preferred embodiments of the present invention will be described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described here are only used to illustrate and explain the present invention, and are not intended to limit the present invention.

[0044] figure 1 It is a flow chart of a method for exporting large batches of data into an Excel file in Embodiment 1 of the present invention. Such as figure 1 As shown, the process includes the following steps:

[0045] Step 101, querying the database.

[0046] Step 102, the query result is converted into binary data.

[0047] Set the quantity unit for data conversion, and the query result of converting one quantity unit at a time is a binary data file.

[0048] The binary data files generated by the conversion are stored in memory.

[0049] Step 103, converting the word file into a meta format file.

[0050] The meta format file contains data rows that are ...

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 and a system for exporting large-batch data to Excel files. The method comprises the steps of querying a database; converting a query result into binary data; converting word files into files in meta formats; initializing the files in the meta formats; mapping the binary data to the files in the meta formats, thereby generating file streams; and converting the filestreams into the Excel files. According to the technical scheme, the process of exporting the data in batches by the database is optimized; the efficiency of exporting the data and converting the data to be in Excel file formats is improved; large-batch and one-time exporting of the data is supported; diversified demands of data processing are met; the data exporting speed is increased; the database data conversion time is shortened; and the demands of database applications in multiple scenes are met.

Description

technical field [0001] The invention relates to the field of information technology, in particular to a method and a system for exporting large batches of data into Excel files. Background technique [0002] A relational database is a database built on the basis of the relational database model. Relational database products are widely used for their simple and clear concept and easy-to-understand and easy-to-learn database language. [0003] Relational databases process data in the database by means of concepts and methods such as set algebra, and are also organized into a set of formally descriptive tables. The essence of this form of tables is to load special collections of data items. These tables The data in the database can be accessed or recalled in many different ways without reorganizing the database tables. The definition of a relational database results in a table of metadata or in a formal description of tables, columns, scopes and constraints. Each table (some...

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/30
CPCG06F16/245G06F16/258
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