Unlock instant, AI-driven research and patent intelligence for your innovation.

Apparatus and method for educing data into Excel files from database

A data export and database technology, applied in the field of data processing, can solve the problems of slow data processing speed and extreme memory consumption, and achieve the effect of improving conversion efficiency and reducing memory usage

Inactive Publication Date: 2008-07-30
ZTE CORP
View PDF0 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0017] The technical problem to be solved by the present invention is to provide a device and method for exporting data in the database into an Excel file, which is used in the existing technology that consumes a lot of memory when generating an Excel file and has a slow speed when processing a large amount of data. question

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
  • Apparatus and method for educing data into Excel files from database
  • Apparatus and method for educing data into Excel files from database
  • Apparatus and method for educing data into Excel files from database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] The technical solutions of the present invention will be further described in more detail in conjunction with the accompanying drawings and specific embodiments.

[0051] As shown in Figure 1, it is a device structure diagram for exporting data in the database of the present invention into an Excel file. The device 100 includes: a text file export module 10 , a text file read module 20 , a data format conversion module 30 , and an Excel file repair module 40 .

[0052] The text file export module 10 is used to export the data of the database into a text file; this export is done by the database program, so the speed is much faster than the results obtained in the program.

[0053] The text file reading module 20 is connected to the text file exporting module 10, and is used for reading the data of the text file.

[0054] The text file reading module 20 all reads the data of 1024 bytes at every turn, and deposits in the buffer memory, and the data format conversion modu...

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 device which can export the data in a database into an Excel file, as well as a method thereof, wherein, the method comprises the following steps that: step one, the data of the database are exported into a text file; step two, the data of the text file are read according to the data quantity set each time, format conversion is carried out to the data of the text file read each time, and the generated Excel file is written into a disk; step three, restoration is carried out to the Excel file, and a file which is used to read and open the Excel program is generated. The invention greatly reduces the memory occupying when the data of the database are converted into the Excel file, thereby greatly improving the conversion efficiency compared with the prior art.

Description

technical field [0001] The invention relates to data processing technology, in particular to a device and method for exporting data in a database into an Excel file. Background technique [0002] Today's society belongs to the era of information explosion. A large amount of information is generated every day. Most of this information is stored in the database. However, the information stored in the database belongs to the original information and cannot be easily obtained from these messy original information. Useful information, then tools are needed at this time to organize these raw information and display them in a more intuitive way, and the more commonly used tools are daily office software such as Excel. [0003] At present, there are several open source software (such as Poi, Jxl) on the Internet that can directly manipulate (read and write) Excel files, but these software are limited to the composition format of Excel files, and have their shortcomings, that is, whe...

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
IPC IPC(8): G06F17/30G06F17/24
Inventor 邹安平
Owner ZTE CORP