CN104572038A

CN104572038A - Excel data reading and storage method based on POI technique

Info

Publication number: CN104572038A
Application number: CN201310479784.6A
Authority: CN
Inventors: 不公告发明人
Original assignee: ZHENJIANG JINRUAN COMPUTER TECHNOLOGY CO LTD
Current assignee: ZHENJIANG JINRUAN COMPUTER TECHNOLOGY CO LTD
Priority date: 2013-10-15
Filing date: 2013-10-15
Publication date: 2015-04-29

Abstract

At present, the computer application technique penetrates into every industry, most of companies have service systems applicable to service of self, an ordinary BS frame system does not have and does not need a powerful table processing function such as that of Excel software, and normally, data in a table are manually imported into a system by special operators after the table is made, in such a mode, mistakes can be easily made, and the labor and the cost of companies can be wasted. Aiming at the situation, the invention discloses an Excel data reading and storage method based on a POI technique. By adopting the method, in addition to a single Excel file import function, a function that a plurality of Excel files are selected and imported in batch at a time is achieved, the problems that mistakes can be made in manual import and the labor and the cost of companies are wasted are effectively solved, the operation steps of table import are simplified, and the working efficiency is improved to a certain extent.

Description

A kind of Excel digital independent based on POI technology and storage means

Technical field

The present invention relates to a kind of based on the Excel digital independent of POI technology and the implementation method of storage.The invention belongs to field of computer technology.

Background technology

Current, rapidly universal along with the fast development of social information's technology and computer, Computer Applied Technology has penetrated in industry-by-industry, and there is the operation system of applicable own service in most of company, and requisite in operation system be exactly multiple form.Because Excel has the ability of powerful process form and wherein data, company related management personnel more get used to first by the good form of Excel software development, and then import in system and go.Because corporate manager generally only needs to see these forms, and do not need to carry out complicated operation to form, how the numeral more need not being concerned about in these forms processes and obtains.Therefore, traditional B/S framework system disposal route be by professional manual by the data inputting in form in system.Clearly, if need the list data of typing very many, this method is too waste of manpower and cost for company really, and manual entry also more easily makes mistakes.

Summary of the invention

For traditional-handwork, data entry system in form is easily made mistakes, and as far as possible for company saves human cost, saves time, the consideration of increasing work efficiency, invention describes a kind of based on the Excel digital independent of POI technology and the implementation method of storage.Concrete steps are as follows:

Step 1: logging in system by user, is with the related pages of form import feature.

Step 2: select the Excel file needing batch to import: click the Browse button in the page, system can jump out file selection window, and user needs the Excel file selecting successively to import, and clicks the selection that " determination " button completes file.If user's select File is not Excel file, so system will eject miscue frame, and prompting user imports the type error of file;

Step 3: perform batch and import: when user successfully completes selection importing Excel file operation, click the Import button, then system can automatically perform import operation, if import successfully, system can point out user to import successfully; Otherwise system can point out user to import failure.

Embodiment

Embodiment one

Use MyEclipse 8.6 as developing instrument, use special database management tools MySQL on market to set up the database required for system.

1. judge that whether file layout is correct: default can only import Excel file at present, what the suffix name uploaded by user judged whether user upload is Excel type file, if not the file of Excel file type, system can be pointed out and import file type mistake, and the file before turning back to imports the page;

2. perform batch to import: by document flow singly the digital independent in Excel file out, be then written in database;

3. return and finally import result: return importing result after having imported, if rreturn value is " 1 ", then representative imports successfully, and prompting user imports successfully; , if rreturn value is " 0 ", then representative imports unsuccessfully, and prompting user imports failure.

In addition to the implementation, the present invention can also have other embodiments.All employings are equal to the technical scheme of replacement or equivalent transformation formation, all drop on the protection domain of application claims.

Claims

1. before performing batch importing, need to judge that whether the file layout that selection imports is correct, current default can only import Excel file, if the file that will import is not the file of Excel type, system can be pointed out and import file type mistake, and the file before turning back to imports the page.

2. imported the net result that rear needs return importing, if rreturn value is " 1 ", then representative imports successfully, and prompting user imports successfully; , if rreturn value is " 0 ", then representative imports unsuccessfully, and prompting user imports failure.