A method for automatically generating CNC machining program sheets using Excel software

Abstract

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; utilizing Excel software to display the shape construction information and machining program information in the form of a form, 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

[0001] The present invention relates to the technical field of software development, in particular to a method for automatically generating a numerical control machining program sheet by using Excel software. Background Art

[0002] As production tasks continue to increase, the demand for machining efficiency is becoming increasingly higher. For CNC machining, the most important task is CNC programming. The CNC programming process can be summarized into several basic steps: understanding the process plan, workpiece clamping, establishing the coordinate system, entering tool parameters, compiling the CNC program, and program verification. How to clearly and accurately convey this information to the operator has become a critical part of production and machining. The CNC machining program sheet is a document that can express various information related to CNC machining and plays a vital role in the production process.

[0003] In the existing technology, engineers are generally required to fill out the CNC program sheet manually. It is difficult to avoid making mistakes during the filling process, and once an error occurs, it will affect the normal operation of the subsequent CNC machining. At present, some companies rely on the secondary development system of programming software to automatically generate CNC machining program sheets to ensure accuracy. However, the secondary development process is complicated and tedious, and the automatically generated CNC machining program sheets generally cannot be modified. During the CNC machining process, if a clamping device specified in the CNC machining program sheet is damaged and cannot be repaired in a short period of time, it is necessary to replace other clamping devices. At this time, it is necessary to modify the clamping type in the programming software and regenerate a new CNC machining program sheet through the secondary development system. Since regenerating a new CNC machining program sheet takes a lot of time, it seriously affects work efficiency. Summary of the Invention

[0004] The purpose of the present invention is to provide a method for automatically generating a numerical control machining program sheet using Excel software, which is convenient to modify, simple and clear to operate, can save time and improve efficiency.

[0005] To achieve the above-mentioned purpose, the present invention provides a method for automatically generating a CNC machining program sheet using Excel software, comprising Excel software and PowerMill programming software, and further comprising the following steps:

[0006] Establish a data connection between Excel and PowerMill programming software and obtain the shape construction information and machining program information of the target model in PowerMill programming software. The shape construction information includes the model image, and the machining program information includes multiple step-by-step machining formulas.

[0007] Excel software is used to display the acquired shape structure information and processing program information in the form of a form. The form includes a program single page and a control button page. The program single page includes a picture display area and a processing information table. The model picture is set in the picture display area. Multiple step-by-step processing formulas are arranged in sequence in the processing information table according to a preset processing sequence. The control button page is provided with multiple form buttons, which are used to modify and update relevant data on the program single page.

[0008] Get the modified data through Excel software, and get the modified data from the processing information table and form buttons;

[0009] The Excel software automatically updates the program sheet page according to the acquired modification data, and outputs the program sheet according to the program sheet page.

[0010] As can be seen from the above scheme, the present invention connects the Excel software with the PowerMill programming software data, which is beneficial for users to perform relevant operations in the Excel software to automatically obtain the shape structure information and processing program information of the target model pre-set in the PowerMill programming software, and automatically generate the program sheet required by the CNC machining staff; when it is necessary to modify certain data in the program sheet according to the actual machining situation, since the Excel software is connected with the PowerMill programming software data, the programming engineer can directly modify the data in the Excel software and control the relevant data in the PowerMill programming software to keep synchronized with the Excel software. Compared with the prior art of modifying data in the PowerMill programming software and regenerating the program sheet, the present invention is beneficial to saving the time consumed in regenerating the program sheet, and has the advantages of saving time and improving work efficiency.

[0011] A further solution is that the step-by-step processing program includes the program name, processing purpose, tool, tool number, avoidance, clamping type, tool length, feed, speed, lowest point, allowance, feed amount and processing time; in the processing information table, the program name, processing purpose, tool, tool number, avoidance, clamping type, tool length, feed, speed, lowest point, allowance, feed amount and processing time can all be modified manually.

[0012] As can be seen from the above scheme, by displaying the parameters required for data processing in a list format, it is convenient for users to view and modify them, which is simple, clear and easy to operate.

[0013] A further solution is that the control button page is provided with the following form buttons: refresh coordinate button, display picture button, one-key processing button, refresh lowest point button, output button, refresh time button, add tool path button, post-processing / marking button, interference required button, interference tool path button, refresh all button and save and print button.

