csv export

[Chipo]

G'day,

How can I set default separator and "Skip Column Headers" option during runtime for "Export To CSV" feature?

Best regards.

[Vladimir]

Hello,

You can use this code:

Code: Select all

viewer.addEventListener(StiViewerEvent.START_EXPORT, onStartExport);
...

private function onStartExport(event: StiViewerEvent): void
{
    if (event.exportSettings.exportFormat == StiExportFormat.Csv)
    {
        StiCsvExportSettings(event.exportSettings).separator = ",";
        StiCsvExportSettings(event.exportSettings).skipColumnHeaders = true;
    }
}

Thank you.

[Chipo]

Thank you. Works like magic.

[Vladimir]

Hello,

We always glad to help you!

Thank you.

[S.B.]

Hi!
Tell me please, how could I set StiCsvExportSettings (for example SkipColumnHeaders = true) in a Designer (in mrt file)?

[Vladimir]

Hello,

You can use this code:

Code: Select all

designer.previewControl.addEventListener(StiViewerEvent.START_EXPORT, onStartExport);
...

private function onStartExport(event: StiViewerEvent): void
{
    if (event.exportSettings.exportFormat == StiExportFormat.Csv)
    {
        StiCsvExportSettings(event.exportSettings).skipColumnHeaders = true;
    }
}

This should work for the preview of the report in the report designer.

Thank you.

[S.B.]

Thank you!

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.