Supercharge Your Innovation With Domain-Expert AI Agents!

Method and system for exporting source data of database to Excel file

A source data and database technology, applied in the information field, can solve problems such as long waiting time, export content restrictions, data file data errors, etc., to reduce the time of database data conversion, meet the needs of database applications, and meet the requirements of diversification Effect

Inactive Publication Date: 2018-04-17
TVM BEIJING TECH
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The amount of exported data that these export methods can support is limited, and the exported data files also have data errors and limited export content. The waiting time is long during the process of data export and conversion into the target file format, which reduces the database data processing. Efficiency, cannot give full play to the use 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 source data of database to Excel file
  • Method and system for exporting source data of database to Excel file

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] 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.

[0040] figure 1 It is a flowchart of a method for exporting database source data as an Excel file in Embodiment 1 of the present invention. Such as figure 1 As shown, the process includes the following steps:

[0041] Step 101, export database source data.

[0042] The database source data is exported as a text file;

[0043] In text files, all database data is stored in text form.

[0044] Step 102, replacing double quotes in the source data file with special symbols.

[0045] Special symbols are symbols that do not appear in the text file.

[0046] Special symbols are randomly generated by the system and consist of no more than three characters.

[0047] Be...

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 source data of a database to an Excel file. The method comprises the steps of exporting the source data of a database; replacing double quotation marks in a source data file with special symbols; modifying the source data file to a csv file; opening the csv file by using Excel; replacing special symbols in the csv file with double quotation marks; and obtaining an Excel file of the source data. According to the technical scheme, the batch data exporting process of the database is optimized; the efficiency of exporting and converting the data to be in an Excel file format is improved; large-batch exporting of the source data of the database is supported; diversified requirements of data processing are met; the data exporting speedis increased; the database data conversion time is shortened; and the demands of database application 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 database source data into an Excel file. 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 (som...

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/30
CPCG06F16/25G06F16/258
Inventor 吴鹏
Owner TVM BEIJING TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com