[0014] A further solution is that the target model is provided with multiple coordinate systems, each coordinate system has unique identity information and unique position information, and the position information and the identity information correspond one to one;

[0015] The Refresh Coordinates button is used to capture the model image containing the selected coordinate system in the PowerMill programming software and display it in the program single page of the Excel software;

[0016] After obtaining the selected coordinate system identity information and the refresh coordinate instruction on the control button page, the Excel software controls the PowerMill programming software to capture the model image of the target model containing the selected coordinate system and displays it on the program single page of the Excel software. The selected coordinate system corresponds to the selected coordinate system identity information.

[0017] It can be seen from the above scheme that since multiple different coordinate systems are pre-set in the target model of the PowerMill programming software, and only one coordinate system needs to be selected during the CNC machining process, by intercepting the model image of the target model containing the selected coordinate system in the PowerMill programming software according to the identity information of the selected coordinate system, compared with intercepting all coordinate systems one by one, this embodiment can save screenshot and software processing time and improve work efficiency; the coordinate system is directly displayed on the model image in the program sheet and the identity information of the current coordinate system is displayed in the control button page, which has a clear effect, which is convenient for programming engineers to check whether the coordinate system setting is correct, and it is convenient for CNC machining staff to set the coordinates of the machining machine according to the program sheet.

[0018] A further solution is that the display picture button is used to display the tool path trajectory of the selected step-by-step machining process in the control button page, and the tool path trajectory of all step-by-step machining processes is obtained in advance from the PowerMill programming software;

[0019] After obtaining the selected step-by-step machining formula information in the processing information table and obtaining the display picture instruction in the control button page, the Excel software automatically displays the tool path trajectory of the selected step-by-step machining formula in the control button page. The selected step-by-step machining formula corresponds to the selected step-by-step machining formula information.

[0020] As can be seen from the above scheme, the present invention will take screenshots of the tool path trajectories corresponding to each step-by-step processing formula when the shape structure information and processing program information of the target model are obtained for the first time, so that subsequent programming engineers can easily view the tool path trajectories one by one. Figure 1 Compared with the above, the present invention can save the time of retrieving each tool path trajectory and improve the efficiency of programming engineers in checking tool path trajectories; by setting a display picture button, it is convenient for programming engineers to check whether the tool path trajectory is correct.

[0021] In a further solution, a post-processing / marking button is used to convert the tool path trajectory into a CNC machine tool processing program and output the CNC machine tool processing program to a preset folder;

[0022] After obtaining the selected step-by-step machining formula information in the machining information table and obtaining the post-processing / marking instructions in the control button page, the Excel software controls the PowerMill programming software to convert the tool path trajectory of the selected step-by-step machining formula into a CNC machine tool machining program and output it to a preset folder. The selected step-by-step machining formula information corresponds to the selected step-by-step machining formula.

[0023] As can be seen from the above solution, by setting the post-processing / marking button, the PowerMill programming software can be conveniently controlled to automatically convert the tool path trajectory corresponding to each step-by-step processing formula into the processing program code required by the data processing machine tool and output it to a shared folder for easy access by CNC processing personnel.

[0024] A further solution is that the one-key processing button is used to obtain the shape structure information and machining program information of the target model in the PowerMill programming software; the refresh lowest point button is used to modify the tool path trajectory corresponding to the lowest point data of the target model in the PowerMill programming software according to the lowest point data obtained in the Excel software;

[0025] Obtain the modified lowest point information in the machining information table. The modified lowest point information includes the lowest point data and the selected step-by-step machining formula information. After obtaining the refresh lowest point instruction on the control button page, the Excel software controls the PowerMill programming software to modify the tool path trajectory and the lowest point data of the selected step-by-step machining formula according to the modified lowest point information. The selected step-by-step machining formula corresponds to the selected step-by-step machining formula information.

[0026] It can be seen from the above scheme that by setting a one-key processing button, all information in a single page of the program can be fully obtained or updated with one click. The operation is convenient but time-consuming. By setting a refresh lowest point button, the tool path trajectory and its lowest point data in the corresponding step-by-step machining formula can be separately obtained or updated. Compared with one-key processing, it has the advantage of saving time.

[0027] A further solution is to add a tool path button for automatically updating the relevant processing parameters of the newly added step-by-step machining program according to the program name of the newly added step-by-step machining program;

