topic Re: export tool data to excel table in PowerMill Forum

export tool data to excel table

roberto_perez — Fri, 02 Dec 2022 06:33:26 GMT

good morning
I have a macro that is used to import into powermill a list of tools that has previously been filled in in an excel table. This table is made up of all the data that the tool needs to have the different components, reference, family, tip data, shank and even cutting conditions.

If someone had the same thing but in reverse, I would need a macro to export all the data that makes up this tool to Excel. please look at the table to understand.
attached example table and macro

Thank you

Re: export tool data to excel table

kevin.hammond3WX4X — Fri, 02 Dec 2022 08:36:10 GMT

Hi, i don't have the time to give you all that you are asking for, but see the attached file, this will get you started.

Hope this helps.

Please share your final macro, as it may be of use to others.

Regards Kevin

Re: export tool data to excel table

roberto_perez — Fri, 02 Dec 2022 14:05:38 GMT

hello. unfortunately I have no programming knowledge, I would gladly share it with all members, but I don't know how to do it

Thank you

Re: export tool data to excel table

Michaelangelo631 — Fri, 02 Dec 2022 18:50:30 GMT

@Anonymousposted about a macro that will export all your tool info as a text file. If you import this into excel with some formatting you can get close to what you are looking for. This is not a full solution but a partial step in the right direction.

https://forums.autodesk.com/t5/powermill-forum/export-tool-database-in-csv/td-p/9289962

Regards,

Mike

Re: export tool data to excel table

roberto_perez — Mon, 05 Dec 2022 06:13:35 GMT

@Michaelangelo631

Thanks, I was looking at it but it doesn't get all the component fields