Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method of converting an Excel file to a JSON file

A file conversion, JSON technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of difficult query and acquisition of specified columns, inconvenient HTTP request to obtain results, inconvenient use, etc., to achieve easy to read and Compilation, easy machine parsing and generation, and the effect of improving network transmission efficiency

Pending Publication Date: 2019-03-01
SHANDONG ZHONGCI ROMOTE VIDEO TECH
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Excel is a commonly used tool for everyone, and it is very convenient in data editing, but the original direct reading method using Excel is error-prone, and it is difficult to query and obtain specified columns through query conditions, which is inefficient and inconvenient to obtain results through HTTP requests, and inconvenient to use

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0011] Embodiment 1: A method for converting an Excel file into a JSON file, step A: receiving the Excel data requested by the client; Step B: reading the data in the Excel data in the form of Datatable, then traversing the Datatable data into a List, and finally processing the List Obtain JSON data in reverse order; Step C: Receive the HTTP request sent by the client, read the basic element information in the JSON file, and then format the information according to the typesetting format of the EXCEL file and obtain the typesetting result; Step D: Call the C++ language function The library generates an EXCEL file from the typesetting result, and sends the EXCEL file to the client after obtaining it.

[0012] Wherein, the client can send HTTPJSON requests to the server for subsystems in any system, and call the file conversion method provided by this application through the API interface, and convert the JSON file into an EXCEL file by calling the method provided by the embodime...

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 relates to a method for converting Excel files into JSON files, belonging to a file format conversion technology, comprising the following steps: step A: receiving Excel data requested by a client; B, reading that data in the Excel data in the form of a Datatable, traversing the Datatable data as List, and finally reverse sequence the List to obtain JSON data; C, receiving the HTTP request sent by the client end, reading the basic element information in the JSON file, and then arranging the information according to the typesetting format of the EXCEL file and obtaining the typesetting result; D, cal that C + + language function library to generate an EXCEL file from the typesetting result, and sending the EXCEL file to the client after obtaining the EXCEL file. Compared withthe prior art, the method converts Excel files into JSON files for network HTTP requests is convenient to use, is easy to read and write, is easy to machine parse and generate, and effectively improves network transmission efficiency.

Description

technical field [0001] The invention relates to a file format conversion technology. Background technique [0002] Excel is a commonly used tool for everyone, and it is very convenient for data editing. However, the original method of direct reading using Excel is error-prone, and it is difficult to query and obtain specified columns through query conditions. It is inefficient, inconvenient to obtain results through HTTP requests, and inconvenient to use. JSON (JavaScriptObjectNotation) is a lightweight data exchange format based on a subset of ECMAScript. JSON uses a completely language-independent text format, but also uses a habit similar to the C language family (including C, C++, C#, Java, JavaScript, Perl, Python, etc.), these features make JSON an ideal data exchange language, easy for humans to read and write, and easy for machines to parse and generate. Sometimes, we need to convert Excel data into JSON format for subsequent use. Contents of the invention [000...

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/22
CPCG06F40/151
Inventor 贾伟光牟骏李咸明邢辰张松
Owner SHANDONG ZHONGCI ROMOTE VIDEO TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products