Supercharge Your Innovation With Domain-Expert AI Agents!

Method for importing data into bootstrap Table in classified manner on basis of js-xlsx

A js-xlsx.js, js-xlsx technology, applied in the field of WEB and JavaScript, can solve the problem of occupying server resources and achieve the effect of reducing server resources

Inactive Publication Date: 2019-12-31
ZHUHAI HENGQIN SHENGDA ZHAOYE TECH INVESTMENT CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical problem to be solved by the present invention is to provide a convenient, fast, and lighten server resource-based method for data classification and import into bootstrapTable based on js-xlsx, which solves the problem that the server must install some plug-ins or tools, occupying server resources, etc.

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 for importing data into bootstrap Table in classified manner on basis of js-xlsx

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] Such as figure 1 As shown, the present invention adopts the following steps to realize a method of importing data classification into bootstrapTable based on js-xlsx.

[0021] Step 1. Define the excel import tag and define the bootstrapTable table on the page;

[0022]

[0023]

[0024] Step 2, refer to the relevant style files and js files of bootstrap, refer to js-xlsx.js;

[0025]

[0026]

[0027]

[0028]

[0029]

[0030]

[0031]

[0032] Step 3: use js to set the table;

[0033] $("#importExcelTable").bootstrapTable({

[0034] width: 800,

[0035] height: 320,

[0036] showToggle: false, / / toggle button

[0037] showExport: false,

[0038] showColumns: false, / / drop-down box (select the displayed columns)

[0039] singleSelect: true,

[0040] clickToSelect: true,

[0041] uniqueId : "productCode",

[0042] columns: [

[0043] {radio: true},

[0044] {field: 'productId', title: 'id', align: 'center', visible: false},

[004...

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 the technical field of WEB and JavaScript, in particular to a method for importing data into bootstrapTable in a classified mode based on js-xlsx. The method comprises the following steps of: 1, defining an excel import label and defining a bootstrapTable table on a page; 2, quoting a relevant style file and a js file of bootstrap, and quoting js-xlsx.js; 3, carrying out related setting on the table by utilizing js; 4, analyzing the imported excel file, converting the excel file into a json format, and returning the excel file in the form of json format; 5, receiving the returned json data, and adding the json data into the bootstrapTable. According to the method for importing the data into the bootstrapTable in the classified mode based on js-xlsx, a convenient and fast method for reducing server resource load is provided, and the problems that some plug-ins or tools need to be installed on a server, and the server resources are occupied are solved.

Description

technical field [0001] The invention relates to the technical fields of WEB and JavaScript, in particular to a method for implementing data classification and importing into bootstrapTable based on js-xlsx. Background technique [0002] Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. An intuitive interface, excellent calculation functions and charting tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. [0003] However, the main problems currently faced are: in the past, users who wanted to import excel data to the page display often needed to analyze the Excel data in the background and process it into json format and return it to the client for display, which undoubtedly caused a loss of server performance. Contents of the invention [0004] The technical problem to be solved by the present invention is to provide a convenient, ...

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): G06F8/30G06F17/22
CPCG06F8/30
Inventor 冯捷雄张来卿庞严冬
Owner ZHUHAI HENGQIN SHENGDA ZHAOYE TECH INVESTMENT CO LTD
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