export parameter in inventor to excel

export parameter in inventor to excel

Anonymous
Not applicable
4,009 Views
3 Replies
Message 1 of 4

export parameter in inventor to excel

Anonymous
Not applicable

Trying to export parameter list to excel with no links, just as a one time action.  Is there a way to do this?

 

Thanks,

Kim

0 Likes
4,010 Views
3 Replies
Replies (3)
Message 2 of 4

tdant
Collaborator
Collaborator

 Click the "Manage" drop down under the Parameters button and select "Export to XML".

Capture.PNG

Then you can use a converter to make it an Excel file.

 

EDIT: Actually, Excel can import XMLs natively via the Developer tab, so you don't need a convertor.

0 Likes
Message 3 of 4

JBerns
Advisor
Advisor

Due to errors in the XML file because of (Inventor?) formatting errors, I could not open the XML file with Excel. A serious error occurred and crashed Excel.

 

However, I was able to use this site https://json-csv.com/xml to convert the XML to CSV.

 

Next, I could open the CSV to discover parameter names, types, and values, including multi-value lists.

 

Hope this is helpful to others.

 

 

Regards,

Jerry

 

 

-----------------------------------------------------------------------------------------
CAD Administrator
Using AutoCAD & Inventor 2025
Autodesk Certified Instructor
Autodesk Inventor 2020 Certified Professional
Autodesk AutoCAD 2017 Certified Professional
Message 4 of 4

Anonymous
Not applicable

I'm not sure how many parameters you have, but you could write them out using the standard Excel Snippets that come with Inventor

@ClintBrown3D Autodesk Inventor 473.png

c1  = GoExcel.CellValue("filename.xls", "Sheet1", "A2")
c2 = GoExcel.CellValue("filename.xls", "Sheet1", "A3")
0 Likes