CN102184166A - Method for converting Excel form into InfoPath form based on office software - Google Patents
Method for converting Excel form into InfoPath form based on office software Download PDFInfo
- Publication number
- CN102184166A CN102184166A CN 201110117547 CN201110117547A CN102184166A CN 102184166 A CN102184166 A CN 102184166A CN 201110117547 CN201110117547 CN 201110117547 CN 201110117547 A CN201110117547 A CN 201110117547A CN 102184166 A CN102184166 A CN 102184166A
- Authority
- CN
- China
- Prior art keywords
- list
- infopath
- excel
- forms
- program
- 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
Images
Landscapes
- Stored Programmes (AREA)
Abstract
The invention provides a general method for converting the original mounting format of an Excel form into an InfoPath form, and the method is characterized in that the merging function of plug-ins refers to the operations of accessing Excel widgets and generating and traversing InfoPath format forms. The method comprises the following four steps: developing plug-ins, making Excel forms, verifying formats, generating InfoPath forms, and leading the InfoPath forms into an application system. According to the method provided by the invention, the operation of automatically converting the Excel forms into the InfoPath forms is implemented through loading the plug-ins of common office software and application program interfaces complying with certain specifications to the office software used by a user and then carrying out one-plug-in conversion. After the merging is completed, one InfoPath form can be directly led in a B/S (browser/server) system so as to facilitate the collection and summary of the forms.
Description
Technical field
The present invention relates to a kind of method that is converted to the InfoPath list based on office software Excel list.
Background technology
Lifting along with domestic informationization, the data electronic spreadsheet of business processes is more and more, and the user normally reports and issues by the Excel list in daily processing to electronic spreadsheet, in this a series of process, the process that causes list to report and issue is very complicated, and collection efficiency is underground.Generally speaking, need be at above-mentioned application scenarios exploitation specific program, and the mode that this program development adopts code and concrete file to bind usually, do not have transplantability, be applied to new electronic spreadsheet if desired, need copy or revise source code, and general transfer process can cause form to be lost.
Summary of the invention
Purpose of the present invention just provides a kind of form of can avoiding in routine conversion and loses, simultaneously list separate with code have a very strong transplantability be converted to the method for InfoPath list based on office software Excel list.
Of the present inventionly be converted to the method for InfoPath list, may further comprise the steps based on office software Excel list:
1, plug-in unit is set up: utilize the api interface of program, multiplexing office software program bottom utilizes existing function of program and class to make the translation function of carrying out between list, and program structure and filename are followed the standard format standard;
2, the making of Excel list: the user uses existing Excel template, or makes new service template according to business demand, or the template of using other system to derive;
3, format check: the source Excel list to the needs conversion carries out each cell formats unification in the list earlier, and allowing needs the Excel list of conversion to possess the ability that guiding system converts the InfoPath list to, and this is the pacing items of changing between list;
4, generate the InfoPath list: by the control in the recurrence Excel list, be converted to the list of corresponding InfoPath form then by program, and generate specific file in the InfoPath list template, be beneficial to application system and resolve;
5, import application system: be written into the InfoPath list that has created,, the InfoPath list imported to the online list of making a report on of formation in the application system according to the standard resolution rules of InfoPath list.
The plug-in unit of office software commonly used provided by the invention is followed the application programming interfaces of certain standard, is loaded into each used office software of user, then by key conversion, realizes being automatically converted to the InfoPath list by the Excel list.After merging is finished, the InfoPath list directly can be imported in the B/S system, conveniently to collect and to gather.
Of the present inventionly be converted to the method for InfoPath list based on office software Excel list, it has the following advantages:
1, this conversion plug-in unit can keep the form in the Excel list, has guaranteed that list can distortion in transfer process.2, the list after the conversion has the logic rules of highly structural, and user constraint rule and verification rule in the process of making a report on all are easy to use the accuracy that has guaranteed to make a report on list more.3, can very easily the list after the conversion be imported in the service application list that formation can be made a report in browser.
4, the processing of the data sink summation of the list after the conversion is all convenient, can directly data be put into database or other data capsules, has further increased the processing power of InfoPath instrument.
Description of drawings
Fig. 1 is converted to InfoPath flowage structure figure for electronics Excel of the present invention.
Embodiment
1, the logical description of plug-in unit
In order to make plug-in unit and office software integrated, carry out program with the dynamic link library mode and inject, communicate with the application programming interfaces of reaching an agreement on, with character string plug-in capabilities is described.The plug-in unit host is an office software, according to ability description, is responsible for the call flow and the life cycle management of plug-in unit.And extensibility user interface of plug-in unit structure and user carry out alternately, and list is changed.
2, format check
Be the operation system ability owing to some control in the Excel list does not possess to import, program can scan by automatic control to Excel, can carry out corresponding replacement operation if scan disabled Excel plug-in card program, replaces with legal control.If the control that can not discern is then reminded, the user merges after need correcting the Excel list again.
3, Excel is converted to InfoPath
Behind Excel list process format check, program can be transplanted the valid data file in the Excel list according to the form of original control, and transform engine makes up according to InfoPath standard list form simultaneously, forms new InfoPath list.
4, import to application system
The InfoPath list that is written into and creates, application system need be according to the standard resolution rules of InfoPath list, the InfoPath program is resolved the InfoPath list is imported to the list that formation can onlinely be made a report in the application system.
Claims (1)
1. one kind is converted to the method for InfoPath list based on office software Excel list, and it is characterized in that: it may further comprise the steps:
(1), plug-in unit is set up: utilize the api interface of program, multiplexing office software program bottom utilizes existing function of program and class to make the translation function of carrying out between list, and program structure and filename are followed the standard format standard;
(2), the making of Excel list: the user uses existing Excel template, or makes new service template according to business demand, or the template of using other system to derive;
(3), format check: the source Excel list to the needs conversion carries out each cell formats unification in the list earlier, and allowing needs the Excel list of conversion to possess the ability that guiding system converts the InfoPath list to;
(4), generate the InfoPath list: by the control in the recurrence Excel list, be converted to the list of corresponding InfoPath form then by program, and generate specific file in the InfoPath list template, be beneficial to application system and resolve;
(5), import application system: be written into the InfoPath list that has created,, the InfoPath list imported to the online list of making a report on of formation in the application system according to the standard resolution rules of InfoPath list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110117547 CN102184166A (en) | 2011-05-09 | 2011-05-09 | Method for converting Excel form into InfoPath form based on office software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110117547 CN102184166A (en) | 2011-05-09 | 2011-05-09 | Method for converting Excel form into InfoPath form based on office software |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102184166A true CN102184166A (en) | 2011-09-14 |
Family
ID=44570343
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110117547 Pending CN102184166A (en) | 2011-05-09 | 2011-05-09 | Method for converting Excel form into InfoPath form based on office software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102184166A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106598927A (en) * | 2016-11-30 | 2017-04-26 | 国云科技股份有限公司 | Method for rapidly creating Excel |
| CN107329756A (en) * | 2017-06-29 | 2017-11-07 | 网易（杭州）网络有限公司 | Generation method, device, storage medium, processor and the terminal of program file |
| CN113609826A (en) * | 2021-07-14 | 2021-11-05 | 远景智能国际私人投资有限公司 | Form processing method and device |
| CN114254596A (en) * | 2021-12-22 | 2022-03-29 | 北京致远互联软件股份有限公司 | CAP3 document form making method |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102024039A (en) * | 2010-12-01 | 2011-04-20 | 北京神州泰岳软件股份有限公司 | Form generating method based on electric operation maintenance system (EOMS) |
-
2011
- 2011-05-09 CN CN 201110117547 patent/CN102184166A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102024039A (en) * | 2010-12-01 | 2011-04-20 | 北京神州泰岳软件股份有限公司 | Form generating method based on electric operation maintenance system (EOMS) |
Non-Patent Citations (1)
| Title |
|---|
| 《Microsoft InfoPath 2007帮助和操作方法》 20071231 微软公司 Microsoft InfoPath 2007帮助和操作方法 1-4 1 , * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106598927A (en) * | 2016-11-30 | 2017-04-26 | 国云科技股份有限公司 | Method for rapidly creating Excel |
| CN106598927B (en) * | 2016-11-30 | 2019-08-30 | 国云科技股份有限公司 | A method of quickly generating Excel list |
| CN107329756A (en) * | 2017-06-29 | 2017-11-07 | 网易（杭州）网络有限公司 | Generation method, device, storage medium, processor and the terminal of program file |
| CN107329756B (en) * | 2017-06-29 | 2020-06-26 | 网易（杭州）网络有限公司 | Program file generation method and device, storage medium, processor and terminal |
| CN113609826A (en) * | 2021-07-14 | 2021-11-05 | 远景智能国际私人投资有限公司 | Form processing method and device |
| CN113609826B (en) * | 2021-07-14 | 2024-01-09 | 远景智能国际私人投资有限公司 | Form processing method and device |
| CN114254596A (en) * | 2021-12-22 | 2022-03-29 | 北京致远互联软件股份有限公司 | CAP3 document form making method |
| CN114254596B (en) * | 2021-12-22 | 2024-10-29 | 北京致远互联软件股份有限公司 | CAP3 official document form manufacturing method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102810057B (en) | A kind of method of log | |
| US12020249B2 (en) | Methods and systems for blockchain-implemented script-based byte interpretation | |
| CN101841515B (en) | Target variable protocol data unit codec code automatic generation implementation method | |
| CN101661460B (en) | Method and device for generating management system report | |
| CN104133772B (en) | Automatic test data generation method | |
| CN105354314B (en) | Data migration method and device | |
| CN102968306A (en) | Method and system for automatically generating code based on data model drive | |
| CN101859303A (en) | Metadata management method and management system | |
| CN103309904A (en) | Method and device for generating data warehouse ETL (Extraction, Transformation and Loading) codes | |
| KR101770292B1 (en) | Computer-executable model reverse engineering method and apparatus performing the same | |
| CN113672204A (en) | Interface document generation method, system, electronic equipment and storage medium | |
| CN102184166A (en) | Method for converting Excel form into InfoPath form based on office software | |
| CN110609826A (en) | Data extraction method | |
| CN106528896A (en) | Database optimization method and apparatus | |
| CN114610747A (en) | Data query method, device, equipment and storage medium | |
| CN101154227A (en) | Code generation method based on ASN type object | |
| CN104699518B (en) | A kind of general-purpose meter reader adapter and its implementation based on micro-kernel plug-in unit | |
| CN102004787A (en) | Method for combining multiple application scene forms based on office software plugins | |
| CN105468793A (en) | Automated management method for simulation model data | |
| CN107608669A (en) | A kind of method based on database table structure automatic generation function and the page | |
| CN104503767A (en) | System and method for automatically generating codes based on LIN protocol | |
| CN202143092U (en) | Message processing system | |
| CN111143450B (en) | Method and device for importing data | |
| CN103473654A (en) | Asset data cleaning auxiliary method and system for electric ERP system | |
| CN105955940A (en) | Automatic generation of Word report through Java-based data analysis 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 | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20110914 |