CN103136173A - Method converting mass word or excel format form documents into webpages - Google Patents

Method converting mass word or excel format form documents into webpages Download PDF

Info

Publication number
CN103136173A
CN103136173A CN201210143279XA CN201210143279A CN103136173A CN 103136173 A CN103136173 A CN 103136173A CN 201210143279X A CN201210143279X A CN 201210143279XA CN 201210143279 A CN201210143279 A CN 201210143279A CN 103136173 A CN103136173 A CN 103136173A
Authority
CN
China
Prior art keywords
excel
word
html
mark
file
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
Application number
CN201210143279XA
Other languages
Chinese (zh)
Inventor
白洁
王长林
韩志军
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
BEIJING JIANLONG HEAVY INDUSTRY GROUP Co Ltd
Original Assignee
BEIJING JIANLONG HEAVY INDUSTRY GROUP Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by BEIJING JIANLONG HEAVY INDUSTRY GROUP Co Ltd filed Critical BEIJING JIANLONG HEAVY INDUSTRY GROUP Co Ltd
Priority to CN201210143279XA priority Critical patent/CN103136173A/en
Publication of CN103136173A publication Critical patent/CN103136173A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Information Transfer Between Computers (AREA)
  • Document Processing Apparatus (AREA)

Abstract

The invention discloses a method converting mass word or excel format form documents into webpages. The method achieves once conversion of mass format forms of an engineering management system. The method includes three steps that1 places of work or excel, where a user needs to conduct input, are marked with certain rules and conventional signs, namely the signs are in accordance with logics reading and processing files, forms are multiple, and types can completely utilize the forms of all computer data types; 2 the signed files are converted into files having postfixes of HTML through in a saving-as mode and through small open source software; and 3 by means of core codes, the signs are converted into correct types uniformly, when an operator opens new construction, storage and other operations, and the types are stored in a corresponding data base format. The method is simple in method, achieves uniform control webpace display states, can conduct redaction, examination and verification, and read-only operations, reduces maintaining technique doorsill, and reduces maintaining cost.

Description

Conversion word in enormous quantities or excel form shfft single document are the method for Webpage
Technical field
The present invention relates to a kind of conversion word in enormous quantities or excel form shfft single document is the method for Webpage, is the implementation method of a kind of project management system list disposable transformation in enormous quantities.
Background technology
In practical business was realized, some data mostly was the office electronic document, and for example some in engineering management are checked and accepted data list, engineering contract template miscellaneous etc.Traditional business operation mostly is the tabulator and prints list, and then fill data under line, look for leaders to sign and seal, the shop of filing at last.After disposable transformation by list, can realize to fill on client browser all lists become html to form web page with text-converted after, transmit online leaders audit signature, finally print as required and file.According to normal development mode, need to all be drawn as browser page, the file of the forms such as jsp or jspx or html to every data table style and text formatting.According to corporate business scale and national regulation list, existing data table style has thousands of kinds, if according to traditional development scheme, the cost of labor of input is great.In view of above problem, we need to find out a kind of method of Batch conversion office list pattern, and are applied to the engineering system quality module and give out a contract for a project in module.
Summary of the invention
The conversion word a kind of in enormous quantities or the excel form shfft single document that the objective of the invention is to propose for the problems referred to above are the method for web page, are the implementation methods of a kind of project management system list disposable transformation in enormous quantities.
To achieve these goals, technical scheme of the present invention is:
Conversion word in enormous quantities and excel form shfft single document are the method for web page, and described method step is:
A. on the formatted file of excel or word, mark is set, and in the formatted file with excel or word every have as the data of attribute all add a kind of mark of arranging form when being saved in database location;
B. excel or word document are converted to the file of html form, namely with Open-Source Tools, excel or word document are converted to the file of html form;
C. write a jsp page, embed the file page of html form after the interpolation function button;
D. the mark that will arrange form converts the text box that can input to, radio box, and the multiselect frame, date component type assembly, and be assembly specified database id.
Conversion word in enormous quantities or excel form shfft single document are the method for web page, at first write a logic module that is used for reading, distributing and play up agreement mark on the html format file; Write one and have the browser page that embeds html document function, be provided with function button at described browser page; Next described method is further:
A. open the excel or the word form shfft single document that need conversion, described FormDoc comprises immobilized substance field and the dynamic content field that need to fill in, adds agreement (UI assembly) mark on described dynamic content field;
B. be the FormDoc of html form with excel or the unloading of word form shfft single document of adding agreement (UI assembly) mark on described dynamic content field;
C. start described browser, with the FormDoc embedding browser of above-mentioned html form, but start described logic module, the agreement mark in the FormDoc of described html form is converted to the input text frame;
D. at browser interface, list is filled in, at browser interface selection function button, the FormDoc of described html form is preserved;
E. repeating step a to steps d, realizes that conversion word in enormous quantities and excel form shfft single document are Webpage.
Described function button has preservation, deletion, prints and submits to a higher level for approval or revision.
Described agreement is marked with #txt#, #txt-id:project no# and #check-boxLabel: qualified #.
The beneficial effect that compared with the prior art the present invention produces is: realized unified control page show state: editor, audit, read-only, reduce the maintenance technology threshold, reduce maintenance cost, operation style with similar word/excel form, keep the source document pattern, the printout mode of What You See Is What You Get provides file structure figure and the fill in performance of instant playback user at every chapters and sections of can navigating.
Below in conjunction with drawings and Examples, the present invention is described in further detail.
Description of drawings
Fig. 1 is framed structure principle of the present invention and flow chart of data processing figure;
Fig. 2 is the excel form list schematic diagram that the present invention adds the agreement mark;
Fig. 3 is the good html format list schematic diagram of conversion that the present invention shows at the visit device page.
Embodiment
  