[0028] After obtaining the newly added program name in the processing information table and the newly added tool path instruction on the control button page, the Excel software obtains the relevant processing parameters of the newly added step-by-step processing program from the PowerMill programming software according to the newly added program name and displays them in the processing information table. The newly added step-by-step processing program corresponds to the newly added program name. The relevant processing parameters include processing purpose, tool, tool number, avoidance, clamping type, tool length, feed, speed, lowest point, allowance, feed amount and processing time.

[0029] As can be seen from the above scheme, by setting the Add Tool Path button, when the programming engineer finds that a step-by-step machining formula is missing, he can manually add a new row in the machining information table and fill in the program name of the specific step-by-step machining formula, and then click the Add Tool Path button to automatically obtain and generate other machining parameters of the step-by-step machining formula, which has the advantages of convenient and simple operation.

[0030] A further solution is that the interference tool path button is used to update the tool length data in the step-by-step machining process;

[0031] Obtain the modified clamping type information in the processing information table. The modified clamping type information includes the identity information of the step-by-step machining formula to which it belongs. After obtaining the interference tool path instruction on the control button page, 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 the modified tool length data corresponding to the modified clamping type, so that the data in the Excel software is synchronized with the data in the PowerMill programming software.

[0032] As can be seen from the above scheme, when the programming engineer finds that the tool length of a certain step-by-step machining process exceeds the standard range of its clamping device, by manually modifying the clamping type of the step-by-step machining process and clicking the interference tool path button, the tool length data can be automatically calculated and updated without the need for manual calculation. The operation is simple, convenient and fast. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 is a flow chart of an embodiment of the present invention.

[0034] Figure 2 It is a schematic structural diagram of a target model and its coordinate system in the PowerMill programming software according to an embodiment of the present invention.

[0035] Figure 3 It is a schematic diagram of a control button page in a form automatically generated by applying an embodiment of the present invention.

[0036] Figure 4 4 is a flow chart of refreshing coordinates in an embodiment of the present invention.

[0037] Figure 5It is a flow chart showing the tool path trajectory in an embodiment of the present invention.

[0038] Figure 6 It is a flow chart of outputting a CNC machine tool processing program in an embodiment of the present invention.

[0039] Figure 7 This is a flow chart of refreshing the lowest point individually in an embodiment of the present invention.

[0040] Figure 8 It is a flowchart of a newly added step-by-step processing formula in an embodiment of the present invention.

[0041] Figure 9 This is a flow chart of modifying knife length data in an embodiment of the present invention.

[0042] Figure 10 It is a program sheet automatically generated by applying the embodiment of the present invention.

[0043] The present invention will be further described below with reference to the accompanying drawings and embodiments. DETAILED DESCRIPTION

[0044] See also Figures 1 to 3 , and combined with Figure 10 This embodiment provides a method for automatically generating a CNC machining program using Excel software, including Excel software and PowerMill programming software. The PowerMill programming software is pre-set with a target model and a machining program for the target model. The method of this embodiment includes the following steps:

[0045] Step S1: Establish a data connection relationship between Excel software and PowerMill programming software.

[0046] Step S2: Obtain the shape construction information and machining program information of the target model in the PowerMill programming software through the one-click processing button in the Excel software. The shape construction information includes model images, including but not limited to six views and stereograms; the machining program information includes multiple step-by-step machining formulas required to machine the target model, and each step-by-step machining formula has unique identity information, i.e., the program name of the step-by-step machining formula. The step-by-step machining formula includes machining parameters and tool path trajectories, and the machining parameters include but are not limited to: program name, machining purpose, tool, tool number, avoidance, clamping type, tool length, feed, speed, lowest point, allowance, feed amount, and machining time. The tool path trajectory is the trajectory of the machining tool when machining the target model, and the tool path trajectory can be displayed in the form of a picture.

[0047] Step S3: Use Excel software to display the acquired shape construction information and processing program information in the form of a form. The form includes a program single page and a control button page. The program single page includes a header area, a picture display area and a processing information table. The header area contains information such as the programmer, network name, order time, drawing path, mold number, machine tool personnel and clamping. The picture display area is located below the header area and is used to display information such as the picture of the target model, material, number of pieces, actual size of the workpiece, single-piece program vertical time and remarks. The model picture is set in the picture display area. The processing information table is located below the picture display area, and multiple step-by-step processing formulas are arranged in the processing information table in sequence according to the preset processing order. In order to facilitate CNC processing staff to clearly see the target model, a picture can be added to the blank space below the processing information table. The picture contains the target model and coordinate system. The picture can be directly obtained from the PowerMill programming software.

