Page 1 of 1

csv export

Posted: Wed Feb 27, 2013 12:31 am
by Chipo
G'day,

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

Best regards.

Re: csv export

Posted: Wed Feb 27, 2013 1:33 pm
by 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.

Re: csv export

Posted: Thu Feb 28, 2013 2:05 am
by Chipo
Thank you. Works like magic.

Re: csv export

Posted: Thu Feb 28, 2013 1:17 pm
by Vladimir
Hello,

We always glad to help you!

Thank you.

Re: csv export

Posted: Fri Jun 26, 2015 10:15 am
by S.B.
Hi!
Tell me please, how could I set StiCsvExportSettings (for example SkipColumnHeaders = true) in a Designer (in mrt file)?

Re: csv export

Posted: Mon Jun 29, 2015 7:48 am
by 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.

Re: csv export

Posted: Wed Jul 01, 2015 6:56 am
by S.B.
Thank you!

Re: csv export

Posted: Wed Jul 01, 2015 7:59 am
by HighAley
Hello.

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

Thank you.