CN112861490A - Openpyxl-based engineering quantity list directory comparison system and method - Google Patents
Openpyxl-based engineering quantity list directory comparison system and method Download PDFInfo
- Publication number
- CN112861490A CN112861490A CN202110270362.2A CN202110270362A CN112861490A CN 112861490 A CN112861490 A CN 112861490A CN 202110270362 A CN202110270362 A CN 202110270362A CN 112861490 A CN112861490 A CN 112861490A
- Authority
- CN
- China
- Prior art keywords
- excel file
- file
- keyword
- folder
- module
- 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
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000012545 processing Methods 0.000 claims abstract description 42
- 230000006837 decompression Effects 0.000 claims description 5
- 230000000694 effects Effects 0.000 abstract description 8
- 238000013507 mapping Methods 0.000 abstract 1
- 230000006870 function Effects 0.000 description 7
- 238000003780 insertion Methods 0.000 description 2
- 230000037431 insertion Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/35—Clustering; Classification
- G06F16/355—Class or cluster creation or modification
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Data Mining & Analysis (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of technical language document processing, in particular to an openpyxl-based engineering quantity list directory comparison system and method. An openpyxl-based engineering quantity list directory comparison system comprises an excel file acquisition module, a mapping module and a comparison module, wherein the excel file acquisition module is used for uploading directory data of the same batch and acquiring an excel file with a sheet table name as an engineering quantity list; the summary document creating module is used for creating a summary document; the excel file processing module is used for acquiring keyword information of the excel file; the keyword information recording module is used for recording the keyword information of the excel file in the summary document; and the summary document export module is used for exporting the summary document. The system and the method can gather the keyword information together through the summary document so as to be convenient for a user to check, effectively improve the processing effect and the processing efficiency of the project inventory catalog in the field of material project management, and reduce the work complexity of material project management personnel.
Description
Technical Field
The invention relates to the technical field of technical language document processing, in particular to an openpyxl-based engineering quantity list directory comparison system and method.
Background
The technical language document processing technology mainly aims at identifying useful technical words according to special logic relations of numerous and complicated tables and text information. With the increase of massive forms and text data, how to quickly capture information suitable for the user from massive text information, and further reasonably apply and manage the information is a problem which is urgently needed to be solved at present.
At present, in the field of material project management, most of tables and documents are directly processed manually, for example, a project amount list, so that the work efficiency is low and mistakes and omissions are easy to occur in the arrangement process of the project amount list, and the processing efficiency and the processing effect of the project amount list are not ideal.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides an openpyxl-based engineering quantity list directory comparison system and method, which can quickly and effectively summarize key information on an engineering quantity list directory onto a summary document and effectively reduce the work complexity of material project management personnel.
The technical scheme adopted by the invention for solving the technical problems is as follows: an openpyxl-based engineering quantity list directory comparison system comprises
The excel file acquisition module is used for uploading directory data of the same batch and acquiring an excel file with a sheet table name as a project amount list;
the summary document creating module is used for creating a summary document;
the excel file processing module is used for acquiring keyword information of the excel file;
the keyword information recording module is used for recording the keyword information of the excel file in the summary document;
and the summary document export module is used for exporting the summary document.
The system can classify the catalog documents through the excel file acquisition module and read the name of the sheet table to obtain the excel file with the name of the sheet table being the engineering quantity list, can read the content in the sheet table with the name of the engineering quantity list through the excel file processing module and perform keyword matching on the read content and a first-level purchasing catalog in the database to obtain the keyword information of the engineering quantity list, and can gather the keyword information together through the general table document to facilitate the checking of a user, thereby effectively improving the processing effect and the processing efficiency of the engineering quantity list catalog in the material project management field and reducing the working complexity of material project managers.
Preferably, the excel file acquisition module comprises
A total folder establishing unit, configured to establish a batch file total folder for storing the directory data, where the directory data includes a compressed package, a folder, a word file, and an excel file;
the compressed packet decompression unit is used for decompressing the compressed packet into a folder in the batch file master folder;
the secondary folder establishing unit is used for establishing a batch file secondary folder for storing the batch file total folder and the word files and excel files in the folder;
the document classification unit is used for classifying the document to be processed into an excel file and a word file through an openpyxl functional module;
and the excel file determining unit is used for reading the sheet table name of the excel file through the openpyxl functional module so as to determine the excel file with the sheet table name as the project amount list.
Preferably, the excel file processing module is used for matching the content in the sheet table with the name of the project amount list with a first-level and second-level purchasing catalogue in the database through keywords, and if the content is matched with the first-level and second-level purchasing catalogues, acquiring keyword information; the keyword information comprises a keyword body, a keyword type, keyword row and column coordinate information, the page number of a sheet table where the keyword is located and the name of an excel file where the keyword is located.
Preferably, the excel file processing module reads the content in the sheet table with the name of the project amount list through the xlrd functional module.
Preferably, the keyword information recording module comprises
The first recording unit is used for recording the keyword body of the keyword information in the summary document;
the second recording unit is used for recording the type corresponding to the keyword ontology in the summary document;
a third recording unit, configured to record row-column coordinate information of the keyword body in a sheet table in the summary document;
a fourth recording unit, configured to record, in the summary document, the page number of the sheet table with the keyword ontology in the excel file;
and the fifth recording unit is used for recording the name of the excel file corresponding to the keyword ontology in the summary document.
An openpyxl-based project quantity list directory comparison method comprises the following steps
L1 uploads the directory data of the same batch, and obtains an excel file with a sheet table name as a project amount list;
l2 creates a summary document;
the L3 acquires the keyword information of the excel file through an excel file processing module, and records the keyword information of the excel file in the summary document through a keyword information recording module;
l4 derives the summary table document.
The method can classify the catalog documents and read the name of the sheet table to obtain the excel file with the name of the sheet table being the engineering quantity list, can read the content in the sheet table with the name of the engineering quantity list through the excel file processing module and perform keyword matching on the read content and the first-level purchasing catalog in the database to obtain the keyword information of the engineering quantity list, and can gather the keyword information together through the general table document to facilitate the user to check, thereby effectively improving the processing effect and the processing efficiency of the engineering quantity list catalog in the material project management field and reducing the work complexity of material project managers.
Preferably, L1 specifically includes
L11 establishes a batch file total folder, and uploads directory data to the batch file total folder, wherein the directory data comprises a compressed package, a folder, a word file and an excel file;
l12 decompressing the compressed package into folders in the batch folder aggregate;
l13, establishing a batch file sub-folder in the batch file main folder, and moving the batch file main folder and word files and excel files in the folders to the batch file sub-folder to form a document to be processed;
l14 classifies the document to be processed into an excel file and a word file through an openpyxl functional module;
the L15 reads the sheet table name of the excel file through the openpyxl function module to determine the excel file with the sheet table name as the engineering quantity list.
Preferably, L3 specifically includes
The L31 matches the content in the sheet table with the name of the project amount list with a second-level purchasing directory in the database through an excel file processing module, and if the content is matched with the first-level purchasing directory in the database, keyword information is obtained;
and the L32 records the keyword information of the excel file in the summary document through a keyword information recording module.
Preferably, in the L31, the excel file processing module reads, through an xlrd function module, contents in a sheet table named as a project amount list.
Preferably, L32 specifically includes
L321 records the keyword body of the keyword information in the summary document;
l322 records the type corresponding to the keyword ontology in the summary document;
the L323 records the row-column coordinate information of the keyword body in the sheet table in the summary document;
l324 records the page number of the sheet table with the keyword ontology in the excel file in the summary document;
and the L325 records the name of the excel file corresponding to the keyword ontology in the summary document.
Advantageous effects
The system and the method can classify the catalog documents through the Openpyxl functional module and read the name of the sheet table to obtain the excel file with the name of the sheet table being the engineering quantity list, can read the content in the sheet table with the name of the engineering quantity list through the excel file processing module and perform keyword matching on the read content and a first-level purchasing catalog in the database to obtain the keyword information of the engineering quantity list, and can gather the keyword information together through the general table document to facilitate the viewing of a user, thereby effectively improving the processing effect and the processing efficiency of the engineering quantity list catalog in the field of material project management and lightening the working complexity of material project managers.
Drawings
FIG. 1 is a block diagram of directory data according to the present invention.
Detailed Description
The technical scheme of the invention is further explained by the specific implementation mode in combination with the attached drawings.
An openpyxl-based engineering quantity list directory comparison system comprises an excel file acquisition module, a summary sheet document creation module, an excel file processing module, a keyword information recording module and a summary sheet document export module.
The excel file acquisition module is used for uploading the same batch of directory data and acquiring an excel file with a sheet table name as a project amount list. The excel file acquisition module comprises a main folder establishing unit, a compressed packet decompressing unit, a secondary folder establishing unit, a document classifying unit and an excel file determining unit. The aggregate folder establishing unit is configured to establish a batch file aggregate folder for storing the directory data, where the directory data includes a compressed package, a folder, a word file, and an excel file, as shown in fig. 1. The compressed packet decompression unit is used for decompressing the compressed packet into a folder in the batch file total folder, firstly acquiring the file name of the compressed packet, and judging the file format of the compressed packet according to the suffix of the file name of the compressed packet, wherein the common file format of the compressed packet comprises common formats such as zip, tar, rar, 7z and the like, and different decompression methods are adopted for the compressed packets with different formats. And the secondary folder establishing unit is used for establishing a batch file secondary folder for storing the batch file total folder and the word files and excel files in the folder. The document classification unit is used for classifying the document to be processed into an excel file and a word file through an openpyxl functional module. The Openpyxl functional module is a Python library for reading and writing an excel 2010 document, is a relatively comprehensive tool, can read and modify an excel file simultaneously, can perform detailed setting on cells in the excel file, comprises contents such as cell styles and the like, and even supports contents such as chart insertion, printing setting and the like, can read and write files of types such as xltm, xltx, xlsm, xlsxx and the like by using the Openpyxl functional module, and can process the excel file with large data size. The system can judge whether the document to be processed is an excel file or not through the openpyxl functional module, and if the document to be processed is not the excel file, the document to be processed is bound to be a word file. The excel file determining unit is used for reading the sheet table name of the excel file through the fileParse function of the openpyxl function module to determine the excel file with the sheet table name as the engineering quantity list.
The summary document creation module is used for creating a summary document. And a summary document is used for counting key information of the project amount list of the same batch of catalogue data. The summary document may be named by the report-batch file summary folder name.
The excel file processing module is used for acquiring keyword information of the excel file. And the excel file processing module reads the content in the sheet table with the name of the project amount list through the xlrd functional module. The xlrd functional module is an extended tool for reading excel, can read a specified form and a specified cell, and only needs to ensure that a python environment is installed when the system is used. The excel file processing module is used for matching the content in the sheet table with the name of the project amount list with a first-level purchasing catalogue and a second-level purchasing catalogue in the database through keywords, and if the content is matched with the first-level purchasing catalogue, acquiring keyword information; the keyword information comprises a keyword body, a keyword type, keyword row and column coordinate information, the page number of a sheet table where the keyword is located and the name of an excel file where the keyword is located.
And the keyword information recording module is used for recording the keyword information of the excel file in the summary document. The keyword information recording module comprises a first recording unit, a second recording unit, a third recording unit, a fourth recording unit and a fifth recording unit, wherein the first recording unit is used for recording a keyword body of the keyword information in the summary sheet document, the second recording unit is used for recording the type corresponding to the keyword body in the summary sheet document, the third recording unit is used for recording the row and column coordinate information of the keyword body in a sheet in the summary sheet document, the fourth recording unit is used for recording the page number of the sheet table with the keyword body in an excel file, and the fifth recording unit is used for recording the name of the excel file corresponding to the keyword body in the summary sheet document.
And the summary document export module is used for exporting the summary document so as to facilitate the subsequent viewing of a user.
The system can classify the catalog documents through the Openpyxl functional module and read the name of the sheet table to obtain the excel file with the name of the sheet table being the engineering quantity list, can read the content in the sheet table with the name of the engineering quantity list through the excel file processing module and perform keyword matching on the read content and a first-level purchasing catalog in the database to obtain the keyword information of the engineering quantity list, and can gather the keyword information together through the general table document to facilitate the viewing of a user, thereby effectively improving the processing effect and the processing efficiency of the engineering quantity list catalog in the material project management field.
An openpyxl-based project list directory comparison method comprises the following steps,
the L1 uploads the same batch of directory data and obtains an excel file with a sheet table name as a project amount list. Specifically, the method includes the steps of establishing a batch file aggregate folder by the L11, and uploading directory data to the batch file aggregate folder, where the directory data includes a compressed package, a folder, a word file, and an excel file as shown in fig. 1. The L12 decompresses the compressed packet into a folder in the batch file total folder, firstly obtains the file name of the compressed packet, judges the file format of the compressed packet according to the suffix of the file name of the compressed packet, the common file format of the compressed packet comprises the common formats such as zip, tar, rar, 7z and the like, and different decompression methods are adopted for the compressed packets with different formats. L13 creates a batch file sub-folder in the batch file main folder, and moves the batch file main folder and the word files and excel files in the folder to the batch file sub-folder to form the document to be processed. The L14 classifies the document to be processed into an excel file and a word file through an openpyxl function module. The Openpyxl functional module is a Python library for reading and writing an excel 2010 document, is a relatively comprehensive tool, can read and modify an excel file simultaneously, can perform detailed setting on cells in the excel file, comprises contents such as cell styles and the like, and even supports contents such as chart insertion, printing setting and the like, can read and write files of types such as xltm, xltx, xlsm, xlsxx and the like by using the Openpyxl functional module, and can process the excel file with large data size. The system can judge whether the document to be processed is an excel file or not through the openpyxl functional module, and if the document to be processed is not the excel file, the document to be processed is bound to be a word file. The L15 reads the sheet table name of the excel file through the fileParse function of the openpyxl function module to determine the excel file with the sheet table name as the engineering quantity list.
L2 creates a summary document. And a summary document is used for counting key information of the project amount list of the same batch of catalogue data. The summary document may be named by the report-batch file summary folder name.
The L3 obtains the keyword information of the excel file through an excel file processing module, and records the keyword information of the excel file in the summary document through a keyword information recording module. Specifically, the method comprises the steps that L31 carries out keyword matching on the content in a sheet table with the name of a project amount list and a second-level purchasing catalogue in a database through an excel file processing module, and if the content is matched with the first-level purchasing catalogue, keyword information is obtained. And the excel file processing module reads the content in the sheet table with the name of the project amount list through the xlrd functional module. The xlrd functional module is an extended tool for reading excel, can read a specified form and a specified cell, and only needs to ensure that a python environment is installed when the system is used.
And the L32 records the keyword information of the excel file in the summary document through a keyword information recording module. And the step of recording the keyword ontology of the keyword information in the summary document by the L321. L322 records the type corresponding to the keyword ontology in the summary document. And the L323 records the row-column coordinate information of the keyword body in the sheet table in the summary document. L324 records the page number of the sheet table with the keyword ontology in the excel file in the summary document. And the L325 records the name of the excel file corresponding to the keyword ontology in the summary document.
L4 exports the summary document for subsequent viewing by the user.
The method can classify the catalog documents through the Openpyxl functional module and read the name of the sheet table to obtain the excel file with the name of the sheet table being the engineering quantity list, can read the content in the sheet table with the name of the engineering quantity list through the excel file processing module and perform keyword matching on the read content and a first-level purchasing catalog in the database to obtain the keyword information of the engineering quantity list, and can gather the keyword information together through the general table document to facilitate the viewing of a user, thereby effectively improving the processing effect and the processing efficiency of the engineering quantity list catalog in the material project management field.
The above-described embodiments are merely illustrative of the preferred embodiments of the present invention and do not limit the spirit and scope of the present invention. Various modifications and improvements of the technical solutions of the present invention may be made by those skilled in the art without departing from the design concept of the present invention, and the technical contents of the present invention are all described in the claims.
Claims (10)
1. The project amount list catalogue comparison system based on openpyxl is characterized in that: comprises that
The excel file acquisition module is used for uploading directory data of the same batch and acquiring an excel file with a sheet table name as a project amount list;
the summary document creating module is used for creating a summary document;
the excel file processing module is used for acquiring keyword information of the excel file;
the keyword information recording module is used for recording the keyword information of the excel file in the summary document;
and the summary document export module is used for exporting the summary document.
2. The openpyxl-based inventory alignment system as claimed in claim 1, wherein: the excel file acquisition module comprises
A total folder establishing unit, configured to establish a batch file total folder for storing the directory data, where the directory data includes a compressed package, a folder, a word file, and an excel file;
the compressed packet decompression unit is used for decompressing the compressed packet into a folder in the batch file master folder;
the secondary folder establishing unit is used for establishing a batch file secondary folder for storing the batch file total folder and the word files and excel files in the folder;
the document classification unit is used for classifying the document to be processed into an excel file and a word file through an openpyxl functional module;
and the excel file determining unit is used for reading the sheet table name of the excel file through the openpyxl functional module so as to determine the excel file with the sheet table name as the project amount list.
3. The openpyxl-based inventory alignment system as claimed in claim 1, wherein: the excel file processing module is used for matching the content in the sheet table with the name of the project amount list with a first-level purchasing catalogue and a second-level purchasing catalogue in the database through keywords, and if the content is matched with the first-level purchasing catalogue, acquiring keyword information; the keyword information comprises a keyword body, a keyword type, keyword row and column coordinate information, the page number of a sheet table where the keyword is located and the name of an excel file where the keyword is located.
4. The openpyxl-based inventory alignment system as claimed in claim 3, wherein: and the excel file processing module reads the content in the sheet table with the name of the project amount list through the xlrd functional module.
5. The openpyxl-based inventory alignment system as claimed in claim 3, wherein: the keyword information recording module comprises
The first recording unit is used for recording the keyword body of the keyword information in the summary document;
the second recording unit is used for recording the type corresponding to the keyword ontology in the summary document;
a third recording unit, configured to record row-column coordinate information of the keyword body in a sheet table in the summary document;
a fourth recording unit, configured to record, in the summary document, the page number of the sheet table with the keyword ontology in the excel file;
and the fifth recording unit is used for recording the name of the excel file corresponding to the keyword ontology in the summary document.
6. The method for comparing the engineering quantity list based on openpyxl is characterized in that: comprises the following steps
L1 uploads the directory data of the same batch, and obtains an excel file with a sheet table name as a project amount list;
l2 creates a summary document;
the L3 acquires the keyword information of the excel file through an excel file processing module, and records the keyword information of the excel file in the summary document through a keyword information recording module;
l4 derives the summary table document.
7. The openpyxl-based inventory comparison method as claimed in claim 6, wherein: said L1 specifically comprises
L11 establishes a batch file total folder, and uploads directory data to the batch file total folder, wherein the directory data comprises a compressed package, a folder, a word file and an excel file;
l12 decompressing the compressed package into folders in the batch folder aggregate;
l13, establishing a batch file sub-folder in the batch file main folder, and moving the batch file main folder and word files and excel files in the folders to the batch file sub-folder to form a document to be processed;
l14 classifies the document to be processed into an excel file and a word file through an openpyxl functional module;
the L15 reads the sheet table name of the excel file through the openpyxl function module to determine the excel file with the sheet table name as the engineering quantity list.
8. The openpyxl-based inventory comparison method as claimed in claim 6, wherein: said L3 specifically comprises
The L31 matches the content in the sheet table with the name of the project amount list with a second-level purchasing directory in the database through an excel file processing module, and if the content is matched with the first-level purchasing directory in the database, keyword information is obtained;
and the L32 records the keyword information of the excel file in the summary document through a keyword information recording module.
9. The openpyxl-based inventory comparison method as claimed in claim 8, wherein: in the L31, the excel file processing module reads the content in the sheet table with the name of the engineering quantity list through the xlrd functional module.
10. The openpyxl-based inventory comparison method as claimed in claim 8, wherein: said L32 specifically comprises
L321 records the keyword body of the keyword information in the summary document;
l322 records the type corresponding to the keyword ontology in the summary document;
the L323 records the row-column coordinate information of the keyword body in the sheet table in the summary document;
l324 records the page number of the sheet table with the keyword ontology in the excel file in the summary document;
and the L325 records the name of the excel file corresponding to the keyword ontology in the summary document.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110270362.2A CN112861490B (en) | 2021-03-12 | 2021-03-12 | Engineering quantity list directory comparison system and method based on openpyl |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110270362.2A CN112861490B (en) | 2021-03-12 | 2021-03-12 | Engineering quantity list directory comparison system and method based on openpyl |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112861490A true CN112861490A (en) | 2021-05-28 |
| CN112861490B CN112861490B (en) | 2024-02-20 |
Family
ID=75994321
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110270362.2A Active CN112861490B (en) | 2021-03-12 | 2021-03-12 | Engineering quantity list directory comparison system and method based on openpyl |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112861490B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2000231560A (en) * | 1999-02-10 | 2000-08-22 | Ricoh Co Ltd | Automatic document classification system |
| KR20020067160A (en) * | 2001-02-15 | 2002-08-22 | 전석진 | Method and system for indexing document |
| JP2007058804A (en) * | 2005-08-26 | 2007-03-08 | Hitachi Ltd | Content delivery system, content delivery method and content delivery program |
| KR20170016657A (en) * | 2015-08-04 | 2017-02-14 | 서울시립대학교 산학협력단 | An apparatus for managing document using table of contents, a method thereof, and a computer recordable medium storing the method |
| CN110889310A (en) * | 2018-09-07 | 2020-03-17 | 上海怀若智能科技有限公司 | Financial document information intelligent extraction system and method |
| CN111796800A (en) * | 2020-06-28 | 2020-10-20 | 上海建科造价咨询有限公司 | Python-based engineering quantity list accuracy verification method |
-
2021
- 2021-03-12 CN CN202110270362.2A patent/CN112861490B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2000231560A (en) * | 1999-02-10 | 2000-08-22 | Ricoh Co Ltd | Automatic document classification system |
| KR20020067160A (en) * | 2001-02-15 | 2002-08-22 | 전석진 | Method and system for indexing document |
| JP2007058804A (en) * | 2005-08-26 | 2007-03-08 | Hitachi Ltd | Content delivery system, content delivery method and content delivery program |
| KR20170016657A (en) * | 2015-08-04 | 2017-02-14 | 서울시립대학교 산학협력단 | An apparatus for managing document using table of contents, a method thereof, and a computer recordable medium storing the method |
| CN110889310A (en) * | 2018-09-07 | 2020-03-17 | 上海怀若智能科技有限公司 | Financial document information intelligent extraction system and method |
| CN111796800A (en) * | 2020-06-28 | 2020-10-20 | 上海建科造价咨询有限公司 | Python-based engineering quantity list accuracy verification method |
Non-Patent Citations (4)
| Title |
|---|
| THRESH: "python处理word和excel文件", Retrieved from the Internet <URL:https://www.cnblogs.com/thresh/archive/2020/05/17/12906852.html> * |
| 周延熙;: "基于Python的Excel文档处理程序的设计与实现", 信息与电脑(理论版), no. 23, pages 85 - 87 * |
| 张孟研;: "基于Python的Excel文档合并***的设计与实现", 福建电脑, no. 06, pages 123 - 124 * |
| 邢雪娇: "基于BIM 的建筑专业设计合规性自动审查***及其关键技", 土木工程与管理学报, pages 129 - 136 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112861490B (en) | 2024-02-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7372993B2 (en) | Gesture recognition | |
| US7761427B2 (en) | Method, system, and computer program product for processing and converting electronically-stored data for electronic discovery and support of litigation using a processor-based device located at a user-site | |
| CN102968426B (en) | Archive comprehensive management system | |
| CN111597150A (en) | Automatic change and file arrangement information system | |
| MX2009000589A (en) | Data processing over very large databases. | |
| CN112052749A (en) | Archive filing method and device, electronic equipment and computer readable storage medium | |
| CN112463726A (en) | Automatic mobile financial bill filing method | |
| Marinai | Metadata extraction from PDF papers for digital library ingest | |
| CN101408882B (en) | Method and system for searching authorization document | |
| CN115168512A (en) | Spatio-temporal data lake method for realizing data collection and sharing by multi-dimensional data element fusion | |
| CN114021543B (en) | Document comparison analysis method and system based on table structure analysis | |
| KR100715320B1 (en) | Location-Information Offer System of Printed Matter | |
| JP6786658B2 (en) | Document reading system | |
| CN1588352A (en) | Recording method for extendable mark language file repairing trace | |
| CN107844960B (en) | Investment analysis tool for automatically and intelligently analyzing business plan | |
| CN112861490A (en) | Openpyxl-based engineering quantity list directory comparison system and method | |
| CN112861473B (en) | Directory examination result summarizing system and method based on openpyl | |
| US20090077127A1 (en) | Devices and methods enabling a user to manage a plurality of objects and in particular paper documents | |
| CN112395292B (en) | Data feature extraction and matching method and device | |
| TWI793432B (en) | Document management method and system for engineering project | |
| TW420777B (en) | A query method of dynamitic attribute database management | |
| CN113806368A (en) | System and method for identifying document and automatically establishing database | |
| Holler | Toward a reference theory | |
| CN111125483A (en) | Method and device for generating webpage data extraction template, computer device and computer readable storage medium | |
| JP7440979B1 (en) | File sorting system, file sorting method, and file sorting program |
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 |