Embodiment 1:
Conversion word in enormous quantities or excel form shfft single document are the method for webpage (web) page, it is characterized in that, described method step is:
A. on the formatted file of excel or word, mark is set, and in the formatted file with excel or word every have as the data of attribute all add a kind of mark of arranging form when being saved in database location;
B. excel or word document are converted to the file of html form, namely with Open-Source Tools, excel or word document are converted to the file of html form;
C. write a jsp page, embed the file page of html form after the interpolation function button;
D. the mark that will arrange form converts the text box that can input to, radio box, and the multiselect frame, date component type assembly, and be assembly specified database id.
Embodiment 2:
Conversion word in enormous quantities or excel form shfft single document are the method for webpage (web) page, at first write a logic module that is used for reading, distributing and play up agreement mark on the html format file in a computing machine (described computing machine have at least the hard disk, XP operating system of internal memory, the 500G of 2M, with IE visit device); Write one and have browser (JPS) page that embeds html document function, be provided with function button at described browser page; Next described method is further: referring to Fig. 1,
A. open the excel or the word form shfft single document that need conversion, described FormDoc comprises immobilized substance field and the dynamic content field that need to fill in, adds agreement (UI assembly) mark on described dynamic content field;
B. be the FormDoc of html form with excel or the unloading of word form shfft single document of adding agreement (UI assembly) mark on described dynamic content field;
C. start described browser (JPS), with the FormDoc embedding browser of above-mentioned html form, start described logic module with the agreement mark in the FormDoc of described html form (UI assembly) but be converted to the input text frame;
D. at browser interface, list is filled in, at browser interface selection function button, output is preserved, examined to the FormDoc of described html form;
E. repeating step a to steps d, realizes that conversion word in enormous quantities and excel form shfft single document are web page.
Above-described embodiment is comprised of three steps:
1. giving has certain regular peace treaty calibration note on the local mark that needs the operator to input in work and excel format file, these marks are as long as and to read the logic of processing these files consistent.Form has varied, and type also fully can be with the form of all computer data types, and for example: described agreement mark comprises #txt#, #txt-id:project no#, #check-boxLabel: qualified #.
2. by the little software of increasing income that saves as or some are consistent, the work that has added the agreement mark and excel format file are converted to the form literary composition gear that suffix is HTML.
3. pass through core code, unified agreement mark changes into correct type, and when the operator opens operations such as increasing preservation newly, is saved in the database table the inside of correspondence, and the reversible query modification of reviewing.
What the method for the specific implementation of above-described embodiment further described is:
The system Construction personnel add on the excel of needs conversions or word form agreement mark (for example, #txt#, #txt-id:project no#, #check-box Label: qualified #, etc.).
2. the system Construction personnel convert excel or word format file to the file of html form with some instruments of increasing income.
3. the developer writes a browser (web) page and (can be jsp, the forms such as jspx), the function button that interpolation is necessary on this page (as, preserve, deletion is printed, submit to a higher level for approval or revision etc.), then embed any one good html page (div) of conversion, like this because the html page that embeds is different, just be equivalent to produce in batches different web pages.
4. write one section logic module, be used for reading, distributing and play up html and go up to get the agreement mark.Its logic module is carried out:
1) read and be according to a preconcerted arrangement that form reads these marks, and split (read rule for to begin to get from # as #txt#, inputting pattern is txt(text input frame) according to certain specification, finish with #; # check-box Label: qualified # is read as, and begins with #, and the input pattern is the check(check box), the title of check box is qualified, finishes with #; #txt-id:project no# is read as with # and begins, and the input pattern is txt(text input frame), database id(field attribute) be project no, finish with #.)。
2) distribution is, for distributing a database field attribute in the place of each marking, there is no the general simple process of specific (special) requirements for distributing the serial number field, have statistics or the meeting of other functional requirements distribute appointment attribute (as, there is no the distribution serial number field item01 item02 of id mark; There is id to be labeled as project no's, the meaning is individual field name to be arranged projectno in database, and the id of this field is exactly project no, when the user puts preservation, can be saved in the value of this field in the project no field of database table, so that later query and statistical analysis.)。Play up and be, these marks are all played up UI assembly, text box, radio box, the multiselect frame, the UI assembly of the types such as date assembly (play up a text input frame as #txt#, check-box Label: it is that qualified check box is qualified that qualified # plays up a title).
The below is a specific embodiment:
1. add mark for an office file, as shown in Figure 2;
2. utilize the convertexcelhtml.exe open source software, above-mentioned excel is converted to html file; 3. calling logic module, the revised file coded format is modified as charset=utf-8 to charset=gb2312.
4. operator's open any browser, click the filename of input page, the excelReader.js file can read and get mark on html file, #txt# is converted to text input frame etc., and give each input frame allocation database Table Properties id, process the good html format file of conversion by computer logic, show following picture to the operator, as shown in Figure 3.
5. the operator inputs the information that will input, clicks on the visit device page and must preserve, and computer system can be saved in database to the information of input.Can inquire about next time as required, revises, and prints etc.

Claims (4)

1. change in enormous quantities word or excel form shfft single document is the method for Webpage, it is characterized in that, described method step is:
A. on the formatted file of excel or word, mark is set, and in the formatted file with excel or word every have as the data of attribute all add a kind of mark of arranging form when being saved in database location;
B. excel or word document are converted to the file of html form, namely with Open-Source Tools, excel or word document are converted to the file of html form;
C. write a jsp page, embed the file page of html form after the interpolation function button;
D. the mark that will arrange form converts the text box that can input to, radio box, and the multiselect frame, date component type assembly, and be assembly specified database id.
2. change in enormous quantities word or excel form shfft single document is the method for Webpage, it is characterized in that, at first write a logic module that is used for agreement mark on the html format file that reads, distributes and play up; Write one and have the browser page that embeds html document function, be provided with function button at described browser page; Next described method is further:
A. open the excel or the word form shfft single document that need conversion, described FormDoc comprises immobilized substance field and the dynamic content field that need to fill in, adds the agreement mark on described dynamic content field;
B. be the FormDoc of html form with excel or the unloading of word form shfft single document of adding the agreement mark on described dynamic content field;
C. start described browser, with the FormDoc embedding browser of above-mentioned html form, but start described logic module, the agreement mark in the FormDoc of described html form is converted to the input text frame;
D. at browser interface, list is filled in, at browser interface selection function button, the FormDoc of described html form is preserved;
E. repeating step a to steps d, realizes that conversion word in enormous quantities and excel form shfft single document are web page.
3. conversion word in enormous quantities according to claim 2 or excel form shfft single document are the method for Webpage, it is characterized in that, described function button has preservation, deletion, prints and submits to a higher level for approval or revision.
4. conversion word in enormous quantities according to claim 2 or excel form shfft single document are the method for Webpage, it is characterized in that, described agreement is marked with #txt#, #txt-id:project no# and #check-boxLabel: qualified #.
CN201210143279XA 2011-11-29 2012-05-10 Method converting mass word or excel format form documents into webpages Pending CN103136173A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210143279XA CN103136173A (en) 2011-11-29 2012-05-10 Method converting mass word or excel format form documents into webpages

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
CN201110386943 2011-11-29
CN201110386943.9 2011-11-29
CN201210143279XA CN103136173A (en) 2011-11-29 2012-05-10 Method converting mass word or excel format form documents into webpages

Publications (1)

Publication Number Publication Date
CN103136173A true CN103136173A (en) 2013-06-05

Family

ID=48496014

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210143279XA Pending CN103136173A (en) 2011-11-29 2012-05-10 Method converting mass word or excel format form documents into webpages

Country Status (1)

Country Link
CN (1) CN103136173A (en)

Cited By (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105095160A (en) * 2015-07-31 2015-11-25 河南大学 Document conversion reading method and system
CN105335338A (en) * 2014-06-25 2016-02-17 阿里巴巴集团控股有限公司 Electronic document conversion method and device
CN105389294A (en) * 2015-11-17 2016-03-09 贵阳朗玛信息技术股份有限公司 Method and apparatus for reading document
CN105630753A (en) * 2015-12-28 2016-06-01 中广核核电运营有限公司 Digitalized regulation upgrading and transformation method and system of nuclear power plant
CN105786788A (en) * 2016-03-22 2016-07-20 江苏国泰新点软件有限公司 Method and device for generating forms by using WORD program
CN106033348A (en) * 2015-03-19 2016-10-19 中审(北京)国际技术培训有限公司 Webpage making method, device and electronic equipment
CN106294493A (en) * 2015-06-08 2017-01-04 腾讯科技(深圳)有限公司 Realize the method and device of document format conversion
CN106528831A (en) * 2016-11-22 2017-03-22 泰康保险集团股份有限公司 Data pushing method and system
CN106844447A (en) * 2016-12-16 2017-06-13 中广核核电运营有限公司 The processing method and processing unit of nuclear power station alarm card
CN107256476A (en) * 2017-05-27 2017-10-17 上海非码网络科技有限公司 A kind of document sending method captured based on browser and system, server
CN108614839A (en) * 2016-12-13 2018-10-02 上海宝信软件股份有限公司 WORD documents based on browser turn html page visualizing editing method and system
CN109241503A (en) * 2018-09-03 2019-01-18 科大国创软件股份有限公司 A kind of user-defined data table single system and its pattern conversion method based on office document
CN109284292A (en) * 2018-09-28 2019-01-29 广东电网有限责任公司 A kind of generation method of mobile operation list generates system and relevant apparatus
CN109472010A (en) * 2018-10-10 2019-03-15 福建升腾资讯有限公司 The method and computer equipment of front end html design table (schedule) are obtained based on execl template
CN109522528A (en) * 2018-11-13 2019-03-26 吴昌议 A kind of word document is converted to the method that can calculate automatically html document
CN111143749A (en) * 2019-12-31 2020-05-12 中国银行股份有限公司 Webpage display method, device, equipment and storage medium
CN111897777A (en) * 2020-06-22 2020-11-06 百望股份有限公司 Method, device and equipment for processing electronic invoice layout file and storage medium
CN112035280A (en) * 2020-08-31 2020-12-04 浪潮云信息技术股份公司 Angular-based pipeline data processing method and tool
CN112668282A (en) * 2020-12-28 2021-04-16 山东鲁能软件技术有限公司 Method and system for converting format of equipment procedure document
CN112801248A (en) * 2021-02-04 2021-05-14 西安热工研究院有限公司 Non-contact page data transmission method suitable for water-electricity SCADA system
CN113268283A (en) * 2021-05-28 2021-08-17 深圳市蓬莱产业科技有限公司 Batch processing method based on file materials
CN113743049A (en) * 2021-09-06 2021-12-03 四川新网银行股份有限公司 Method for previewing electronic contract

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030028562A1 (en) * 2000-12-29 2003-02-06 International Business Machines Corporation Method and system for importing MS office forms
US20050268222A1 (en) * 2004-05-26 2005-12-01 Cheng Kai M Method of creating, processing and storing HTML documents
CN101149737A (en) * 2007-05-10 2008-03-26 廖义洪 Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030028562A1 (en) * 2000-12-29 2003-02-06 International Business Machines Corporation Method and system for importing MS office forms
US20050268222A1 (en) * 2004-05-26 2005-12-01 Cheng Kai M Method of creating, processing and storing HTML documents
CN101149737A (en) * 2007-05-10 2008-03-26 廖义洪 Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word

Cited By (30)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105335338A (en) * 2014-06-25 2016-02-17 阿里巴巴集团控股有限公司 Electronic document conversion method and device
CN105335338B (en) * 2014-06-25 2018-04-03 阿里巴巴集团控股有限公司 A kind of electronic document conversion method and device
CN106033348A (en) * 2015-03-19 2016-10-19 中审(北京)国际技术培训有限公司 Webpage making method, device and electronic equipment
CN106294493B (en) * 2015-06-08 2020-05-08 腾讯科技(深圳)有限公司 Method and device for realizing document format conversion
CN106294493A (en) * 2015-06-08 2017-01-04 腾讯科技(深圳)有限公司 Realize the method and device of document format conversion
CN105095160A (en) * 2015-07-31 2015-11-25 河南大学 Document conversion reading method and system
CN105095160B (en) * 2015-07-31 2018-12-28 河南大学 A kind of document conversion reading method and system
CN105389294A (en) * 2015-11-17 2016-03-09 贵阳朗玛信息技术股份有限公司 Method and apparatus for reading document
CN105630753A (en) * 2015-12-28 2016-06-01 中广核核电运营有限公司 Digitalized regulation upgrading and transformation method and system of nuclear power plant
CN105630753B (en) * 2015-12-28 2018-09-25 中广核核电运营有限公司 A kind of upgrade conversion method and system of nuclear plant digital regulation
CN105786788A (en) * 2016-03-22 2016-07-20 江苏国泰新点软件有限公司 Method and device for generating forms by using WORD program
CN106528831A (en) * 2016-11-22 2017-03-22 泰康保险集团股份有限公司 Data pushing method and system
CN106528831B (en) * 2016-11-22 2020-03-13 泰康保险集团股份有限公司 Data pushing method and system
CN108614839A (en) * 2016-12-13 2018-10-02 上海宝信软件股份有限公司 WORD documents based on browser turn html page visualizing editing method and system
CN106844447A (en) * 2016-12-16 2017-06-13 中广核核电运营有限公司 The processing method and processing unit of nuclear power station alarm card
CN107256476A (en) * 2017-05-27 2017-10-17 上海非码网络科技有限公司 A kind of document sending method captured based on browser and system, server
CN109241503A (en) * 2018-09-03 2019-01-18 科大国创软件股份有限公司 A kind of user-defined data table single system and its pattern conversion method based on office document
CN109284292A (en) * 2018-09-28 2019-01-29 广东电网有限责任公司 A kind of generation method of mobile operation list generates system and relevant apparatus
CN109472010A (en) * 2018-10-10 2019-03-15 福建升腾资讯有限公司 The method and computer equipment of front end html design table (schedule) are obtained based on execl template
CN109522528A (en) * 2018-11-13 2019-03-26 吴昌议 A kind of word document is converted to the method that can calculate automatically html document
CN111143749A (en) * 2019-12-31 2020-05-12 中国银行股份有限公司 Webpage display method, device, equipment and storage medium
CN111897777A (en) * 2020-06-22 2020-11-06 百望股份有限公司 Method, device and equipment for processing electronic invoice layout file and storage medium
CN112035280B (en) * 2020-08-31 2024-05-10 浪潮云信息技术股份公司 Pipeline data processing method and tool based on Angular
CN112035280A (en) * 2020-08-31 2020-12-04 浪潮云信息技术股份公司 Angular-based pipeline data processing method and tool
CN112668282A (en) * 2020-12-28 2021-04-16 山东鲁能软件技术有限公司 Method and system for converting format of equipment procedure document
CN112668282B (en) * 2020-12-28 2023-02-03 山东鲁能软件技术有限公司 Method and system for converting format of equipment procedure document
CN112801248B (en) * 2021-02-04 2023-02-28 西安热工研究院有限公司 Non-contact page data transmission method suitable for water-electricity SCADA system
CN112801248A (en) * 2021-02-04 2021-05-14 西安热工研究院有限公司 Non-contact page data transmission method suitable for water-electricity SCADA system
CN113268283A (en) * 2021-05-28 2021-08-17 深圳市蓬莱产业科技有限公司 Batch processing method based on file materials
CN113743049A (en) * 2021-09-06 2021-12-03 四川新网银行股份有限公司 Method for previewing electronic contract

Similar Documents

Publication Publication Date Title
CN103136173A (en) Method converting mass word or excel format form documents into webpages
US10810365B2 (en) Workflow system and method for creating, distributing and publishing content
US11210456B2 (en) Method relating to preparation of a report
US7818661B2 (en) Method and system for automatically generating template based spreadsheet pivot tables
US7747938B2 (en) Data insertion from a database into a fixed electronic template form
CN106940693B (en) Single structure processing method for laboratory original record
Vassilakis et al. A knowledge-based approach for developing multi-channel e-government services
US20170364981A1 (en) Brand-Based Product Management
Ghosh et al. Modeling and asynchronous distributed simulation analyzing complex systems
Souza et al. Global clinical data interchange standards are here!
Cheung et al. DIY bootstrapping: Getting the nonparametric bootstrap confidence interval in SPSS for any statistics or function of statistics (when this bootstrapping is appropriate)
CN101299750A (en) Method and equipment for implementing operational management
Willis et al. Corporate communications for the 21st century
CN103699520A (en) Font processing method for maintaining e-document layout
e Silva et al. Evaluating a digital library self-archiving service: The BDBComp user case study
GB2458692A (en) A process for generating database-backed, web-based documents
KR102282159B1 (en) Multilingual manual authoring apparatus based on XML and method thereof
US20050097450A1 (en) System and method for composition and decomposition of information objects
Li et al. [Retracted] The Research of Multimedia Complex Intelligent System in Financial Reporting Mode
Lu et al. Collaborating with wikis
Wyman et al. Working the embedded flow: Matrix flowchart update 2022
US20210224490A1 (en) Content localization framework
Machin Digital Requirement Development: Three Years of Using Digital Methods to Improve Standardization of Procurement Specifications
Li et al. Towards a Useful Chinese Annotation Tool: An Examination of Annotators’ Practice and Needs
Zhao Presenting Data

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20130605