CN106202283A - A kind of custom field derives the data method to Excel - Google Patents
A kind of custom field derives the data method to Excel Download PDFInfo
- Publication number
- CN106202283A CN106202283A CN201610508648.9A CN201610508648A CN106202283A CN 106202283 A CN106202283 A CN 106202283A CN 201610508648 A CN201610508648 A CN 201610508648A CN 106202283 A CN106202283 A CN 106202283A
- Authority
- CN
- China
- Prior art keywords
- field
- excel
- attribute
- user
- derived
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
The present invention relates to Java language Web program development techniques field, being specifically related to a kind of custom field derives the data method to Excel.Each attribute of object and attribute are described the key value as Map and value value by the reflex mechanism of java class by the present invention, are sent to front end and show in the way of select multiselect；User selects field to be derived according to demand and/or adjusts the sequencing of each field, it is achieved the self-defined derivation of query object.This method is agile and all-purpose, simple to operate clear, relative to traditional disposable methods all derived, is effectively increased derivation efficiency, adds the experience of user, and the method for the present invention can be widely applied in Java Web application and development.
Description
Technical field
The present invention relates to Java language Web program development techniques field, being specifically related to a kind of custom field derives data
Method to Excel.
Background technology
Along with popularizing and informationalized high speed development of computer, web application is more and more, and we are the most often on the net
Derive some information: such as the consumer record of the credit card, telephone expenses list, bank's flowing water etc., often their mode of operation is whole
Field derives rather than allows user derive the field wanted as required；Therefore, information user will being not concerned with is forced defeated
Go out to user, thus cause Consumer's Experience the poorest.
Summary of the invention
Present invention solves the technical problem that and be to provide a kind of custom field to derive the data method to Excel；According to
The demand of user derives data to Excel, effective experience promoting user.
The present invention solves the technical scheme of the problems referred to above:
1, by the reflex mechanism of java class the key as Map is described each attribute of object and attribute
Value and value value, be sent to front end and show in the way of select multiselect；User selects field to be derived according to demand
And/or adjust the sequencing of each field, it is achieved the self-defined derivation of query object.
A kind of custom field the most according to claim 1 derives the data method to Excel, it is characterised in that
Described method mainly comprises the steps that
1st step, client send, to service end Action, the request of derivation；
After 2nd step, Action receive request, will be corresponding to each attribute of derived object and attribute
The title reflex mechanism by class, and be packaged in the way of key-value pair, before the Map after encapsulation is sent to
The end jsp page；
After 3rd step, front end page receive the return Map data of service end,<select/>element is utilized to be shown；
4th step, user can select field adjustment to be derived to show position accordingly, click on and determine and request sent
To service end；
After 5th step, service end receive the field information that user will derive, traversal queries result also takes out object, with
Time again derived object is sealed according to the field information of user setup, be then responsive to visitor with the form of Excel output stream
Family end；
6th step, client browser can eject explorer after receiving the output stream of service end, user selects defeated
The path gone out, point determines the most exportable Excel file.
The invention has the beneficial effects as follows: the when of derivation, attribute and the attribute description of object are all showed user, use
The result of inquiry can according to oneself the field information needing to select derivation user to want and sequence, then be carried out by family
Derive.So owing to not being that field is all derived, not only alleviate the pressure of server, but also be effectively increased user's
Experience, be widely portable to Java language Web development technique field.
Accompanying drawing explanation
The present invention is further described below in conjunction with the accompanying drawings:
Fig. 1 is flow chart of the present invention,
Fig. 2 is design sketch of the present invention.
Detailed description of the invention
As shown in Figure 1, 2, the present invention will be by whole field informations of derived object showing user, and user can root
According to the field information needing derivation to want, it is also possible to adjust the sequencing of each field, realize oneself of query object with this
Excel function is derived in definition, can be effectively improved the experience of user, and the method for the present invention can be widely applied to Java Web application
In exploitation.
Specifically comprise the following steps that
1st step, client send, to service end Action, the request of derivation；
After 2nd step, Action receive request, will each attribute of derived object and the title corresponding to attribute lead to
Cross the reflex mechanism of class, and be packaged in the way of key-value pair, the Map after encapsulation is sent to the front end jsp page；
After 3rd step, front end page receive the return Map data of service end,<select/>element is utilized to be shown；
4th step, user can select field adjustment to be derived to show position accordingly, click on and determine and request sent
To service end；
After 5th step, service end receive the field information that user will derive, traversal queries result also takes out object, with
Time again derived object is sealed according to the field information of user setup, be then responsive to visitor with the form of Excel output stream
Family end；
6th step, client browser can eject explorer after receiving the output stream of service end, user selects defeated
The path gone out, point determines the most exportable Excel file.
Claims (2)
1. a custom field derives the data method to Excel, it is characterised in that: by the reflex mechanism of java class by right
Each attribute of elephant and attribute the key value respectively as Map and value value are described, be sent to front end many with select
The mode of choosing is shown；User selects field to be derived according to demand and/or adjusts the sequencing of each field, it is achieved inquiry
The self-defined derivation of object.
A kind of custom field the most according to claim 1 derives the data method to Excel, it is characterised in that described
Method mainly comprise the steps that
1st step, client send, to service end Action, the request of derivation；
After 2nd step, Action receive request, each attribute of derived object and the title corresponding to attribute will pass through class
Reflex mechanism, and be packaged in the way of key-value pair, the Map after encapsulation be sent to the front end jsp page；
After 3rd step, front end page receive the return Map data of service end,<select/>element is utilized to be shown；
4th step, user can select field adjustment to be derived to show position accordingly, click on and determine and transmit the request to clothes
Business end；
After 5th step, service end receive the field information that user will derive, traversal queries result also takes out object, root simultaneously
Again derived object is sealed according to the field information of user setup, be then responsive to client with the form of Excel output stream；
6th step, client browser can eject explorer after receiving the output stream of service end, user selects to be exported
Path, point determines the most exportable Excel file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610508648.9A CN106202283A (en) | 2016-06-30 | 2016-06-30 | A kind of custom field derives the data method to Excel |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610508648.9A CN106202283A (en) | 2016-06-30 | 2016-06-30 | A kind of custom field derives the data method to Excel |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106202283A true CN106202283A (en) | 2016-12-07 |
Family
ID=57462683
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610508648.9A Withdrawn CN106202283A (en) | 2016-06-30 | 2016-06-30 | A kind of custom field derives the data method to Excel |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106202283A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107887009A (en) * | 2017-11-20 | 2018-04-06 | 浪潮金融信息技术有限公司 | Processing method and processing device, computer-readable storage medium and the terminal of information for hospital data |
| CN108460055A (en) * | 2017-02-22 | 2018-08-28 | 北京京东尚科信息技术有限公司 | Export method, system, equipment and the storage medium of excel tables of data |
| CN109063146A (en) * | 2018-08-07 | 2018-12-21 | 北京神州泰岳软件股份有限公司 | A kind of data export method, apparatus and system |
| CN109062883A (en) * | 2018-07-18 | 2018-12-21 | 平安科技（深圳）有限公司 | Tables of data dynamic deriving method, device, computer equipment and storage medium |
| CN110750553A (en) * | 2019-09-02 | 2020-02-04 | 成都市知用科技有限公司 | Method for self-defining export of data in service management system |
| CN111367976A (en) * | 2020-02-28 | 2020-07-03 | 平安医疗健康管理股份有限公司 | Method and device for exporting EXCEL file data based on JAVA reflection mechanism |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7860825B2 (en) * | 2006-05-08 | 2010-12-28 | Palm, Inc. | Method for synchronizing software application and user data for asynchronous client-server and peer to peer computer networks |
| CN102999321A (en) * | 2011-09-15 | 2013-03-27 | 汉王科技股份有限公司 | Writing brush electronic paintbrush setting device and writing brush electronic paintbrush |
| CN103426049A (en) * | 2012-05-25 | 2013-12-04 | 张健 | WEB-based compound management method and system |
| CN104991776A (en) * | 2015-07-09 | 2015-10-21 | 国云科技股份有限公司 | Excel reading and writing method based on configuration |
-
2016
- 2016-06-30 CN CN201610508648.9A patent/CN106202283A/en not_active Withdrawn
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7860825B2 (en) * | 2006-05-08 | 2010-12-28 | Palm, Inc. | Method for synchronizing software application and user data for asynchronous client-server and peer to peer computer networks |
| CN102999321A (en) * | 2011-09-15 | 2013-03-27 | 汉王科技股份有限公司 | Writing brush electronic paintbrush setting device and writing brush electronic paintbrush |
| CN103426049A (en) * | 2012-05-25 | 2013-12-04 | 张健 | WEB-based compound management method and system |
| CN104991776A (en) * | 2015-07-09 | 2015-10-21 | 国云科技股份有限公司 | Excel reading and writing method based on configuration |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108460055A (en) * | 2017-02-22 | 2018-08-28 | 北京京东尚科信息技术有限公司 | Export method, system, equipment and the storage medium of excel tables of data |
| CN108460055B (en) * | 2017-02-22 | 2021-01-26 | 北京京东尚科信息技术有限公司 | Method, system, equipment and storage medium for exporting excel data table |
| CN107887009A (en) * | 2017-11-20 | 2018-04-06 | 浪潮金融信息技术有限公司 | Processing method and processing device, computer-readable storage medium and the terminal of information for hospital data |
| CN109062883A (en) * | 2018-07-18 | 2018-12-21 | 平安科技（深圳）有限公司 | Tables of data dynamic deriving method, device, computer equipment and storage medium |
| WO2020015150A1 (en) * | 2018-07-18 | 2020-01-23 | 平安科技（深圳）有限公司 | Method and device for dynamically exporting data table, computer apparatus, and storage medium |
| CN109062883B (en) * | 2018-07-18 | 2022-07-26 | 平安科技（深圳）有限公司 | Data table dynamic derivation method and device, computer equipment and storage medium |
| CN109063146A (en) * | 2018-08-07 | 2018-12-21 | 北京神州泰岳软件股份有限公司 | A kind of data export method, apparatus and system |
| CN110750553A (en) * | 2019-09-02 | 2020-02-04 | 成都市知用科技有限公司 | Method for self-defining export of data in service management system |
| CN111367976A (en) * | 2020-02-28 | 2020-07-03 | 平安医疗健康管理股份有限公司 | Method and device for exporting EXCEL file data based on JAVA reflection mechanism |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106202283A (en) | A kind of custom field derives the data method to Excel | |
| MY195917A (en) | Blockchain-Based Data Processing Method And Device | |
| CN105159928B (en) | A kind of JSON data conversion at model data method and system | |
| CN102193953B (en) | System and method for migrating desktop applications | |
| CN102163226B (en) | Adjacent sorting repetition-reducing method based on Map-Reduce and segmentation | |
| CN102521321B (en) | Video search method based on search term ambiguity and user preferences | |
| CN103179133B (en) | Based on the client of entity class and the method for server communication | |
| CN104503755B (en) | Dynamic information fusion based on HTML5 high definition bitmaps shows method | |
| CN103389895A (en) | Method and system for generating front end page | |
| CN104866985B (en) | The recognition methods of express delivery odd numbers, apparatus and system | |
| CN105389329A (en) | Open source software recommendation method based on group comments | |
| WO2018040997A1 (en) | System, method, and device for evaluating node of funnel model | |
| CN104881490A (en) | WEB form data access method and system | |
| CN103885764A (en) | Network media information display system, method, device and server | |
| CN104391706A (en) | Reverse engineering based model base structuring method | |
| CN101957968A (en) | Online transaction service aggregation method based on Hadoop | |
| CN104503988A (en) | Searching method and device | |
| CN105320734A (en) | Web page core content extraction method | |
| CN109308337A (en) | Page sharing method and device | |
| CN104572787B (en) | The recognition methods of pseudo- original website and device | |
| CN106502680A (en) | A kind of method that pel extension is carried out by visualization interface | |
| CN103761246A (en) | Link network based user domain identifying method and device | |
| CN103473105A (en) | Realizing method of online code completion function | |
| CN103309954A (en) | Html webpage based data extracting system | |
| CN105243121A (en) | Data mining based text data network construction system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20161207 |