[0048] The Control Buttons page has multiple form buttons, which are used to modify and update the relevant data on the program page. Specifically, the Control Buttons page has the following form buttons: Refresh Coordinates button, Show Image button, One-key Processing button, Refresh Lowest Point button, Output button, Refresh Time button, Add Tool Path button, Post-Processing / Annotation button, Interference Required button, Interference Tool Path button, Refresh All button, and Save and Print button.

[0049] Step S4: Acquire modification data from the program single page or the control button page.

[0050] Step S5: Automatically update the program single page according to the acquired modification data.

[0051] Step S6: Save and output the program sheet according to the program sheet page, outputting the program sheet includes converting the program sheet into a pdf format file and saving it to a designated shared folder, and / or printing the program sheet directly into a paper file, such as Figure 10 shown.

[0052] In the actual working process, after the Excel software generates a single page of program, the programming engineer needs to check whether the information in the single page of program is correct and whether it complies with the relevant standards of the industry. If it does not, the programming engineer can directly modify the corresponding position of the single page of program in the Excel software. For example, in the processing information table, the program name, processing purpose, tool, tool number, avoidance, clamping type, tool length, feed, speed, lowest point, margin, feed amount and processing time can all be manually modified. In order to keep the data of the Excel software and the PowerMill programming software synchronized, this embodiment can control the PowerMill programming software through the Excel software to perform relevant modification operations. Six typical examples will be selected below for illustration.

[0053] Example 1: Refresh the coordinate system:

[0054] Combine Figures 2 to 4 The target model is a plate-shaped workpiece. The target model is provided with multiple coordinate systems. The multiple 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 and the identity information correspond one to one. In this embodiment, the multiple coordinate systems are numbered with Arabic numerals. Each coordinate system has a unique identity number. The position information of the coordinate system in this embodiment is directly displayed in the model picture.

[0055] The Refresh Coordinates button is used to capture a model image containing the selected coordinate system in the PowerMill programming software and display it in the program single page of the Excel software.

[0056] When the Excel software obtains the shape and structure information of the target model, it can temporarily not obtain the position information and identity information of the coordinate system. That is, the model image displayed on the single page of the program temporarily does not include the model image with the coordinate system. At this time, you can perform the following steps to select the coordinate system.

[0057] Step S01, obtaining the selected coordinate system identity information in the control button page of the Excel software;

[0058] Step S02, obtaining a refresh coordinate instruction in the control button page of the Excel software;

[0059] In step S03, the Excel software controls the PowerMill programming software to automatically capture a model image of the target model including the selected coordinate system, and displays the model image on a single program page, where the selected coordinate system corresponds to the selected coordinate system identity information.

[0060] Specifically, the programming engineer enters the identity information of the selected coordinate system in the control button page, such as "1", and then clicks the Refresh Coordinates button. This automatically generates a model image showing the selected coordinate system in the blank space below the processing information table, or directly updates the model image in the image display area. In actual work, the coordinate system requires joint discussion and decision-making by multiple processing departments. Generally, once a coordinate system is selected, it is not modified. Therefore, in this example, when obtaining the shape structure information and processing program information of the target model with one click, the model image containing the coordinate system can be temporarily not obtained. When necessary, the identity information of the selected coordinate system can be manually entered, and then the model image containing the selected coordinate system can be separately captured, which helps save processing time for one-click processing.

[0061] The position of the selected coordinate system is directly displayed in the model image, and the identity information of the selected coordinate system is displayed on the control button page, which makes it easier for programming engineers to check whether the preset coordinate system is selected correctly.

[0062] Example 2: Display toolpath trajectory:

[0063] Combine Figure 3 and Figure 5 The Display Picture button is used to display the tool path of the selected step-by-step machining process in the control button page. The tool path of all step-by-step machining processes is obtained in advance from the PowerMill programming software, that is, the Excel software automatically captures the corresponding tool path in the target model and takes a screenshot, and then imports the picture into Excel, and displays the pictures one by one when needed.

[0064] Step S11, obtaining the selected step-by-step processing formula information in the processing information table;

[0065] Step S12, obtaining a display picture instruction in the control button page;

