关键词: 电子表格, 结构识别, 相似性度量, 类型相似度, 仪表询价

Abstract: For instrumentation companies, it is of great significance to quickly and efficiently automate the response to users’ request for quotation and to realize unmanned quotation. Nevertheless, there is no unified and standardized format for the bill of materials spreadsheets provided by different users, resulting in semi-structured quotation spreadsheets for instrumentation companies and creating difficulties for unmanned quotation systems to perform analysis. The key to building an unmanned quotation system is to accurately automate the extraction of meter parameters, which presupposes a proper understanding of the spreadsheet structure. Therefore, with the goal of building an unmanned quotation system, this paper studies the structure recognition of instrument quotation spreadsheets and proposes hybrid similarity metrics for table structure recognition (HSMTSR). With Levenshtein distance, Dice coefficient and cell type similarity (TySim), this approach identifies spreadsheet structures based on the similarity resolution of cell and row data. Meanwhile, flowmeter spreadsheet dataset (FSDS) is built to analyze the structure of meter quotation spreadsheet, including 714 spreadsheets with 8 574 rows of data. Practical applications show the method accurately and efficiently automates the identification of multiple complex structures of instrument quotation spreadsheets, and achieves superior results in several evaluation metrics.