CN105094852A - Tool for importing and exporting data EXCEL - Google Patents
Tool for importing and exporting data EXCEL Download PDFInfo
- Publication number
- CN105094852A CN105094852A CN201510561859.4A CN201510561859A CN105094852A CN 105094852 A CN105094852 A CN 105094852A CN 201510561859 A CN201510561859 A CN 201510561859A CN 105094852 A CN105094852 A CN 105094852A
- Authority
- CN
- China
- Prior art keywords
- excel
- data
- user
- importing
- inventory
- 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.)
- Pending
Links
- 230000008676 import Effects 0.000 claims abstract description 28
- 238000000151 deposition Methods 0.000 claims description 6
- 230000008878 coupling Effects 0.000 claims description 3
- 238000010168 coupling process Methods 0.000 claims description 3
- 238000005859 coupling reaction Methods 0.000 claims description 3
- 230000013011 mating Effects 0.000 claims description 3
- 238000012795 verification Methods 0.000 claims description 3
- 230000008901 benefit Effects 0.000 abstract description 2
- 238000013524 data verification Methods 0.000 abstract 1
- 238000005516 engineering process Methods 0.000 description 5
- 230000003993 interaction Effects 0.000 description 2
- 235000012364 Peperomia pellucida Nutrition 0.000 description 1
- 240000007711 Peperomia pellucida Species 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 238000000034 method Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a tool for importing and exporting data EXCEL, which comprises an EXCEL importing part and an EXCEL exporting part; the user imports Excel data, the tool can verify all data formats and data lengths of Excel according to a data verification rule preset by a system, if the data are verified to be passed, the Excel data import is prompted to be successful, otherwise, the imported file is copied to a new Excel file, error data is labeled, and the newly generated Excel is fed back to the user; and modifying the Excel data according to the label by the user and importing the modified Excel again. Compared with the prior art, the data EXCEL importing and exporting tool has the advantages that a user importing EXCEL can directly position problem data, so that the user can conveniently revise EXCEL files, the efficiency of importing again is improved, and the user experience is improved.
Description
Technical field
The present invention relates to field of computer technology, specifically a kind of data EXCEL importing and the instrument of deriving.
Background technology
What usually adopt in Web application is B/S form, so browser end and service end data interaction are one and compare conventional technology.Importing Excel data to service end at browser end is also a kind of relatively more conventional data interaction technology.But because browser directly can not read local file, so, browser can only upload to service end Excel file, Excel data are checked whether to there is incorrect form by service end, if the form of Excel data is all correct, then direct program performs importing, if there is incorrect form, then returns and imports unsuccessfully.For importing failed prompting: " what occur mistake is which row of which row, and what type of error is ".User can point out according to these, remodifies local Excel data, then imports.Excel export function application system is all that the Jar bag of increasing income provided by POI or JXL is fixed man-to-man derivation, and for not easy care developer, cost of development is higher.This instrument generates Excel data by Excel template and data correspondence, is all larger raising for cost of development application system and easy care degree.
Summary of the invention
The object of the invention is to overcome the deficiencies in the prior art, the instrument that a kind of data EXCEL imports and derives is provided.
Technical scheme of the present invention realizes in the following manner, and it comprises Excel importing and Excel derives two parts;
(1), Excel imports:
Step 1: user imports Excel data, this instrument can verify all data layouts of Excel and data length according to the data check rule that system is pre-set, if the verification passes, prompting Excel data importing success, otherwise proceed to step 2; Concrete steps 1 mode of operation: the newly-built inventory 1 for depositing the capable data of correct format and the inventory 2 for depositing the capable data of error format, if there are format string data in inventory 2, then go to step 2, otherwise, prompting Excel data importing success; Comprise particularly and judge whether the format string data regular expression corresponding with column mates: if coupling, then by capable for correct format data stored in inventory 1, otherwise, by capable for error format data stored in inventory 2;
Step 2: copy and be imported into file to a new Excel file, and misdata is marked newly-generated Excel is fed back to user simultaneously;
If the inventory of step 12 is for empty, need to copy file that portion is imported into in new Excel, and misdata to be marked and type of error stores, finally whole Excel is fed back to user and download;
Step 3: user to modify to Excel data according to mark and again imports amended Excel;
(2), Excel derives:
Step 1: dock with application platform calling interface class and receive data and import into; Read Excel template simultaneously;
Import according to the data of interface class definition the data imported into type reception interface interchange side into and data processing rule according to a preconcerted arrangement carries out the parsing of data, according to the Excel template numbering that interface interchange side is imported into, Excel template is read simultaneously;
Step 2: cell information that parsing template mark obtains each mark fills corresponding variable data, and Excel is kept in server end; External output is provided by Excel;
Excel template according to reading is resolved, obtain the data variable title that the cell of each mark is corresponding, and carry out mating corresponding output according to the data that interface interchange side provides, finally the Excel data of generation are stored into server end, and provide client to preserve in the mode of output stream to client output.
Advantage of the present invention is:
Compared to the prior art, the user importing Excel can direct orientation problem data place, facilitates user and revises Excel file again, improve the efficiency again imported, improve Consumer's Experience for the instrument that a kind of data EXCEL of the present invention imports and derives.
Accompanying drawing explanation
Fig. 1 is the structural representation of the instrument that a kind of data EXCEL imports and derives.
Embodiment
Below in conjunction with accompanying drawing, the instrument that a kind of data EXCEL of the present invention imports and derives is described in detail below.
As shown in Figure 1, the instrument that a kind of data EXCEL of the present invention imports and derives, it comprises Excel importing and Excel derives two parts;
(1), Excel imports:
Step 1: user imports Excel data, this instrument can verify all data layouts of Excel and data length according to the data check rule that system is pre-set, if the verification passes, prompting Excel data importing success, otherwise proceed to step 2; Concrete steps 1 mode of operation: the newly-built inventory 1 for depositing the capable data of correct format and the inventory 2 for depositing the capable data of error format, if there are format string data in inventory 2, then go to step 2, otherwise, prompting Excel data importing success; Comprise particularly and judge whether the format string data regular expression corresponding with column mates: if coupling, then by capable for correct format data stored in inventory 1, otherwise, by capable for error format data stored in inventory 2;
Step 2: copy and be imported into file to a new Excel file, and misdata is marked newly-generated Excel is fed back to user simultaneously;
If the inventory of step 12 is for empty, need to copy file that portion is imported into in new Excel, and misdata to be marked and type of error stores, finally whole Excel is fed back to user and download;
Step 3: user to modify to Excel data according to mark and again imports amended Excel;
(2), Excel derives:
Step 1: dock with application platform calling interface class and receive data and import into; Read Excel template simultaneously;
Import according to the data of interface class definition the data imported into type reception interface interchange side into and data processing rule according to a preconcerted arrangement carries out the parsing of data, according to the Excel template numbering that interface interchange side is imported into, Excel template is read simultaneously;
Step 2: cell information that parsing template mark obtains each mark fills corresponding variable data, and Excel is kept in server end; External output is provided by Excel;
Excel template according to reading is resolved, obtain the data variable title that the cell of each mark is corresponding, and carry out mating corresponding output according to the data that interface interchange side provides, finally the Excel data of generation are stored into server end, and provide client to preserve in the mode of output stream to client output.
Its processing and fabricating of instrument that a kind of data EXCEL of the present invention imports and derives is very simple and convenient, can process to specifications shown in accompanying drawing.
Except the technical characteristic described in instructions, be the known technology of those skilled in the art.
Claims (1)
1. the data EXCEL instrument that imports and derive, is characterized in that comprising Excel and to import and Excel derives two parts;
Excel imports:
Step 1: user imports Excel data, this instrument can verify all data layouts of Excel and data length according to the data check rule that system is pre-set, if the verification passes, prompting Excel data importing success, otherwise proceed to step 2; Concrete steps 1 mode of operation: the newly-built inventory 1 for depositing the capable data of correct format and the inventory 2 for depositing the capable data of error format, if there are format string data in inventory 2, then go to step 2, otherwise, prompting Excel data importing success; Comprise particularly and judge whether the format string data regular expression corresponding with column mates: if coupling, then by capable for correct format data stored in inventory 1, otherwise, by capable for error format data stored in inventory 2;
Step 2: copy and be imported into file to a new Excel file, and misdata is marked newly-generated Excel is fed back to user simultaneously;
If the inventory of step 12 is for empty, need to copy file that portion is imported into in new Excel, and misdata to be marked and type of error stores, finally whole Excel is fed back to user and download;
Step 3: user to modify to Excel data according to mark and again imports amended Excel;
Excel derives:
Step 1: dock with application platform calling interface class and receive data and import into; Read Excel template simultaneously;
Import according to the data of interface class definition the data imported into type reception interface interchange side into and data processing rule according to a preconcerted arrangement carries out the parsing of data, according to the Excel template numbering that interface interchange side is imported into, Excel template is read simultaneously;
Step 2: cell information that parsing template mark obtains each mark fills corresponding variable data, and Excel is kept in server end; External output is provided by Excel;
Excel template according to reading is resolved, obtain the data variable title that the cell of each mark is corresponding, and carry out mating corresponding output according to the data that interface interchange side provides, finally the Excel data of generation are stored into server end, and provide client to preserve in the mode of output stream to client output.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510561859.4A CN105094852A (en) | 2015-09-07 | 2015-09-07 | Tool for importing and exporting data EXCEL |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510561859.4A CN105094852A (en) | 2015-09-07 | 2015-09-07 | Tool for importing and exporting data EXCEL |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105094852A true CN105094852A (en) | 2015-11-25 |
Family
ID=54575380
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510561859.4A Pending CN105094852A (en) | 2015-09-07 | 2015-09-07 | Tool for importing and exporting data EXCEL |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105094852A (en) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| CN107168695A (en) * | 2017-04-18 | 2017-09-15 | 北京思特奇信息技术股份有限公司 | A kind of excel data analysis methods and system |
| CN108427662A (en) * | 2017-02-13 | 2018-08-21 | 北京京东尚科信息技术有限公司 | The methods of exhibiting and device of invalid information |
| CN108629004A (en) * | 2018-05-03 | 2018-10-09 | 广东电网有限责任公司 | Summarized data acquisition method and device and electronic equipment |
| CN109509512A (en) * | 2018-07-10 | 2019-03-22 | 北京大学 | A kind of automatic banking process of clinical business imported based on Excel |
| CN109684609A (en) * | 2018-11-28 | 2019-04-26 | 陕西天诚软件有限公司 | A kind of Excel template generation and data conversion and introduction method based on ASP.NET MVC |
| CN110209662A (en) * | 2018-02-13 | 2019-09-06 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus of automation load data |
| CN110865999A (en) * | 2019-11-19 | 2020-03-06 | 浪潮软件股份有限公司 | Method and system for uploading data and checking and feeding back Excel |
| CN111159985A (en) * | 2019-12-24 | 2020-05-15 | 平安养老保险股份有限公司 | Data export method, data export device, computer equipment and computer-readable storage medium |
| CN112256919A (en) * | 2020-10-30 | 2021-01-22 | 南京哈勃信息科技有限公司 | Xlsx analysis system and method based on xlsx analysis and browser multithreading technology |
| CN112506866A (en) * | 2020-10-10 | 2021-03-16 | 浪潮云信息技术股份公司 | Importing method suitable for large-data-volume file |
| CN112579589A (en) * | 2019-09-27 | 2021-03-30 | 钉钉控股（开曼）有限公司 | Information importing method and device |
| CN115409436A (en) * | 2022-11-03 | 2022-11-29 | 博和利统计大数据(天津)集团有限公司 | Economic operation target setting method, device, equipment and readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101197875A (en) * | 2007-12-26 | 2008-06-11 | 华为技术有限公司 | Partial data checking method and device |
| CN103914438A (en) * | 2012-12-30 | 2014-07-09 | 航天信息股份有限公司 | Template and tag implementation based excel display and export method and system |
-
2015
- 2015-09-07 CN CN201510561859.4A patent/CN105094852A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101197875A (en) * | 2007-12-26 | 2008-06-11 | 华为技术有限公司 | Partial data checking method and device |
| CN103914438A (en) * | 2012-12-30 | 2014-07-09 | 航天信息股份有限公司 | Template and tag implementation based excel display and export method and system |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108427662A (en) * | 2017-02-13 | 2018-08-21 | 北京京东尚科信息技术有限公司 | The methods of exhibiting and device of invalid information |
| CN106933791A (en) * | 2017-03-10 | 2017-07-07 | 山东浪潮云服务信息科技有限公司 | One kind generation license method and device |
| CN107168695A (en) * | 2017-04-18 | 2017-09-15 | 北京思特奇信息技术股份有限公司 | A kind of excel data analysis methods and system |
| CN110209662A (en) * | 2018-02-13 | 2019-09-06 | 北京京东尚科信息技术有限公司 | A kind of method and apparatus of automation load data |
| CN108629004A (en) * | 2018-05-03 | 2018-10-09 | 广东电网有限责任公司 | Summarized data acquisition method and device and electronic equipment |
| CN109509512A (en) * | 2018-07-10 | 2019-03-22 | 北京大学 | A kind of automatic banking process of clinical business imported based on Excel |
| CN109509512B (en) * | 2018-07-10 | 2021-04-30 | 北京大学 | Clinical business automatic library building method based on Excel import |
| CN109684609A (en) * | 2018-11-28 | 2019-04-26 | 陕西天诚软件有限公司 | A kind of Excel template generation and data conversion and introduction method based on ASP.NET MVC |
| CN109684609B (en) * | 2018-11-28 | 2022-10-04 | 陕西天诚软件有限公司 | ASP (active Server Page) and NET (Internet vehicle networking) MVC (model view controller) based Excel template generation and data conversion and import method |
| WO2021057695A1 (en) * | 2019-09-27 | 2021-04-01 | 钉钉控股（开曼）有限公司 | Information importing method and apparatus |
| CN112579589A (en) * | 2019-09-27 | 2021-03-30 | 钉钉控股（开曼）有限公司 | Information importing method and device |
| CN112579589B (en) * | 2019-09-27 | 2024-02-27 | 钉钉控股（开曼）有限公司 | Information importing method and device |
| US12001388B2 (en) | 2019-09-27 | 2024-06-04 | Dingtalk Holding (Cayman) Limited | Information importing method and apparatus |
| CN110865999A (en) * | 2019-11-19 | 2020-03-06 | 浪潮软件股份有限公司 | Method and system for uploading data and checking and feeding back Excel |
| CN111159985A (en) * | 2019-12-24 | 2020-05-15 | 平安养老保险股份有限公司 | Data export method, data export device, computer equipment and computer-readable storage medium |
| CN111159985B (en) * | 2019-12-24 | 2024-01-26 | 平安养老保险股份有限公司 | Data deriving method, apparatus, computer device and computer readable storage medium |
| CN112506866A (en) * | 2020-10-10 | 2021-03-16 | 浪潮云信息技术股份公司 | Importing method suitable for large-data-volume file |
| CN112256919A (en) * | 2020-10-30 | 2021-01-22 | 南京哈勃信息科技有限公司 | Xlsx analysis system and method based on xlsx analysis and browser multithreading technology |
| CN115409436A (en) * | 2022-11-03 | 2022-11-29 | 博和利统计大数据(天津)集团有限公司 | Economic operation target setting method, device, equipment and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105094852A (en) | Tool for importing and exporting data EXCEL | |
| CN110163735B (en) | Tax-related data processing method and device, computer equipment and storage medium | |
| CN104361139B (en) | Data importing device and method | |
| CN106104472B (en) | Specifying and applying logic validation rules to data | |
| CN109189383A (en) | The generation method of code file, calculates equipment and storage medium at device | |
| CN104133772A (en) | Automatic test data generation method | |
| CN103077185A (en) | Object-based user-defined information-expanding method | |
| CN105488210B (en) | A kind of batch data matching process and device | |
| CN104657274B (en) | software interface test method and device | |
| CN108762743A (en) | Data table operation code generation method and device | |
| CN103927385A (en) | Unifying method and device of data model | |
| CN105700898A (en) | Upgrading file production method and apparatus as well as upgrading file acquisition method and apparatus | |
| CN104216952A (en) | Universal report generation method and universal report generation system based on XML (extensive markup language) technology | |
| CN102521008B (en) | Program compiling device and method for compiling program | |
| CN109753639B (en) | Front-background unified verification method and device, storage medium and electronic equipment | |
| CN104572744A (en) | Structured document generating method and device | |
| WO2011131101A1 (en) | Data cut-over method and apparatus | |
| CN108536660A (en) | A kind of generation method and terminal of self-defined report | |
| CN105589813A (en) | Electronic document version change tracking method | |
| CN105573973A (en) | Method for performing data correlation on EXCEL data in PPT file | |
| CN110019485A (en) | A kind of product data storage method, terminal device and storage medium | |
| CN101996161B (en) | A kind of old version data processing method of electronic document and device | |
| CN111190587A (en) | Method and system for automatically generating engineering front-end code based on JDBC | |
| CN105630506A (en) | Bill generation method, bill template generation method and related devices | |
| CN105117472A (en) | Generation system and introduction system for incremental file |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20151125 |