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

Method and system for converting table data and format in Web page into Excel file

A technology for excel and tabular data, applied in the field of tabular data and format conversion Excel files, can solve the problems that the Excel file format does not meet the individual requirements, achieve both personalization and versatility, reduce the problem of repeated program development, and reduce redundancy Effect of remaining development work

Pending Publication Date: 2022-02-15
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical task of the present invention is to provide a method and system for converting form data and format Excel files in a Web page, to solve how to avoid the Excel file format exported each time from not meeting individual requirements or to avoid being forged in order to meet individual requirements. Each data table of the web page that needs to be exported is developed separately, reducing the problem of redundant development work

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 converting table data and format in Web page into Excel file

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0045] The form data in the Web page of the present invention and the method for format conversion Excel file, this method is that the json that Web form data and format are organized into is transmitted to the processing interface of server backend by front-end development language at the Web end, and server backend according to The json structure data from the front end generates an Excel file stream and returns it to the front end; the details are as follows:

[0046] S1, generate json data;

[0047] S2. Transmitting the json data to the processing interface of the server backend;

[0048] S3. Generate a two-dimensional matrix according to the json data;

[0049] S4, fill Excel according to two-dimensional matrix and json data;

[0050] S5. Return the Excel stream generated by the back end of the server to the front end, and the front end can obtain the corresponding Excel file.

[0051] The json data generated in step S1 in this embodiment is specifically as follows:

...

Embodiment 2

[0067] The form data in the Web page of the present invention and the system of form conversion Excel file, this system comprises,

[0068] Generate a module for organizing the json structure through the front-end development language on the Web side;

[0069] The transmission module is used to transmit the json data to the processing interface of the server backend;

[0070] Build a module for generating a two-dimensional matrix from json data;

[0071] Filling module, used to fill Excel according to two-dimensional matrix and json data;

[0072] The return module is used to return the Excel stream generated by the back end of the server to the front end, and the front end can obtain the corresponding Excel file.

[0073] The json structure in this embodiment includes the data and format information of the Web form; wherein, the format information includes font, indentation, alignment, whether to hide and merge cells;

[0074] The json structure includes the table name, ro...

Embodiment 3

[0076] The embodiment of the present invention also provides a computer-readable storage medium, wherein a plurality of instructions are stored, and the instructions are loaded by the processor, so that the processor executes the form data and format conversion Excel in the Web page in any embodiment of the present invention. Method and system for documentation. Specifically, a system or device equipped with a storage medium may be provided, on which the software program code for realizing the functions of any of the above embodiments is stored, and the computer (or CPU or MPU of the system or device) ) to read and execute the program code stored in the storage medium.

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 converting table data and format in a Web page into an Excel file, and belongs to the field of computers. The technical problem to be solved is how to avoid the situation that the format of an Excel file exported every time does not meet the personalized requirement or avoid the situation that a program is independently developed for a data table of each Web page needing to be exported in order to meet the personalized requirement, and redundant development work is reduced. According to the technical scheme, the method comprises the steps that Web table data and json organized in a format are transmitted to a processing interface of a server rear end through a front-end development language at a Web end, and the server rear end generates Excel file streams according to json structure data transmitted by a front end and returns the Excel file streams to the front end. the method specifically comprises the following steps: generating json data; transmitting the json data to a processing interface at the rear end of the server; generating a two-dimensional matrix according to the json data; filling Excel according to the two-dimensional matrix and the json data; and returning the Excel stream generated at the back end of the server to the front end, so that the front end can obtain the corresponding Excel file.

Description

technical field [0001] The invention belongs to the field of computers and relates to the field of exporting visual data, in particular to a method and a system for converting form data and format of an Excel file in a Web page. Background technique [0002] With the gradual advancement of social digitization, informatization, and intelligence, data is becoming an increasingly important resource, and users' demand for data display is also becoming stronger. As one of the traditional and efficient data display methods, tables have always played an important role in data visualization. Excel tables and web page tables are two very common presentation methods, and the conversion between them (such as exporting web page tables to Excel or displaying data in Excel to web tables) is also an important task for data visualization developers. Frequently faced demands at work. [0003] For the requirement of exporting tables of web pages to Excel, there are currently fewer solutions...

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): G06F40/151G06F40/18
CPCG06F40/151G06F40/18
Inventor 孙艺铎王庆明周庆勇胡清
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
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

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

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