[0066] In step S13, the Excel software automatically displays the tool path trajectory of the selected step-by-step machining formula in the control button page, and the selected step-by-step machining formula corresponds to the selected step-by-step machining formula information.

[0067] Specifically, the programmer selects a step-by-step machining process in the machining information table and then clicks the Display Image button on the Control Buttons page. The toolpath for that step-by-step machining process will then be displayed on the Control Buttons page. Since the toolpaths for each step-by-step machining process are all captured during the one-click process, when the programmer needs to view the toolpath for a particular step-by-step machining process, they can quickly display an image of the toolpath, eliminating the need to retrieve each one individually, saving time.

[0068] Example 3: Outputting CNC machine tool processing programs:

[0069] Combine Figure 3 and Figure 6 The Post-Processing / Marking button is used to convert the tool path into a CNC machine program and output the CNC machine program to a preset folder. The CNC machine program is the program code required for the operation of the CNC machine tool. The program code has been written in the PowerMill programming software. Here, you only need to automatically capture the corresponding program code from the PowerMill programming software according to the program name of the step-by-step processing formula.

[0070] Step S21, obtaining the selected step-by-step processing formula information in the processing information table;

[0071] Step S22, obtain post-processing / marking instructions in the control button page;

[0072] In step S23, the Excel software controls the PowerMill programming software to convert the tool path trajectory of the selected step-by-step machining formula into a CNC machine program and output it to a preset folder. The selected step-by-step machining formula information corresponds to the selected step-by-step machining formula. Since the CNC machining program has been pre-written, during the conversion, the PowerMill programming software automatically outputs the corresponding CNC machine program based on the tool path trajectory.

[0073] Specifically, the programming engineer selects one of the step-by-step machining formulas or multiple step-by-step machining formulas at the same time in the machining information table, and then clicks the post-processing / annotation button in the control button page to automatically output the corresponding CNC machine tool machining program, i.e., the NC code, to the preset folder of the shared channel, making it convenient for CNC machining staff to access it. In order to make it easier for programming engineers to see at a glance which step-by-step machining formulas have already output NC code and which step-by-step machining formulas have not yet output NC code, it is preferred to set a "Post-processing" column in the machining information table (not shown in the figure); if the NC code has already been output, the "Post-processing" column displays "√"; otherwise, it displays "×". Since the "Post-processing" column is not related to CNC machining, it is not necessary to output or print this column when outputting or printing the program sheet.

[0074] Example 4: Refresh the lowest point:

[0075] Combine Figure 3 and Figure 7 The one-click processing button is used to obtain or update the shape structure information and machining program information of the target model in the PowerMill programming software. All the data in a single program page can be updated at once through the one-click processing button. Since there is always a lot of data in a single program page, it takes a long time to capture or update. The refresh lowest point button is used to modify the tool path trajectory corresponding to the lowest point data of the target model in the PowerMill programming software based on the lowest point data obtained in the Excel software, so that the data in the Excel software is synchronized with the data in the PowerMill programming software. Compared with the one-click processing button, it has the advantages of fast update speed and short update time.

[0076] Step S31, obtain the modified lowest point information in the processing information table, modify the lowest point information including the lowest point data and the selected step-by-step processing formula information;

[0077] Step S32, obtain the refresh lowest point instruction on the control button page;

[0078] In step S33, the Excel software controls the PowerMill programming software to modify the tool path trajectory and the lowest point data of the selected step-by-step machining formula according to the acquired modified lowest point information, wherein the selected step-by-step machining formula corresponds to the selected step-by-step machining formula information, and the selected step-by-step machining formula information corresponds to the selected step-by-step machining formula.

[0079] Specifically, when a programming engineer finds that the lowest point data of a certain step-by-step machining formula in the machining information table is unreasonable, he or she can manually modify the lowest point data in the machining information table, and then click the Refresh Lowest Point button. The Excel software controls the PowerMill programming software to modify the tool path trajectory and its lowest point data and CNC machine tool machining program corresponding to the step-by-step machining formula, so that the data in the Excel software is the same as the data in the PowerMill programming software, so that the PowerMill programming software converts and outputs an accurate CNC machine tool machining program.

[0080] Example 5: Add a new processing program:

[0081] Combine Figure 3 and Figure 8 The new tool path button is used to automatically update the relevant processing parameters of the newly added step-by-step processing program according to the program name of the newly added step-by-step processing program. The relevant processing parameters include processing purpose, tool, tool number, avoidance, clamping type, tool length, feed, speed, lowest point, allowance, feed amount and processing time.

