iLogic PartsList.Export Method Options reference

[j.pavlicek]

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.

[j.pavlicek]

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

[Curtis_Waguespack]

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

[j.pavlicek]

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.

[MjDeck · Accepted solution]

@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.

[j.pavlicek]

Sneaky! Thank you very much.