BOM export with template

[Anonymous]

I use this (similar) when I export my BOM list.
I want to export the BOM list "structured" with "All Levels".
How do I do this and use a template?
I like to use the iLogic.
Is it possible to "Expand All Children" in the parts list of DWG with a command from the iLogic.
If I export it from. iam then I can not use my own made template.

'-------------Start of ilogic ------------------------------------------------

'get the path and name of the drawing file

path_and_name = ThisDoc.PathAndFileName(False) ' without extension

'define oDoc

oDoc = ThisDoc.Document

'specify the drawing sheet

oSheet = oDoc.Sheets("Sheet:1") ' sheet by name

'oSheet = oDoc.Sheets(1) ' first sheet

 ' say there is a Partslist on the sheet.

oPartslist = oSheet.PartsLists(1)

' 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

'in this example "Ye Old List of Parts" is written to the StartingCell

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)  

'-------------End of ilogic ------------------------------------------------