[0082] Step S41, obtain the new program name in the processing information table;

[0083] Step S42, obtain the new tool path instruction on the control button page;

[0084] In step S43, the Excel software obtains the relevant processing parameters of the newly added step-by-step machining formula from the PowerMill programming software according to the newly added program name and displays them in the machining information table. The newly added step-by-step machining formula corresponds to the newly added program name.

[0085] Specifically, if the programming engineer finds that a step-by-step machining program is missing from the machining information table, he or she can add a new row to the corresponding position of the machining information table, fill in the name of the new step-by-step machining program in the first cell of the row, and then click the Add Tool Path button. The Excel software can automatically obtain the corresponding machining parameters in the PowerMill programming software based on the new program name and automatically display them in the machining information table.

[0086] Example 6: Modify the knife length data:

[0087] Combine Figure 3 and Figure 9 The Interference Tool Path button is used to update the tool length data in the step-by-step machining process. Generally speaking, the tool length is ≤5*tool diameter.

[0088] Step S51, obtain the modified clamping type information in the processing information, modify the clamping type information including the step-by-step processing formula identity information where it is located;

[0089] Step S52, obtain the interference tool path instruction on the control button page;

[0090] In step S53, the Excel software controls the PowerMill programming software to modify the clamping type corresponding to the step-by-step machining formula in the target model according to the acquired modified clamping type information, and automatically calculates and updates the modified tool length data corresponding to the modified clamping type, wherein the step-by-step machining formula corresponds to the step-by-step machining formula identity information.

[0091] Specifically, if the programming engineer finds that the tool length data in a certain step-by-step machining formula in the machining information table is greater than 5 times the tool diameter, then, while the tool remains unchanged, he can change the clamping device to another one in the clamping type, and then click the interference tool path button. The Excel software controls the PowerMill programming software to modify the clamping type in the corresponding step-by-step machining formula, and automatically calculates and updates the tool length data, so that the data of the PowerMill programming software is synchronized with the data of the Excel software. In order to facilitate the observation of whether the tool length data is recalculated, it is preferred to set an "Interfered" column in the machining information table (not shown in the figure). After changing the clamping device, the "Interfered" column of the machining information table displays "×". When the tool length data is recalculated and updated, the "Interfered" column displays "√". Since the "Interfered" column is not related to CNC machining, it is not necessary to output or print this column when outputting or printing the program sheet.

[0092] In summary, it can be seen that the present invention connects the Excel software with the PowerMill programming software data, which is beneficial for users to perform relevant operations in the Excel software to automatically obtain the shape structure information and processing program information of the target model pre-set in the PowerMill programming software, and automatically generate the program sheet required by the CNC machining staff; when it is necessary to modify certain data in the program sheet according to the actual machining situation, since the Excel software is connected with the PowerMill programming software data, the programming engineer can directly modify the data in the Excel software, and control the relevant data in the PowerMill programming software to keep synchronized with the Excel software. Compared with the prior art of modifying data in the PowerMill programming software and regenerating the program sheet, the present invention is beneficial to saving the time consumed in regenerating the program sheet, and has the advantages of saving time and improving work efficiency.

[0093] Finally, it should be emphasized that the above are only preferred embodiments of the present invention and are not intended to limit the present invention. For those skilled in the art, the present invention may have various changes and modifications. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for automatically generating a CNC machining program sheet using Excel software, comprising Excel software and PowerMill programming software, characterized in that: The following steps are also included: Establishing a data connection relationship between the Excel software and the PowerMill programming software and obtaining shape construction information and machining program information of the target model in the PowerMill programming software, wherein the shape construction information includes a model image and the machining program information includes a plurality of step-by-step machining formulas; The obtained shape structure information and the processing program information are displayed in the form of a form using the Excel software. The form includes a program single page and a control button page. The program single page includes a picture display area and a processing information table. The model picture is set in the picture display area. The multiple step-by-step processing formulas are arranged in sequence in the processing information table according to a preset processing order. The control button page is provided with multiple form buttons. The form buttons are used to modify and update relevant data on the program single page. The form buttons include a display picture button. The display picture button is used to display the tool path trajectory of the selected step-by-step processing formula in the control button page. The tool path trajectory of all the step-by-step processing formulas is obtained in advance from the PowerMill programming software. After obtaining the selected step-by-step processing formula information in the processing information table and obtaining the display picture instruction in the control button page, the Excel software automatically displays the tool path trajectory of the selected step-by-step processing formula in the control button page. The selected step-by-step processing formula corresponds to the selected step-by-step processing formula information. Acquire modification data through the Excel software, wherein the modification data is acquired from the processing information table and the form button; The Excel software automatically updates the program sheet page according to the acquired modification data, and outputs the program sheet according to the program sheet page.

