CN113885868B - A method for automatically generating CNC machining program sheets using Excel software - Google Patents
A method for automatically generating CNC machining program sheets using Excel softwareInfo
- Publication number
- CN113885868B CN113885868B CN202111236085.XA CN202111236085A CN113885868B CN 113885868 B CN113885868 B CN 113885868B CN 202111236085 A CN202111236085 A CN 202111236085A CN 113885868 B CN113885868 B CN 113885868B
- Authority
- CN
- China
- Prior art keywords
- program
- information
- machining
- processing
- button
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Numerical Control (AREA)
Abstract
本发明提供一种用excel软件自动生成数控加工程序单的方法，包括如下步骤建立excel软件与PowerMill编程软件的连接关系并获取PowerMill编程软件中目标模型的形状构造信息和加工程序信息，加工程序信息包括多个分步加工程式；利用excel软件以表单的形式展示形状构造信息和加工程序信息，表单包括程序单页面和控制按钮页面，程序单页面包括图片展示区和加工信息表，形状构造信息设置在图片展示区中，多个分步加工程式按照预设加工顺序依次排列在加工信息表，控制按钮页面设置有用于修改和更新程序单页面的相关数据的表单按钮；从加工信息表和表单按钮中获取修改数据；根据获取的修改数据自动更新程序单页面并输出程序单。本发明具有方便修改、节省时间和提高效率的优点。
The present invention provides a method for automatically generating a numerical control (NC) machining program sheet using Excel software, comprising the following steps: establishing a connection between Excel software and PowerMill programming software and obtaining shape construction information and machining program information of a target model in the PowerMill programming software, wherein the machining program information includes multiple step-by-step machining formulas; displaying the shape construction information and machining program information in the form of a form using Excel software, wherein the form includes a program sheet page and a control button page, wherein the program sheet page includes an image display area and a machining information table, wherein the shape construction information is provided in the image display area, and multiple step-by-step machining formulas are sequentially arranged in the machining information table according to a preset machining sequence; and wherein the control button page includes a form button for modifying and updating relevant data on the program sheet page; obtaining modified data from the machining information table and the form button; and automatically updating the program sheet page based on the obtained modified data and outputting the program sheet. The present invention has the advantages of convenient modification, time saving, and improved efficiency.
Description
Technical Field
The invention relates to the technical field of software development, in particular to a method for automatically generating a numerical control machining program list by using excel software.
Background
Along with the continuous increase of production tasks, the requirements on the processing efficiency are higher and higher, for numerical control processing, the most important work is numerical control programming, and the numerical control programming process can be summarized into a plurality of basic steps of understanding a process scheme, clamping a workpiece, establishing a coordinate system, inputting cutter parameters, programming a numerical control program, verifying the program and the like, so that the information can be clearly and accurately transmitted to an operator, and the numerical control processing method becomes an important ring in the production processing. The numerical control processing program list is a document capable of expressing various information concerned by numerical control processing and plays a vital role in the production process.
In the prior art, engineers are generally required to manually fill in numerical control program sheets, and in the filling process, errors are difficult to avoid, and once the errors occur, the normal work of the subsequent numerical control processing is affected. At present, some enterprises rely on a secondary development system of programming software to automatically generate a numerical control machining program list for ensuring accuracy, but the secondary development process is complex and tedious, and the automatically generated numerical control machining program list cannot be modified generally. In the numerical control machining process, if a certain clamping device designated in a numerical control machining program list is damaged and cannot be repaired in a short time, other clamping devices are replaced, at this time, the clamping type is required to be modified in programming software, a new numerical control machining program list is regenerated through a secondary development system, and because the regeneration of the new numerical control machining program list consumes more time, the working efficiency is seriously affected.
Disclosure of Invention
The invention aims to provide a method for automatically generating a numerical control machining program list by using excel software, which is convenient to modify, simple and clear to operate, time-saving and efficiency-improving.
In order to achieve the above purpose, the method for automatically generating the numerical control machining program list by using the excel software provided by the invention comprises the excel software and PowerMill programming software, and further comprises the following steps:
Establishing a data connection relation between excel software and PowerMill programming software, and acquiring shape construction information and machining program information of a target model in the PowerMill programming software, wherein the shape construction information comprises model pictures, and the machining program information comprises a plurality of step-by-step machining programs;
The method comprises the steps that excel software is utilized to display the acquired shape construction information and processing program information in the form of a form, the form comprises a program form page and a control button page, the program form page comprises a picture display area and a processing information table, a model picture is arranged in the picture display area, a plurality of step-by-step processing programs are sequentially arranged in the processing information table according to a preset processing sequence, the control button page is provided with a plurality of form buttons, and the form buttons are used for modifying and updating relevant data of the program form page;
Obtaining modification data through excel software, wherein the modification data is obtained from a processing information table and a form button;
And the excel software automatically updates the program list page according to the acquired modification data, and outputs the program list according to the program list page.
According to the scheme, the excel software is connected with the PowerMill programming software data, so that a user can execute related operations in the excel software, shape construction information and processing program information of a target model preset in the PowerMill programming software are automatically obtained, a program list required by numerical control processing staff is automatically generated, when certain data in the program list is required to be modified according to actual processing conditions, as the excel software is communicated with the PowerMill programming software data, a programming engineer can directly modify the data in the excel software, and control related data in the PowerMill programming software and the excel software to be synchronously updated.
The step processing program comprises program name, processing purpose, cutter number, clearance, clamping type, cutter loading length, feeding, rotating speed, lowest point, allowance, cutter feeding amount and processing time, wherein in the processing information table, the program name, processing purpose, cutter number, clearance, clamping type, cutter loading length, feeding, rotating speed, lowest point, allowance, cutter feeding amount and processing time can be manually modified.
According to the scheme, parameters required by data processing are displayed in a list mode, so that a user can conveniently check and modify the parameters, and the method is simple and clear and convenient to operate.
The control button page is provided with the following form buttons, namely a coordinate refreshing button, a picture displaying button, a one-key processing button, a refreshing lowest point button, an output button, a refreshing time button, a new path adding button, a post processing/marking button, a button needing interference, a path interference button, a whole refreshing button and a storing and printing button.
In a further scheme, the target model is provided with a plurality of coordinate systems, each coordinate system has unique identity information and unique position information, and the position information corresponds to the identity information one by one;
the refreshing coordinate button is used for intercepting a model picture containing the selected coordinate system in PowerMill programming software according to the selected coordinate system and displaying the model picture in a program menu page of excel software;
after the identity information of the selected coordinate system is obtained in the control button page and the coordinate refreshing instruction is obtained, the excel software controls the PowerMill programming software to intercept a model picture of the target model containing the selected coordinate system and display the model picture in a program list page of the excel software, and the selected coordinate system corresponds to the identity information of the selected coordinate system.
As can be seen from the above solution, since the PowerMill programming software target model is preset with a plurality of different coordinate systems, only one coordinate system needs to be selected in the numerical control machining process, and the model picture including the selected coordinate system is intercepted in the PowerMill programming software according to the identity information of the selected coordinate system, compared with intercepting all coordinate systems one by one, the embodiment can save screenshot and software processing time, and improve working efficiency; the coordinate system is directly displayed on the model picture in the program list, and the identity information of the current coordinate system is displayed in the control button page, so that the method has the obvious effect, and is convenient for a programming engineer to check whether the coordinate system is correctly set, and is also convenient for a numerical control machining worker to set the coordinate of the machining machine tool according to the program list.
The picture display button is used for displaying the tool path tracks of the selected step-by-step machining programs in the control button page, and the tool path tracks of all the step-by-step machining programs are obtained from PowerMill programming software in advance;
And acquiring information of the selected step-by-step processing program in the processing information table, and after acquiring a picture display instruction in the control button page, automatically displaying a tool path track of the selected step-by-step processing program in the control button page by excel software, wherein the selected step-by-step processing program corresponds to the information of the selected step-by-step processing program.
According to the method and the device, when the shape construction information and the processing program information of the target model are acquired for the first time, the tool path tracks corresponding to each step processing program are stored in a one-to-one screenshot mode, so that a subsequent programming engineer can check the tool path tracks one by one conveniently, compared with the process of checking one tool path track screenshot once, the method and the device can save time for taking each tool path track, improve the efficiency of checking the tool path tracks by the programming engineer, and are convenient for the programming engineer to check whether the tool path tracks are correct or not by arranging the display picture buttons.
The post-processing/marking button is used for converting the tool path track into a numerical control machine tool processing program and outputting the numerical control machine tool processing program to a preset folder;
and acquiring information of the selected step-by-step machining program in the machining information table, and after acquiring a post-processing/marking instruction in the control button page, controlling the PowerMill programming software by using the excel software to convert a tool path track of the selected step-by-step machining program into a numerical control machine tool machining program and outputting the numerical control machine tool machining program to a preset folder, wherein the information of the selected step-by-step machining program corresponds to the selected step-by-step machining program.
According to the scheme, through setting the post-processing/marking buttons, the PowerMill programming software is conveniently controlled to automatically convert tool path tracks corresponding to each step-by-step processing program into processing program codes required by the data processing machine tool, and output and store the processing program codes into the shared folder, so that the processing program codes are convenient for numerical control processing staff to take.
The refreshing lowest point button is used for modifying the tool path track of the target model corresponding to the lowest point data in the PowerMill programming software according to the lowest point data acquired in the excel software;
And acquiring modified nadir information in a processing information table, wherein the modified nadir information comprises nadir data and selected step processing program information where the nadir data is located, and after a control button page acquires a refreshing nadir instruction, the excel software controls the PowerMill programming software to modify the tool path track of the selected step processing program and the nadir data of the selected step processing program according to the modified nadir information, wherein the selected step processing program corresponds to the selected step processing program information.
According to the scheme, the one-key processing button is arranged and is used for comprehensively acquiring or updating all information in the program single page by one key, the operation is convenient, the time is long, the refreshing lowest point button is arranged and is used for independently acquiring or updating the tool path track and the lowest point data of the tool path track in the corresponding step processing program, and compared with one-key processing, the one-key processing method has the advantage of saving time.
The new tool path button is used for automatically updating the relevant processing parameters of the new step processing program according to the program name of the new step processing program;
And after the control button page acquires a new program name and a new tool path instruction, the excel software acquires relevant processing parameters of the new step processing program from PowerMill programming software according to the new program name and displays the relevant processing parameters in the processing information table, wherein the new step processing program corresponds to the new program name, and the relevant processing parameters comprise processing purposes, tools, tool numbers, clearance, clamping types, tool loading lengths, feeding, rotating speeds, minimum points, allowance, tool feeding amount and processing time.
According to the scheme, by setting the newly added tool path button, when a programming engineer discovers that the step processing program is omitted, a line of program names of the specific step processing program can be manually and directly added in the processing information table, and then other processing parameters of the step processing program can be automatically acquired and generated by clicking the newly added tool path button.
The interference tool path button is used for updating the data of the tool length in the step processing program;
And acquiring modified clamping type information in a machining information table, wherein the modified clamping type information comprises step-by-step machining program identity information in which the modified clamping type information is positioned, after the control button page acquires an interference tool path instruction, the excel software controls the PowerMill programming software to modify the clamping type of the target model according to the modified clamping type information, and automatically calculates and updates modified tool length data corresponding to the modified clamping type, so that data in the excel software is synchronous with data storage in the PowerMill programming software.
According to the scheme, when a programming engineer finds that the tool loading length of a certain step processing program exceeds the standard range of the clamping device, the clamping type of the step processing program is manually modified, and the interference tool path button is clicked, so that the data of the tool loading length can be automatically calculated and updated, the manual calculation is not needed, and the operation is simple, convenient and quick.
Drawings
FIG. 1 is a flow chart of an embodiment of the present invention.
FIG. 2 is a schematic diagram of the structure of a target model and its coordinate system in PowerMill programming software according to an embodiment of the invention.
FIG. 3 is a schematic diagram of a control button page in a form automatically generated using an embodiment of the present invention.
FIG. 4 is a flow chart of refreshing coordinates in an embodiment of the invention.
Fig. 5 is a flowchart showing the path trajectory in the embodiment of the present invention.
Fig. 6 is a flowchart of a machining program of an output nc machine in an embodiment of the present invention.
FIG. 7 is a flow chart of refreshing nadir alone in an embodiment of the invention.
FIG. 8 is a flowchart of an additional step-by-step process program in accordance with an embodiment of the present invention.
FIG. 9 is a flow chart of the modification of the blade length data in an embodiment of the present invention.
FIG. 10 is a program ticket automatically generated using an embodiment of the present invention.
The invention is further described below with reference to the drawings and examples.
Detailed Description
Referring to fig. 1 to 3, and in combination with fig. 10, a method for automatically generating a numerical control machining program list by using excel software according to this embodiment includes excel software and PowerMill programming software, where a target model and a machining program of the target model are preset in the PowerMill programming software. The method of the embodiment comprises the following steps:
And step S1, establishing a data connection relation between excel software and PowerMill programming software.
And S2, acquiring shape construction information and machining program information of a target model in PowerMill programming software through a one-key processing button in excel software. The shape construction information comprises a model picture including, but not limited to, six-view and three-dimensional, and the machining program information comprises a plurality of step machining programs required for machining the target model, wherein each step machining program has unique identity information, namely program names of the step machining programs. The step processing program comprises processing parameters and tool path tracks, wherein the processing parameters comprise, but are not limited to, program names, processing purposes, tools, tool numbers, clearance, clamping types, tool loading lengths, feeding, rotating speeds, lowest points, allowance, tool feeding amount and processing time, the tool path tracks are the walking tracks of the processing tools when the tool path tracks are processed into a target model, and the tool path tracks can be displayed in a picture mode.
And step S3, the obtained shape construction information and the obtained processing program information are displayed in the form of a form by using excel software, wherein the form comprises a program list page and a control button page. The program list page comprises a header area, a picture display area and a processing information table. The header area is written with information such as programmer, network name, time of issuing a bill, path of drawing and document, number of mould, personnel of machine tool, clamping and the like. The picture display area is positioned below the header area and is used for displaying information such as pictures, materials, the number of pieces, the actual size of a workpiece, the longitudinal time of a single program, remarks and the like of a target model, and the model picture is arranged in the picture display area. The processing information table is arranged below the picture display area, and a plurality of step processing programs are sequentially arranged in the processing information table according to a preset processing sequence. In order to facilitate the numerical control machining staff to clearly see the target model, a picture can be added in a blank position below the machining information table, the picture comprises the target model and a coordinate system, and the picture can be directly obtained from PowerMill programming software.
The control button page is provided with a plurality of form buttons for modifying and updating the relevant data of the program menu page. The control button page is provided with the following form buttons, namely a coordinate refreshing button, a picture displaying button, a one-key processing button, a refreshing lowest point button, an output button, a refreshing time button, a new path button, a post-processing/labeling button, a button needing interference, a path interference button, a whole refreshing button and a storing and printing button.
And S4, acquiring modification data from the program single page or the control button page.
And S5, automatically updating the program list page according to the acquired modification data.
Step S6, saving and outputting the program list according to the program list page, wherein the program list is output, the program list is converted into a file in pdf format and saved in a designated shared folder, and/or the program list is directly printed into a paper file, as shown in FIG. 10.
In the actual working process, after the excel software generates the program list page, a programming engineer checks whether the information in the program list page is correct or not and accords with the relevant standards of the industry, and if not, the programming engineer can directly modify the corresponding position of the program list page in the excel software. For example, in the machining information table, the program name, the machining purpose, the tool number, the clearance, the clamping type, the tool loading length, the feed, the rotation speed, the lowest point, the allowance, the feed amount, and the machining time can be manually modified. In order to keep the excel software and the PowerMill programming software data synchronized, the present embodiment may control the PowerMill programming software to perform relevant modification operations through the excel software. Six typical examples will be selected for explanation.
For example, one, refresh coordinate system:
Referring to fig. 2 to 4, the target model is a plate-shaped workpiece, and is provided with a plurality of coordinate systems, the coordinate systems are distributed at different positions of the plate-shaped workpiece, each coordinate system has unique identity information and position information, the position information corresponds to the identity information one by one, in this embodiment, the coordinate systems are numbered by arabic numerals, each coordinate system has unique identity numbers, and the position information of the coordinate system in this embodiment is directly displayed in a model picture.
The refresh coordinate button is used for intercepting a model picture containing the selected coordinate system in PowerMill programming software according to the selected coordinate system and displaying the model picture in a program menu page of excel software.
When the excel software obtains the shape construction information of the target model, the position information and the identity information of the coordinate system can be temporarily not obtained, namely, the model picture displayed on the program page temporarily does not contain the model picture with the coordinate system, and at the moment, the coordinate system can be selected by the following steps.
Step S01, acquiring identity information of a selected coordinate system from a control button page of excel software;
step S02, a coordinate refreshing instruction is obtained from a control button page of excel software;
step S03, excel software controls PowerMill programming software to automatically intercept a model picture of a target model including a selected coordinate system, and display the model picture in a program sheet page, wherein the selected coordinate system corresponds to the identity information of the selected coordinate system.
Specifically, the programming engineer inputs the identity information of the selected coordinate system, such as "1", in the control button page, and then clicks the refresh coordinate button, i.e. automatically generates a model picture displayed with the selected coordinate system in a blank space below the processing information table, or directly updates the model picture in the picture display area. In the actual working process, the coordinate system needs to be discussed and decided together by a plurality of processing departments, and in general, the coordinate system is not modified once selected. Therefore, the embodiment can temporarily not acquire the model picture containing the coordinate system when acquiring the shape construction information and the processing program information of the target model by one key, and can be beneficial to saving the processing time of one-key processing by manually inputting the identity information of the selected coordinate system and then independently intercepting the model picture containing the selected coordinate system when needed.
The position of the selected coordinate system is directly displayed in the model picture, and the identity information of the selected coordinate system is displayed on the control button page, so that a programming engineer can conveniently check whether the preset coordinate system is selected correctly.
For example two, the tool path track is displayed:
referring to fig. 3 and 5, a picture button is displayed for displaying the tool path tracks of the selected step-by-step machining program in the control button page, and the tool path tracks of all the step-by-step machining programs are obtained in advance from PowerMill programming software, namely, the excel software automatically grabs the corresponding tool path tracks in the target model and captures a picture, and then the picture is imported into the excel, and the picture is displayed one by one when needed.
Step S11, acquiring the information of the selected step processing program from the processing information table;
step S12, acquiring a picture display instruction from a control button page;
step S13, the excel software automatically displays the tool path track of the selected step processing program in the control button page, wherein the selected step processing program corresponds to the selected step processing program information.
Specifically, the programming engineer selects one of the step-by-step machining programs in the machining information table, and then clicks a display picture button in the control button page, at which time the path track of the step-by-step machining program is displayed in the control button page. Because the tool path track of each step processing program is completely acquired during one-key processing, when a programming engineer needs to check the tool path track of a certain step processing program, the pictures of the tool path track can be rapidly displayed without re-acquiring one by one, and the time is saved.
For example, outputting a numerical control machine tool machining program:
in connection with fig. 3 and 6, the post-processing/labeling button is used to convert the tool path track into a numerical control machining program and output the numerical control machining program to a preset folder, wherein the numerical control machining program is the program code necessary for the numerical control machine to work, and the program code is already written in the PowerMill programming software, and only the corresponding program code needs to be automatically grasped from the PowerMill programming software according to the program name of the step-by-step machining program.
Step S21, acquiring the information of the selected step processing program in the processing information table;
Step S22, acquiring a post-processing/labeling instruction in a control button page;
In step S23, the excel software controls the PowerMill programming software to convert the tool path track of the selected step-by-step machining program into a numerical control machining program and output the numerical control machining program to the preset folder, wherein the selected step-by-step machining program information corresponds to the selected step-by-step machining program. Because the numerical control machining program is pre-programmed, when in conversion, the PowerMill programming software can automatically output the corresponding numerical control machining program according to the tool path track.
Specifically, a programming engineer selects one step processing program or simultaneously selects a plurality of step processing programs in the processing information table, then selects a post-processing/labeling button in a control button page, and can automatically output a corresponding numerical control machine tool processing program, namely NC codes, to a preset folder of a shared channel, so that the numerical control processing worker can conveniently take the numerical control machine tool processing program. In order to facilitate the programming engineer to see at a glance which step-by-step machining programs have output NC codes and which step-by-step machining programs have not output NC codes, it is preferable to set a column of "post-processing" in the machining information table (not shown in the figure), if NC codes have been output, the column of "post-processing" displays "v", and vice versa. Since the "post-processing" column is independent of the numerical control machining, it is not necessary to output or print the column when outputting or printing the program ticket.
Example four, refresh nadir:
With reference to fig. 3 and fig. 7, the one-button processing button is used to acquire or update the shape construction information and the machining program information of the target model in the PowerMill programming software, and all data in the program single page is updated at one time through the one-button processing button, so that the capturing or updating takes a long time because the data in the program single page is more. The refreshing lowest point button is used for modifying the tool path track of the target model corresponding to the lowest point data in the PowerMill programming software according to the lowest point data acquired in the excel software, so that the data of the excel software and the data of the PowerMill programming software are kept synchronous, and compared with the one-key processing button, the refreshing method has the advantages of being high in updating speed and short in updating time.
Step S31, acquiring modified minimum point information in a processing information table, wherein the modified minimum point information comprises minimum point data and selected step-by-step processing program information of the minimum point data;
Step S32, acquiring a refreshing lowest point instruction on a control button page;
In step S33, the excel software controls the PowerMill programming software to modify the tool track and the nadir data of the selected step-by-step machining program according to the obtained modified nadir information, wherein the selected step-by-step machining program corresponds to the selected step-by-step machining program information, and the selected step-by-step machining program information corresponds to the selected step-by-step machining program.
Specifically, when a programming engineer finds that the lowest point data of a certain step-by-step machining program in the machining information table is unreasonable, the lowest point data can be manually modified in the machining information table, then a refreshing lowest point button is clicked, and the excel software controls the PowerMill programming software to modify the tool path track corresponding to the step-by-step machining program, the lowest point data and the numerical control machine tool machining program, so that the data in the excel software are the same as the data in the PowerMill programming software, and the PowerMill programming software converts and outputs an accurate numerical control machine tool machining program.
Fifth, add a new process applet:
Referring to fig. 3 and 8, the new tool path button is used to automatically update relevant processing parameters of the new step processing program according to the program name of the new step processing program, where the relevant processing parameters include processing purpose, tool number, clearance, clamping type, tool loading length, feeding, rotation speed, lowest point, allowance, tool feeding amount and processing time.
Step S41, obtaining a new program name from a processing information table;
step S42, obtaining a new path adding instruction on a control button page;
In step S43, the excel software obtains the relevant processing parameters of the newly added step processing program from the PowerMill programming software according to the newly added program name and displays the processing parameters in the processing information table, wherein the newly added step processing program corresponds to the newly added program name.
Specifically, if the programming engineer finds that a certain step-by-step machining program is omitted in the machining information table, a row is newly added at a corresponding position of the machining information table, a new program name of the new step-by-step machining program is filled in a first grid of the row, then a new tool path button is clicked, and excel software can automatically acquire corresponding machining parameters in PowerMill programming software according to the new program name and automatically display the corresponding machining parameters in the machining information table.
For example six, modify the knife length data:
referring to fig. 3 and 9, the interference tool path button is used to update the tool length data in the step program. In general, the loading length is less than or equal to 5 times the diameter of the cutter.
Step S51, acquiring modified clamping type information in the machining information, wherein the modified clamping type information comprises step-by-step machining program identity information in which the modified clamping type information is located;
Step S52, acquiring an interference tool path instruction on a control button page;
step S53, the excel software controls the PowerMill programming software to modify the clamping type of the corresponding step machining program in the target model according to the acquired modified clamping type information, and automatically calculates and updates modified tool length data corresponding to the modified clamping type, wherein the step machining program corresponds to the step machining program identity information.
Specifically, if the programming engineer finds that the tool loading length data in a certain step processing program in the processing information table is greater than 5 times of the diameter of the tool, at this time, under the condition that the tool is kept unchanged, other clamping devices can be selected in the clamping type, then an interference tool path button is selected, and the excel software controls the PowerMill programming software to modify the clamping type in the corresponding step processing program, and automatically calculates and updates the tool loading length data, so that the data of the PowerMill programming software and the data of the excel software are kept synchronous. To facilitate viewing whether the tool length data is recalculated, a column of "interfered" is preferably provided in the process information table (not shown). After the clamping device is selected again, the "interfered" list of the processing information table is displayed by "x", and after the tool length data is recalculated and updated, the "interfered" list is displayed by "v". Since an "interfered" column is not related to the numerical control process, it is not necessary to output or print the column when outputting or printing the program ticket.
In summary, the method and the device for generating the numerical control machining program by the digital control machining program are beneficial to a user to execute related operations in the excel software by connecting the excel software with the PowerMill programming software data, so that the shape construction information and the machining program information of a target model preset in the PowerMill programming software are automatically acquired, a program list required by a numerical control machining worker is automatically generated, when certain data in the program list is required to be modified according to actual machining conditions, a programming engineer can directly modify the data in the excel software and control the related data in the PowerMill programming software to be synchronously updated with the excel software, and compared with the prior art that the method and the device for generating the program list in the PowerMill programming software in a re-mode, the method and the device for generating the numerical control machining program list by the digital control machining program by the shape construction method are beneficial to saving time and have the advantage of improving working efficiency.
Finally, it should be emphasized that the foregoing is merely a preferred embodiment of the present invention, and is not intended to limit the invention, but rather that various changes and modifications can be made by those skilled in the art without departing from the spirit and principles of the invention, and any modifications, equivalent substitutions, improvements, etc. are intended to be included within the scope of the present invention.
Claims (8)
1. The method for automatically generating the numerical control machining program list by using the excel software comprises the excel software and the PowerMill programming software and is characterized by further comprising the following steps:
Establishing a data connection relation between the excel software and the PowerMill programming software, and acquiring shape construction information and machining program information of a target model in the PowerMill programming software, wherein the shape construction information comprises model pictures, and the machining program information comprises a plurality of step-by-step machining programs;
The method comprises the steps that the obtained shape construction information and the obtained machining program information are displayed in a form by using excel software, the form comprises a program list page and a control button page, the program list page comprises a picture display area and a machining information table, a model picture is arranged in the picture display area, a plurality of step-by-step machining programs are sequentially arranged in the machining information table according to a preset machining sequence, the control button page is provided with a plurality of form buttons, the form buttons are used for modifying and updating relevant data of the program list page, the form buttons comprise a picture display button, the picture display button is used for displaying tool path tracks of a selected step-by-step machining program in the control button page, all tool path tracks of the step-by-step machining program are obtained in advance from the PowerMill programming software, the machining information table is provided with the selected step-by-step machining program information, and after the picture display instruction is obtained in the control button page, the excel software automatically displays the step-by-step path tracks of the selected step-by-step machining program in the control button page, and the selected step-by-step machining program corresponds to the selected machining program information;
obtaining modification data through the excel software, wherein the modification data are obtained from the processing information table and the form buttons;
And the excel software automatically updates the program list page according to the acquired modification data, and outputs a program list according to the program list page.
2. The method according to claim 1, characterized in that:
The step processing program comprises program name, processing purpose, cutter number, clearance, clamping type, cutter loading length, feeding, rotating speed, lowest point, allowance, cutter feeding amount and processing time;
In the machining information table, the program name, the machining use, the tool number, the clearance, the clamping type, the tool loading length, the feeding, the rotation speed, the lowest point, the allowance, the feed amount, and the machining time may be manually modified.
3. The method according to claim 1, characterized in that:
The control button page is provided with the following form buttons, namely a coordinate refreshing button, a one-key processing button, a refreshing lowest point button, an output button, a refreshing time button, a new path button, a post-processing/marking button, a button needing interference, a path interference button, a whole refreshing button and a storing and printing button.
4. A method according to claim 3, characterized in that:
the target model is provided with a plurality of coordinate systems, each coordinate system is provided with unique identity information and unique position information, and the position information corresponds to the identity information one by one;
The refreshing coordinate button is used for intercepting a model picture containing a selected coordinate system in the PowerMill programming software according to the selected coordinate system and displaying the model picture in a program single page of the excel software;
After the identity information of the selected coordinate system is obtained in the control button page and the coordinate refreshing instruction is obtained, the excel software controls the PowerMill programming software to automatically intercept a model picture of a target model containing the selected coordinate system and display the model picture in a program list page of the excel software, and the selected coordinate system corresponds to the identity information of the selected coordinate system.
5. A method according to claim 3, characterized in that:
The post-processing/marking button is used for converting the tool path track into a numerical control machine tool machining program and outputting the numerical control machine tool machining program to a preset folder;
And after the selected step-by-step machining program information is obtained from the machining information table and the post-processing/marking instruction is obtained from the control button page, the excel software controls the PowerMill programming software to convert the tool path track of the selected step-by-step machining program into a numerical control machine tool machining program and output the numerical control machine tool machining program to the preset folder, and the selected step-by-step machining program information corresponds to the selected step-by-step machining program.
6. A method according to claim 3, characterized in that:
the one-key processing button is used for acquiring shape construction information and machining program information of a target model in the PowerMill programming software;
The refreshing lowest point button is used for modifying a tool path track of the target model corresponding to the lowest point data in the PowerMill programming software according to the lowest point data acquired in the excel software;
And acquiring modified nadir information in the processing information table, wherein the modified nadir information comprises nadir data and selected step processing program information where the nadir data is located, and after the control button page acquires a refreshing nadir instruction, the excel software controls the PowerMill programming software to modify the tool path trace of the selected step processing program and the nadir data of the selected step processing program according to the modified nadir information, wherein the selected step processing program corresponds to the selected step processing program information.
7. A method according to claim 3, characterized in that:
the newly added tool path button is used for automatically updating relevant processing parameters of the newly added step processing program according to the program name of the newly added step processing program;
And after the new program name is acquired in the processing information table and the new tool path instruction is acquired on the control button page, the excel software acquires relevant processing parameters of the new step processing program from the PowerMill programming software according to the new program name and displays the relevant processing parameters in the processing information table, wherein the new step processing program corresponds to the new program name, and the relevant processing parameters comprise processing purposes, tools, tool numbers, clearance, clamping types, tool loading lengths, feeding, rotating speeds, lowest points, allowance, feed amount and processing time.
8. A method according to claim 3, characterized in that:
The interference tool path button is used for updating the data of the tool length in the step processing program;
And acquiring modified clamping type information in the machining information table, wherein the modified clamping type information comprises the identity information of a step-by-step machining program in which the modified clamping type information is positioned, and after the control button page acquires an interference tool path instruction, the excel software controls the PowerMill programming software to modify the clamping type of the step-by-step machining program corresponding to the target model according to the modified clamping type information, and automatically calculates and updates modified tool length data corresponding to the modified clamping type, wherein the step-by-step machining program corresponds to the step-by-step machining program identity information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111236085.XA CN113885868B (en) | 2021-10-22 | 2021-10-22 | A method for automatically generating CNC machining program sheets using Excel software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111236085.XA CN113885868B (en) | 2021-10-22 | 2021-10-22 | A method for automatically generating CNC machining program sheets using Excel software |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113885868A CN113885868A (en) | 2022-01-04 |
| CN113885868B true CN113885868B (en) | 2025-09-30 |
Family
ID=79013393
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111236085.XA Active CN113885868B (en) | 2021-10-22 | 2021-10-22 | A method for automatically generating CNC machining program sheets using Excel software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113885868B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114296394B (en) * | 2022-01-13 | 2024-07-05 | 东莞泰极科技有限公司 | CNC machining tool path processing method and workpiece machining process |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110597187A (en) * | 2019-09-27 | 2019-12-20 | 天津航天机电设备研究所 | A NC Machining Program Sheet Generation Method Based on UGNX Secondary Development |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0879674B1 (en) * | 1996-11-07 | 2003-04-02 | Mitutoyo Corporation | Generation of measurement program in nc machining and machining management based on the measurement program |
| KR100434025B1 (en) * | 2001-12-31 | 2004-06-04 | 학교법인 포항공과대학교 | Method for automatically generating part program for use in step-nc |
| JP2019028641A (en) * | 2017-07-28 | 2019-02-21 | 三菱電機株式会社 | Machining program editing device, machining program editing method, and machining program editing program |
| CN108197730A (en) * | 2017-12-23 | 2018-06-22 | 武汉益模科技股份有限公司 | A kind of CNC machine processing flow optimization method |
| JP7339069B2 (en) * | 2019-08-27 | 2023-09-05 | ファナック株式会社 | Machining program generation support device |
| CN110580000B (en) * | 2019-09-29 | 2021-07-13 | 华南理工大学 | An automatic programming method for handling die finishing machining allowance |
-
2021
- 2021-10-22 CN CN202111236085.XA patent/CN113885868B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110597187A (en) * | 2019-09-27 | 2019-12-20 | 天津航天机电设备研究所 | A NC Machining Program Sheet Generation Method Based on UGNX Secondary Development |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113885868A (en) | 2022-01-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111992911B (en) | Visual positioning method based on paraxial visual structure galvanometer jigsaw processing | |
| CN112508763B (en) | Laser processing method, laser processing apparatus, and storage medium | |
| CN113885868B (en) | A method for automatically generating CNC machining program sheets using Excel software | |
| US8359111B2 (en) | Method and apparatus for controlling a distributed automation system | |
| JP6761004B2 (en) | Tool management system, tool management device and tool management method | |
| CN105117514A (en) | Modular automatic drawing output method and system | |
| CN104573254A (en) | Pre-construction technical disclosure method based on BIM | |
| US20220398355A1 (en) | Design support device and storage medium | |
| US10838397B2 (en) | Complement method and system of the identification number used in the engraving machine | |
| CN106066639A (en) | Product manufacturing/processing stations/operation foundation/management method, system, equipment | |
| CN114091127B (en) | Automatic programming method, system, device and storage medium | |
| CN104570949B (en) | A kind of generation method and device of the numerical control program of gas cutting steel plate | |
| CN116680773A (en) | BIM-based visual construction lofting method | |
| KR20200065933A (en) | Measurement and Management System for Mold Manufacture Machine | |
| JP2927512B2 (en) | Setup information processing device of NC processing machine | |
| JP2012048471A (en) | Numerical control device and macro program execution method | |
| JP5763352B2 (en) | NC program creation device | |
| JPH0635092B2 (en) | Numerical control device with tool file | |
| CN102478819A (en) | Novel method for realizing breakpoint continuation in numerical control machine tool system | |
| CN105573975A (en) | Automatic platemaking system and method for chart notice correction template | |
| JPS63148307A (en) | NC information creation device | |
| CN109685524A (en) | A kind of trace mode of PCB production board quality | |
| JP2015210582A (en) | Structure design and engineering information creation system and structure design and engineering information creation method | |
| JPS62166951A (en) | Scheduled operating method of machining line | |
| JPH0816665A (en) | Work process display device |
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 |