CustomTable Export to Excel from a C++-App

[RichardErnstberger]

Hi all,

I'm trying to figure out how to prepare the options for the CustomTable.Export() method.

The SDK-Doc is somewhat confusing here:

CustomTable.Export Method Valid values for the Options parameter: Name Value Type Valid for export formats ------------------- ----------- -------------------------------- TableName String kMicrosoftExcel, kMicrosoftAccess ExportedColumns String All containing semicolon separated column titles IncludeTitle Boolean kMicrosoftExcel, kTextFileCommaDelimited, kTextFileTabDelimited, kUnicodeTextFileCommaDelimited, kUnicodeTextFileTabDelimited StartingCell String kMicrosoftExcel Template String kMicrosoftExcel AutoFitColumnWidth Boolean kMicrosoftExcel

Is there any sample on the export method or maybe a more informative description of the options and their structure.

To create a options object i have found the sample on 3DPDF-Export:

CComPtr oOptions = NULL;
pApp->TransientObjects->CreateNameValueMap(&oOptions);
// oOptions->put_Value(CComBSTR("FileOutputLocation"), CComVariant(filename));

At this point i have to deal with the right options and data types.

My main subject is to export a CustomTable to a customer defined Excel template.

I'm looking forward to any suggestion or tips about this.

Thanks in advance.

Kind regards,

Richard

[chandra.shekar.g · Accepted solution]

@RichardErnstberger,

Valid values for the Options parameter is documented in below link.

http://help.autodesk.com/view/INVNTOR/2019/ENU/?guid=GUID-8A886ACB-7251-4ECD-B550-EF38C2E27E48

Which looks like below table.

Name	Value type	Valid for Export formats
TableName	String	kMicrosoftExcel,kMicrosoftAccess
ExportedColumns	String	All containing semicolon separated column titles IncludeTitle Boolean kMicrosoftExcel, kTextFileCommaDelimited, kTextFileTabDelimited, kUnicodeTextFileCommaDelimited, kUnicodeTextFileTabDelimited
StartingCell	String	kMicrosoftExcel
Template	String	kMicrosoftExcel
AutoFitColumnWidth	String	kMicrosoftExcel

Thanks and regards,

[RichardErnstberger]

Many thanks Chandra Shekar,

this is much more informative now.

Hopefully the programming help page get's updated this way...

Kind regards,

Richard

[chandra.shekar.g]

@RichardErnstberger,

You are welcome!!!

Thanks and regards,