2. The method according to claim 1, wherein: The step-by-step machining program includes program name, machining purpose, tool, tool number, clearance, clamping type, tool length, feed, speed, lowest point, allowance, feed amount and machining time; In the processing information table, the program name, the processing purpose, the tool, the tool number, the avoidance, the clamping type, the tool length, the feed, the speed, the lowest point, the allowance, the feed amount and the processing time can all be manually modified.

3. The method according to claim 1, wherein: The control button page is provided with the following form buttons: refresh coordinate button, one-key processing button, refresh lowest point button, output button, refresh time button, add tool path button, post-processing / marking button, interference required button, interference tool path button, refresh all button and save and print button.

4. The method according to claim 3, wherein: The target model is provided with a plurality of coordinate systems, each of the coordinate systems having unique identity information and unique position information, and the position information and the identity information are in one-to-one correspondence; The refresh coordinate button is used to capture a model image containing the selected coordinate system in the PowerMill programming software according to the selected coordinate system and display it in the program single page of the Excel software; After obtaining the selected coordinate system identity information and the refresh coordinate instruction in the control button page, the Excel software controls the PowerMill programming software to automatically capture the model image of the target model containing the selected coordinate system and display it in the program single page of the Excel software, and the selected coordinate system corresponds to the selected coordinate system identity information.

5. The method according to claim 3, wherein: The post-processing / marking button is used to convert the tool path trajectory into a CNC machine tool processing program and output the CNC machine tool processing program to a preset folder; After obtaining the selected step-by-step machining formula information in the machining information table and obtaining the post-processing / marking instructions in the control button page, the Excel software controls the PowerMill programming software to convert the tool path trajectory of the selected step-by-step machining formula into a CNC machine tool machining program and outputs it to the preset folder, and the selected step-by-step machining formula information corresponds to the selected step-by-step machining formula.

6. The method according to claim 3, wherein: The one-key processing button is used to obtain the shape structure information and machining program information of the target model in the PowerMill programming software; The refresh lowest point button is used to modify the tool path trajectory of the target model corresponding to the lowest point data in the PowerMill programming software according to the lowest point data obtained in the Excel software; The modified lowest point information is obtained in the processing information table, the modified lowest point information including the lowest point data and the selected step-by-step machining formula information. After obtaining the refresh lowest point instruction on the control button page, the Excel software controls the PowerMill programming software to modify the tool path trajectory and the lowest point data of the selected step-by-step machining formula according to the modified lowest point information, wherein the selected step-by-step machining formula corresponds to the selected step-by-step machining formula information.

7. The method according to claim 3, wherein: The new tool path button is used to automatically update the relevant processing parameters of the newly added step-by-step machining program according to the program name of the newly added step-by-step machining program; After obtaining the newly added program name in the processing information table and obtaining the newly added tool path instruction on the control button page, the Excel software obtains the relevant processing parameters of the newly added step-by-step processing formula from the PowerMill programming software according to the newly added program name and displays them in the processing information table. The newly added step-by-step processing formula corresponds to the newly added program name, and the relevant processing parameters include processing purpose, tool, tool number, avoidance, clamping type, tool length, feed, speed, lowest point, allowance, feed amount and processing time.

8. The method according to claim 3, wherein: The interference tool path button is used to update the tool length data in the step-by-step machining process; The modified clamping type information is obtained in the processing information table, and the modified clamping type information includes the identity information of the step-by-step machining formula to which it belongs. After obtaining the interference tool path instruction on the control button page, the Excel software controls the PowerMill programming software to modify the clamping type of the target model corresponding to the step-by-step machining formula according to the modified clamping type information, and automatically calculates and updates the modified tool length data corresponding to the modified clamping type, wherein the step-by-step machining formula corresponds to the step-by-step machining formula identity information.

Images