Hello,
where is possible to find the official reference (manual page) of Partlist.Export Options for Excel format?
PartsList.Export( FileName As String, FileFormat As PartsListFileFormatEnum, [Options] As Variant )
On the manual page of Export Method is note: See Remarks for valid inputs. But the Remarks are empty.
Thank you.
Solved! Go to Solution.
Solved by MjDeck. Go to Solution.
I found only this...
' create a new NameValueMap object oOptions = ThisApplication.TransientObjects.CreateNameValueMap 'specify an existing template file 'to use For formatting colors, fonts, etc oOptions.Value("Template") = "C:\Temp\PartListExport.xls" 'specify the columns to export oOptions.Value("ExportedColumns") = "QTY;PART NUMBER;DESCRIPTION" 'specify the start cell oOptions.Value("StartingCell") = "A3" 'specify the XLS tab name 'here the file name is used oOptions.Value("TableName") = ThisDoc.FileName(False) 'without extension 'choose to include the parts list title row oOptions.Value("IncludeTitle") = True 'choose to autofit the column width in the xls file oOptions.Value("AutoFitColumnWidth") = True ' export the Partslist to Excel with options oPartslist.Export(path_and_name & ".xls", _ PartsListFileFormatEnum.kMicrosoftExcel, oOptions)
Source: http://inventortrenches.blogspot.com/2011/06/ilogic-export-parts-list-with-options.html
Hi @j.pavlicek
That's a good question... I'm not even sure where I found that information back in 2011 when I wrote that blog post...
The Options correlate to what you see when you manually export a Parts List as shown here in this image.
It's likely I found an example in the Inventor Customization forum, which is the better search and ask programming questions of this type:
http://forums.autodesk.com/t5/Autodesk-Inventor-Customization/bd-p/120
I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com
Hello,
thanks for you response. Your great blogpost provides enough information for my purpose.
I'm only curious if there is some official hidden page with information of this kind.
You are right, Inventor Customization forum is definetly better place for this quiestion.
@j.pavlicek , there's a lot of extra blank space on the manual page of Export Method
But if you scroll all the way down to the bottom, you will see the options.
Sneaky! Thank you very much.
Can't find what you're looking for? Ask the community or share your knowledge.