CN113065325A - Excel document analysis method and system based on OpenXml - Google Patents
Excel document analysis method and system based on OpenXml Download PDFInfo
- Publication number
- CN113065325A CN113065325A CN202110218123.2A CN202110218123A CN113065325A CN 113065325 A CN113065325 A CN 113065325A CN 202110218123 A CN202110218123 A CN 202110218123A CN 113065325 A CN113065325 A CN 113065325A
- Authority
- CN
- China
- Prior art keywords
- document
- score
- excel
- unit
- user
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/194—Calculation of difference between files
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an Excel document analysis method based on OpenXml, which comprises the following steps: s1, opening the Excel document of the required type; s2, obtaining the content and the attribute of the cell in the specified Excel document according to the title requirement; s3, comparing the data obtained in the document according to the title requirement; s4, counting the scores of each evaluation point, judging whether all the evaluation points of the question are completely evaluated, if so, calculating the total score of the user, and if not, continuously evaluating the evaluation points; and S5, counting the total scores and the error information of the examination questions and feeding back the total scores and the error information to the user. The invention also provides a scoring system for processing the manuscript content based on OpenXml, which comprises a starting unit, an obtaining unit, a comparing unit, a calculating unit and a feedback unit.
Description
Technical Field
The invention relates to the technical field of Office document technology, in particular to an Excel document analysis method and system based on OpenXml.
Background
Currently, office Excel is used as one of important judgment standards for checking the actual operation capability of a computer. The actual computer operation capability of the user should be checked while the knowledge culture level of the user on Office Excel is checked. At present, manual scoring is mostly adopted for Office Excel scoring, the method is time-consuming and labor-consuming, and all the automatic scoring by a computer is a necessary trend.
Disclosure of Invention
In order to solve the problems in the prior art, the invention provides an Excel document analysis method and system based on OpenXml, and the Excel document analysis method and system have the advantages that the Excel document is checked by adopting a method based on Open, XML and SDK, the development efficiency is greatly improved, and the development cost is reduced.
In order to achieve the purpose, the invention adopts the technical scheme that: an Excel document analysis method based on OpenXml comprises the following steps:
s1, opening the Excel document of the required type;
s2, obtaining the content and the attribute of the cell in the specified Excel document according to the title requirement;
s3, comparing the data obtained in the document according to the title requirement;
s4, counting the scores of each evaluation point, judging whether all the evaluation points of the question are completely evaluated, if so, calculating the total score of the user, and if not, continuously evaluating the evaluation points;
and S5, counting the total scores and the error information of the examination questions and feeding back the total scores and the error information to the user.
In the technical scheme, the computer simultaneously opens 3 Excel forms, namely a user answering document, a reference document and an original document. Acquiring the content and the attribute of a cell in a specified Excel document according to the question requirement; comparing data obtained in the user document with data obtained in a reference document (or an original document) according to a title requirement; and counting the score of each evaluation point, calculating the total score of the user, performing secondary development on the basis of the existing Open source library documentFormat.
In a further aspect, step S1 includes:
and opening the Excel document of the required type by referring to the open source library.
In the technical scheme, an open source library documentformat.
In a further technical solution, step S1 further includes:
the desired types of Excel documents include user answer documents, reference documents, and original documents.
In the technical scheme, an Excel user document, a reference document and an original document are opened, the office Excel document is divided into a plurality of score points, the score is judged by comparing the content in the user document with the content in the reference document or the original document, and after the score condition of each score point is checked in sequence, the total score of the examination question is determined.
In a further aspect, step S3 includes:
the data obtained in the user document is compared to the data obtained in the reference document or the original document according to the title requirement.
In the technical scheme, an office Excel document is divided into a plurality of score points, the score is judged by comparing the content in the user document with the content in a reference document or an original document, and the total score of the examination question is determined after the score condition of each score point is checked in sequence.
In a further aspect, step S4 includes:
comparing the data, and then judging the score;
the party of comparison includes value comparison and character comparison;
after the score condition of each score point is checked in sequence, three scoring modes are preset, and the total score of the examination question is determined;
the first scoring mode gives scores when all attributes are correct, the second scoring mode gives scores when at least one attribute is correct, and the third scoring mode gives scores for each attribute.
In the technical scheme, the content or the attribute of the specified cell is obtained according to the requirement of the question, and the content or the attribute is checked and compared to judge whether all the scoring points of the question are scored. If not, the scoring points are continuously scored, the total score and the error information of the examination questions are counted and fed back to the user.
The invention also provides an Excel document analysis system based on OpenXml, which comprises a starting unit, an obtaining unit, a comparing unit, a calculating unit and a feedback unit, wherein:
the starting unit is used for simultaneously opening the Excel document of the required type;
the obtaining unit is used for obtaining the content and the attribute of the cell in the specified Excel document according to the title requirement;
the comparison unit is used for comparing the data obtained in the document according to the title requirement;
the calculating unit is used for counting the scores of all the scoring points and judging whether all the scoring points of the question are scored, if so, calculating the total score of the user, and if not, continuously scoring the scoring points;
and the feedback unit is used for counting the total scores and the error information of the examination questions and feeding back the total scores and the error information to the user.
In the technical scheme, the computer simultaneously opens 3 Excel forms, namely a user answering document, a reference document and an original document. Acquiring the content and the attribute of a cell in a specified Excel document according to the question requirement; comparing data obtained in the user document with data obtained in a reference document (or an original document) according to a title requirement; and counting the score of each evaluation point, calculating the total score of the user, performing secondary development on the basis of the existing Open source library documentFormat.
In a further technical solution, the starting unit includes:
and opening the Excel document of the required type by referring to the open source library.
In the technical scheme, an open source library documentformat.
In a further technical solution, the starting unit further includes:
the desired types of Excel documents include user answer documents, reference documents, and original documents.
In the technical scheme, an Excel user document, a reference document and an original document are opened, the office Excel document is divided into a plurality of score points, the score is judged by comparing the content in the user document with the content in the reference document or the original document, and after the score condition of each score point is checked in sequence, the total score of the examination question is determined.
In a further technical solution, the comparing unit includes:
the data obtained in the user document is compared to the data obtained in the reference document or the original document according to the title requirement.
In the technical scheme, an office Excel document is divided into a plurality of score points, the score is judged by comparing the content in the user document with the content in a reference document or an original document, and the total score of the examination question is determined after the score condition of each score point is checked in sequence.
In a further technical solution, the calculation unit includes:
comparing the data, and judging the score;
and after the score condition of each score point is checked in sequence, determining the total score of the examination question.
In the technical scheme, the content or the attribute of the specified cell is obtained according to the requirement of the question, and the content or the attribute is checked and compared to judge whether all the scoring points of the question are scored. If not, the scoring points are continuously scored, the total score and the error information of the examination questions are counted and fed back to the user.
The invention has the beneficial effects that:
(1) on the basis of the existing open source library documentFormat, OpenXml, dll, a new library which can be called by a fixed system is generated through secondary development, and Excel document contents can be checked and compared;
(2) only extremely small system resources of a computer need to be consumed, the consumed time is short, and the accuracy is high;
(3) greatly improving the development efficiency and reducing the development cost.
Drawings
FIG. 1 is a flow chart of an Excel document analysis method based on OpenXml according to the present invention;
FIG. 2 is a schematic structural diagram of an Excel document analysis system based on OpenXml according to the present invention.
Description of reference numerals:
10. a start unit; 11. an acquisition unit; 12. a comparison unit; 13. a calculation unit; 14. and a feedback unit.
Detailed Description
Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.
Example (b):
as shown in FIG. 1, the invention provides an Excel document analysis method based on OpenXml, which comprises the following steps:
s1, opening the Excel document of the required type;
s2, obtaining the content and the attribute of the cell in the specified Excel document according to the title requirement;
s3, comparing the data obtained in the document according to the title requirement;
s4, counting the scores of each evaluation point, judging whether all the evaluation points of the question are completely evaluated, if so, calculating the total score of the user, and if not, continuously evaluating the evaluation points;
and S5, counting the total scores and the error information of the examination questions and feeding back the total scores and the error information to the user.
In the present embodiment, in step S1, an Excel document of a desired type is simultaneously opened; the type of Excel document mainly comprises two types, one is a document ending in a model of ". xls", the core structure of the Excel document is a compound document type structure, and the other is a document ending in a model of ". xlsx", the core structure of the Excel document is an XML type structure. Opening a specified document type according to the requirement of a title, and analyzing an excel document by utilizing a third-party open source library documentformat. In step S2, obtaining the content and attributes in the designated cell in the designated Excel document according to the topic requirement, where the topic requirement may not be self-set and limited to the topic requirement, and the main function of the present application is to analyze the content attribute in the Excel document to compare with the content attribute of the standard answer document so as to achieve the purpose of scoring, so that the topic requirement may not be changed at will, and the operation must be performed strictly according to the topic requirement; in step S3, comparing the data obtained from the document according to the title requirement, if the user operation is correct, generating the corresponding document content attribute, and comparing with the reference file to obtain the comparison result; in step S4, the score of each evaluation point is counted, whether all the scores of the evaluation points of the question are finished is judged, if yes, the total score of the user is calculated, the total score of the user is a simple accumulation method, the score of each evaluation point is limited, the score of each evaluation point is fixed, and the total score of the user can be obtained only by gradual accumulation; in step S5, the total scores and the error information of the test questions are counted and finally output in the form of character strings, and these information are fed back to other calling programs and finally displayed on a custom interface in a text manner for the user to refer to.
And simultaneously opening 3 Excel forms by the computer, wherein the Excel forms are a user answering document, a reference document and an original document. Acquiring the content and the attribute of a cell in a specified Excel document according to the question requirement; comparing data obtained in the user document with data obtained in a reference document (or an original document) according to a title requirement; and counting the score of each evaluation point, calculating the total score of the user, performing secondary development on the basis of the existing Open source library documentFormat.
In another embodiment, step S1 includes:
and opening the Excel document of the required type by referring to the open source library.
In the present embodiment, an open source library documentformat.
In another embodiment, step S1 further includes:
the desired types of Excel documents include user answer documents, reference documents, and original documents.
In the embodiment, an Excel user document, a reference document and an original document are opened, the office Excel document is divided into a plurality of score points, the score is judged by comparing the content in the user document with the content in the reference document or the original document, and after the score condition of each score point is checked in sequence, the total score of the examination questions is determined.
In another embodiment, step S3 includes:
the data obtained in the user document is compared to the data obtained in the reference document or the original document according to the title requirement.
In the embodiment, an office Excel document is divided into a plurality of score points, the score is judged by comparing the content in a user document with the content in a reference document or an original document, the total score of the examination question is determined after the score condition of each score point is checked in sequence, the mode of acquiring specified data mainly adopts a recursion mode, a parent class of a current table is acquired through specified parameters transmitted by each score point, all subclasses meeting conditions under the parent class are acquired, the attribute name and the attribute content of the subclass are returned, the attribute name is taken as a keyword, the attribute content is taken as a value, the value is packaged into a JObject object, and the result is returned; and the result is taken as the temporary storage of the answer content of the scoring point of the current user document, and the temporary storage of the answer content of the scoring point in the answer document is obtained in the same way for comparison.
In another embodiment, step S4 includes:
comparing the data, and then judging the score;
the party of comparison includes value comparison and character comparison;
after the score condition of each score point is checked in sequence, three scoring modes are preset, and the total score of the examination question is determined;
the first scoring mode gives scores when all attributes are correct, the second scoring mode gives scores when at least one attribute is correct, and the third scoring mode gives scores for each attribute.
In this embodiment, the value comparison is subdivided into three small points, mainly greater than, less than, or equal to; because of slight difference of stored values in Excel, in the patent, if the difference between the values is less than 0.01, the default is equal, otherwise, the difference is greater or less, according to the judgment of the transmitted parameters, if true, false is transmitted, and the comparison name and the comparison result of the scoring point are stored as the Key and Value of a new JObject object. As a final result, for calculating a score. Character comparisons are subdivided into equality, inequality, and inclusion. The regular expression and single character comparison are mainly adopted, the processes and the values are similar, whether parameter conditions are met or not is judged according to the transmitted parameters, true is correctly returned, and false is erroneously returned. Stored with a JObject object. As a final result, for calculating a score. And obtaining the content or the attribute of the specified cell according to the requirement of the question, checking and comparing, and judging whether all the scoring points of the question are scored. If not, the scoring points are continuously scored, the total score and the error information of the examination questions are counted and fed back to the user.
The invention also provides an Excel document analysis system based on OpenXml, as shown in FIG. 2, comprising a starting unit, an obtaining unit, a comparing unit, a calculating unit and a feedback unit, wherein:
the starting unit is used for simultaneously opening the Excel document of the required type;
the obtaining unit is used for obtaining the content and the attribute of the cell in the specified Excel document according to the title requirement;
the comparison unit is used for comparing the data obtained in the document according to the title requirement;
the calculating unit is used for counting the scores of all the scoring points and judging whether all the scoring points of the question are scored, if so, calculating the total score of the user, and if not, continuously scoring the scoring points;
and the feedback unit is used for counting the total scores and the error information of the examination questions and feeding back the total scores and the error information to the user.
In this embodiment, the computer opens 3 Excel forms simultaneously, which are the answer document, reference document, and original document of the user, respectively. Acquiring the content and the attribute of a cell in a specified Excel document according to the question requirement; comparing data obtained in the user document with data obtained in a reference document (or an original document) according to a title requirement; and counting the score of each evaluation point, calculating the total score of the user, performing secondary development on the basis of the existing Open source library documentFormat.
In another embodiment, the starting unit includes:
and opening the Excel document of the required type by referring to the open source library.
In the present embodiment, an open source library documentformat.
In another embodiment, the starting unit further comprises:
the desired types of Excel documents include user answer documents, reference documents, and original documents.
In the embodiment, an Excel user document, a reference document and an original document are opened, the office Excel document is divided into a plurality of score points, the score is judged by comparing the content in the user document with the content in the reference document or the original document, and after the score condition of each score point is checked in sequence, the total score of the examination questions is determined.
In another embodiment, the comparison unit includes:
the data obtained in the user document is compared to the data obtained in the reference document or the original document according to the title requirement.
In this embodiment, the office Excel document is divided into several score points, the score is judged by comparing the content in the user document with the content in the reference document or the original document, and after the score condition of each score point is checked in turn, the total score of the examination question is determined.
In a further technical solution, the calculation unit includes:
comparing the data, and judging the score;
and after the score condition of each score point is checked in sequence, determining the total score of the examination question.
In this embodiment, the content or attribute of the designated cell is obtained according to the requirement of the question, and the content or attribute is checked and compared to determine whether all the scoring points of the question are scored. If not, the scoring points are continuously scored, the total score and the error information of the examination questions are counted and fed back to the user.
The above-mentioned embodiments only express the specific embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention.
Claims (10)
1. An Excel document analysis method based on OpenXml is characterized by comprising the following steps:
s1, opening the Excel document of the required type;
s2, obtaining the content and the attribute in the designated cell in the designated Excel document according to the title requirement;
s3, comparing the data obtained in the document according to the title requirement;
s4, counting the scores of each evaluation point, judging whether all the evaluation points of the question are completely evaluated, if so, calculating the total score of the user, and if not, continuously evaluating the evaluation points;
and S5, counting the total scores and the error information of the examination questions and feeding back the total scores and the error information to the user.
2. The method for Excel document analysis based on OpenXml according to claim 1, wherein the step S1 includes:
and opening the Excel document of the required type by referring to the open source library.
3. The method for Excel document analysis based on OpenXml according to claim 1, wherein the step S1 further comprises:
the desired types of Excel documents include user answer documents, reference documents, and original documents.
4. The method for Excel document analysis based on OpenXml according to claim 1, wherein the step S3 includes:
the data obtained in the user document is compared to the data obtained in the reference document or the original document according to the title requirement.
5. The method for Excel document analysis based on OpenXml according to claim 1, wherein the step S4 includes:
comparing the data, and then judging the score;
the party of comparison includes value comparison and character comparison;
after the score condition of each score point is checked in sequence, three scoring modes are preset, and the total score of the examination question is determined;
the first scoring mode gives scores when all attributes are correct, the second scoring mode gives scores when at least one attribute is correct, and the third scoring mode gives scores for each attribute.
6. An Excel document analysis system based on OpenXml is characterized by comprising a starting unit, an obtaining unit, a comparing unit, a calculating unit and a feedback unit, wherein:
the starting unit is used for simultaneously opening the Excel document of the required type;
the obtaining unit is used for obtaining the content and the attribute of the cell in the specified Excel document according to the title requirement;
the comparison unit is used for comparing the data obtained in the document according to the title requirement;
the calculating unit is used for counting the scores of all the scoring points and judging whether all the scoring points of the question are scored, if so, calculating the total score of the user, and if not, continuously scoring the scoring points;
and the feedback unit is used for counting the total scores and the error information of the examination questions and feeding back the total scores and the error information to the user.
7. The system of claim 6, wherein the initiating unit comprises:
and opening the Excel document of the required type by referring to the open source library.
8. The system of claim 6, wherein the initiating unit further comprises:
the desired types of Excel documents include user answer documents, reference documents, and original documents.
9. The system of claim 6, wherein the comparing unit comprises:
the data obtained in the user document is compared to the data obtained in the reference document or the original document according to the title requirement.
10. The system of claim 6, wherein the computing unit comprises:
comparing the data, and judging the score;
and after the score condition of each score point is checked in sequence, determining the total score of the examination question.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110218123.2A CN113065325B (en) | 2021-02-26 | 2021-02-26 | Excel document analysis method and system based on OpenXml |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110218123.2A CN113065325B (en) | 2021-02-26 | 2021-02-26 | Excel document analysis method and system based on OpenXml |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113065325A true CN113065325A (en) | 2021-07-02 |
CN113065325B CN113065325B (en) | 2023-06-23 |
Family
ID=76558987
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110218123.2A Active CN113065325B (en) | 2021-02-26 | 2021-02-26 | Excel document analysis method and system based on OpenXml |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113065325B (en) |
Citations (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU1562402A (en) * | 1995-10-31 | 2002-04-11 | Frederick S.M. Herz | System for customized electronic identification of desirable objects |
JP2005011301A (en) * | 2003-06-20 | 2005-01-13 | Takaaki Yamaoka | Document processor and document processing program |
CN1794313A (en) * | 2005-12-29 | 2006-06-28 | 清华大学深圳研究生院 | Method of evaluation of EXCEL document file processing ability by computer |
CN101533398A (en) * | 2008-03-16 | 2009-09-16 | 徐文新 | Method for searching pattern matching index |
WO2013143283A1 (en) * | 2012-03-29 | 2013-10-03 | 华为技术有限公司 | Document processing method, device and editor |
CN103440233A (en) * | 2013-09-10 | 2013-12-11 | 青岛大学 | Automatic sScientific paper standardization automatic detecting and editing system |
CN104050610A (en) * | 2014-06-10 | 2014-09-17 | 广东松山职业技术学院 | Office test paper checking assembly |
CN106843893A (en) * | 2017-02-07 | 2017-06-13 | 济南浪潮高新科技投资发展有限公司 | A kind of documentation release management system based on OpenXML standards |
CN107122473A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | A kind of lead-in and lead-out method and device of Excel data |
CN108009264A (en) * | 2017-12-14 | 2018-05-08 | 北京航天测控技术有限公司 | A kind of comparative approach of versions of data for Excel format files |
CN108255903A (en) * | 2017-04-18 | 2018-07-06 | 平安科技(深圳)有限公司 | Insure problem data processing method, device, computer equipment and storage medium |
CN109948354A (en) * | 2019-03-19 | 2019-06-28 | 南京大学 | A kind of cross-platform method that cryptographic check is carried out to file using hardware isolated environment |
CN110457665A (en) * | 2019-08-14 | 2019-11-15 | 杭州豫毅信息科技有限公司 | A kind of Examination System without paper based on Excel VBA |
CN112035371A (en) * | 2020-09-04 | 2020-12-04 | 江苏海事职业技术学院 | Automatic scoring method for web application operation |
CN112181490A (en) * | 2020-09-22 | 2021-01-05 | 中国建设银行股份有限公司 | Method, device, equipment and medium for identifying function category in function point evaluation method |
-
2021
- 2021-02-26 CN CN202110218123.2A patent/CN113065325B/en active Active
Patent Citations (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU1562402A (en) * | 1995-10-31 | 2002-04-11 | Frederick S.M. Herz | System for customized electronic identification of desirable objects |
JP2005011301A (en) * | 2003-06-20 | 2005-01-13 | Takaaki Yamaoka | Document processor and document processing program |
CN1794313A (en) * | 2005-12-29 | 2006-06-28 | 清华大学深圳研究生院 | Method of evaluation of EXCEL document file processing ability by computer |
CN101533398A (en) * | 2008-03-16 | 2009-09-16 | 徐文新 | Method for searching pattern matching index |
WO2013143283A1 (en) * | 2012-03-29 | 2013-10-03 | 华为技术有限公司 | Document processing method, device and editor |
CN103440233A (en) * | 2013-09-10 | 2013-12-11 | 青岛大学 | Automatic sScientific paper standardization automatic detecting and editing system |
CN104050610A (en) * | 2014-06-10 | 2014-09-17 | 广东松山职业技术学院 | Office test paper checking assembly |
CN106843893A (en) * | 2017-02-07 | 2017-06-13 | 济南浪潮高新科技投资发展有限公司 | A kind of documentation release management system based on OpenXML standards |
CN108255903A (en) * | 2017-04-18 | 2018-07-06 | 平安科技(深圳)有限公司 | Insure problem data processing method, device, computer equipment and storage medium |
CN107122473A (en) * | 2017-05-02 | 2017-09-01 | 山东浪潮通软信息科技有限公司 | A kind of lead-in and lead-out method and device of Excel data |
CN108009264A (en) * | 2017-12-14 | 2018-05-08 | 北京航天测控技术有限公司 | A kind of comparative approach of versions of data for Excel format files |
CN109948354A (en) * | 2019-03-19 | 2019-06-28 | 南京大学 | A kind of cross-platform method that cryptographic check is carried out to file using hardware isolated environment |
CN110457665A (en) * | 2019-08-14 | 2019-11-15 | 杭州豫毅信息科技有限公司 | A kind of Examination System without paper based on Excel VBA |
CN112035371A (en) * | 2020-09-04 | 2020-12-04 | 江苏海事职业技术学院 | Automatic scoring method for web application operation |
CN112181490A (en) * | 2020-09-22 | 2021-01-05 | 中国建设银行股份有限公司 | Method, device, equipment and medium for identifying function category in function point evaluation method |
Non-Patent Citations (4)
Title |
---|
HAO LI 等: "The Design of Automatic Scoring System for Document Operational Test Question of MS-Office", 《2014 INTERNATIONAL CONFERENCE ON EDUCATION, MANAGEMENT AND COMPUTING TECHNOLOGY(ICEMCT-14)》, pages 393 - 396 * |
SHETTY DEVDAS 等: "Survey‐based spreadsheet model on lean implementation", 《INTERNATIONAL JOURNAL OF LEAN SIX SIGMA》, vol. 1, no. 4, pages 310 - 334 * |
吴国辉: "面向Office操作题的自动阅卷系统设计与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》, no. 02, pages 138 - 1327 * |
黄文庆: "基于JSP的试卷分析管理系统", 《中国优秀硕士学位论文全文数据库信息科技辑》, no. 06, pages 138 - 1345 * |
Also Published As
Publication number | Publication date |
---|---|
CN113065325B (en) | 2023-06-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2017076263A1 (en) | Method and device for integrating knowledge bases, knowledge base management system and storage medium | |
Panciera et al. | Wikipedians are born, not made: a study of power editors on Wikipedia | |
CN108829682B (en) | Computer readable storage medium, intelligent question answering method and intelligent question answering device | |
CN107798123B (en) | Knowledge base and establishing, modifying and intelligent question and answer methods, devices and equipment thereof | |
CN111460125A (en) | Intelligent question and answer method and system for government affair service | |
CN112528041B (en) | Scheduling term specification verification method based on knowledge graph | |
US8880440B2 (en) | Automatic combination and mapping of text-mining services | |
CN115186654B (en) | Method for generating document abstract | |
CN110929011A (en) | Conversation analysis method, device and equipment | |
CN112328489A (en) | Test case generation method and device, terminal equipment and storage medium | |
US20190095803A1 (en) | Intelligent inferences of authoring from document layout and formatting | |
EP4141697A1 (en) | Method and apparatus of processing triple data, method and apparatus of training triple data processing model, device, and medium | |
CN109165286A (en) | Automatic question-answering method, device and computer readable storage medium | |
CN111190880B (en) | Database detection method, device and computer readable storage medium | |
KR102030551B1 (en) | Instant messenger driving apparatus and operating method thereof | |
CN111061838A (en) | Text feature keyword determination method and device and storage medium | |
CN113065325A (en) | Excel document analysis method and system based on OpenXml | |
CN105701208A (en) | Questions and answers evaluation method and device for questions and answers system | |
CN110442324B (en) | Software requirement text expression defect detection method, system and storage medium | |
WO2021073258A1 (en) | Task follow-up method, apparatus and device based on emotion analysis, and storage medium | |
CN115577689A (en) | Table component generation method, device, equipment and medium | |
CN110858234A (en) | Method and device for pushing information according to human emotion | |
CN114546862A (en) | Dialogue test method and device, electronic equipment and computer readable storage medium | |
CN108573025B (en) | Method and device for extracting sentence classification characteristics based on mixed template | |
CN113158669A (en) | Method and system for identifying positive and negative comments of employment platform |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |