Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for importing chart contents in CAD program into Excel program

A program and chart technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problem of low efficiency of manual input data, achieve the effect of simple and fast secondary development method, and improve work efficiency

Inactive Publication Date: 2018-11-06
CHINA RAILWAY SHANQIAO GRP CO LTD
View PDF5 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Through secondary development, ACAD and EXCEL can be solved for data intercommunication. Using manual input data is extremely inefficient and can lead to various errors

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
  • Method for importing chart contents in CAD program into Excel program

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0029] see figure 1 , a method for importing the chart content in the CAD program into the Excel program provided by the embodiment of the present invention, such as figure 1 As shown, the method includes:

[0030] The secondary development of the CAD program through VISUAL LISP enables the CAD program to perform the following processing:

[0031] S101: Determine the target content area to be processed in the target interface, the target content area is the area where the chart content is located; specifically, obtain the coordinate information of two points in the target interface selected by the user, and use the two points as The rectangular area enclosed by two diagonal points is used as the target content area.

[0032] S102: Recognize the content displayed in the target content area to obtain a recognition result, the recognition result includes the lines included in the chart, text data and their respective coordinate information;

[0033] S103: According to the reco...

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

The invention discloses a method for importing chart contents in a CAD program into an Excel program. The method comprises the steps of carrying out secondary development on the CAD program, so that the CAD program executes the following processing of determining a to-be-processed target content area in a target interface, and identifying contents displayed in the target content area to obtain anidentification result, wherein the identification result comprises lines comprised in a chart, text data and corresponding coordinate information; and according to the recognition result, determiningcells comprised in the chart contents, the text data in the cells and relative position relations between the cells, and generating logic structure data which can be identified by the Excel program according to the information. According to the method provided by the invention, the secondary development method for the CAD program is simple, convenient and rapid; and the CAD program subjected to the secondary development can be used for quickly and accurately exporting tables in the CAD chart and the text data in the tables, so that the working efficiency of workers is greatly improved.

Description

technical field [0001] The invention relates to the technical field of data import, in particular to a method for importing chart content in a CAD program into an Excel program. Background technique [0002] As a general-purpose drawing software, ACAD is widely used in various fields. It has a huge advantage in the transformation of bridge construction detailed drawings. The material table in the detailed drawings contains a large amount of text data, and ACAD itself lacks the ability to process large amounts of data. When the factory manufactures steel structures, it needs to merge and classify a large amount of data in the construction drawings. Currently, EXCEL is used for these tasks. Through the secondary development, the data exchange between ACAD and EXCEL can be solved. Using manual input data is extremely inefficient and can lead to various errors. Contents of the invention [0003] The invention provides a method for importing chart content in a CAD program int...

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/30
Inventor 尹春明孙树松李华冰张帆乔新旺
Owner CHINA RAILWAY SHANQIAO GRP CO LTD