List processing method and apparatus

A processing method and list technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as reduced work efficiency, strict format requirements, and increased import time.

Inactive Publication Date: 2015-10-14
CHINA TIESIJU CIVIL ENG GRP CO LTD
View PDF7 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Although the above two methods can import the Excel version bill of quantities into the database, manual input one by one during the import process will increase the import time and reduce work efficiency. Compared with manual input, although automatic import can reduce the import time and Improve work efficiency, but the automatic import has strict requirements on the format of the Excel version of the bill of quantities, and it can only import the bill of quantities with a fixed list template

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • List processing method and apparatus
  • List processing method and apparatus
  • List processing method and apparatus

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0066] In order to enable those skilled in the art to better understand the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only the present invention Some, but not all, embodiments are invented. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0067] see figure 1 , which shows that the list processing method provided by the embodiment of the present invention is applied to the Bill of Quantities of the Excel version, wherein the Bill of Quantities of the Excel version refers to the Bill of Quantities recorded in Excel, figure 1 The illustrated manifest processing method may include the following step...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

An embodiment of the invention provides a list processing method and apparatus. The list processing method comprises the steps of: determining a to-be-imported Excel-version list of engineering quantity and importing the Excel-version list of engineering quantity; extracting first header field names from the imported Excel-version list of engineering quantity; matching the first header field names with second header field names in a standard field name library; obtaining data corresponding to each first header field name from the imported Excel-version list of engineering quantity; and writing the data corresponding to each first header field name into the second header field names matched with first header fields, so as to convert the imported Excel-version list of engineering quantity into a standard Excel-version list of engineering quantity. According to the list processing method provided by the embodiment of the invention, the format of the imported list of engineering quantity is not limited, and the importing of the list of engineering quantity can be finished through format conversion; and compared to a manual importing mode, the importing time is shortened and the working efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of Excel version list processing, in particular to a list processing method and device. Background technique [0002] The Bill of Quantities of the Excel version is a form that uses Microsoft Office Excel to record engineering quantities. Microsoft Office Excel is one of the components of Microsoft Office, Microsoft's office software. It is written by Microsoft for computers with Windows and Apple Macintosh operating systems. A spreadsheet software that runs. As an important part of Microsoft Office suite software, Microsoft Office Excel can perform various data processing, statistics and analysis operations, and is widely used in many fields such as management, statistics, finance, and finance. [0003] At present, there are two ways to import the Excel version of the bill of quantities into the database: one is to manually input the Excel version of the bill of quantities into the database one by one; the...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/24
Inventor 李小明李永顺吴峰
Owner CHINA TIESIJU CIVIL ENG GRP CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap