Hello Team,
I want to export data into csv file.
Everything works fine, but I have items separated by comma in csv file - Here, I would like to have the output as mentioned below-
Actual Data
"Country full name","Super-region name","Region name"
"Afghanistan","Asia","Southern Asia"
"Albania","Europe","Southern Europe"
Desired Output:
"Country full name";"Super-region name";"Region name"
"Afghanistan";"Asia";"Southern Asia"
"Albania";"Europe";"Southern Europe"
Code:
final ListGrid grid = (ListGrid) getMember(1);
DSRequest requestProperties = new DSRequest();
requestProperties.setExportAs(ExportFormat.CSV);
requestProperties.setOperationId(gridConfiguration.getFetchOperation());
requestProperties.setExportFilename(getGridHeader().getGridName().getContents());
String exportFooter = createExportFooter();
requestProperties.setExportFooter(exportFooter);
grid.exportData(requestProperties);
I tried to find any doc/API about it but no success.
We are using SmartClient version : v9.0p_2013-09-22/PowerEdition Deployment (built 2013-09-22)
Please help me to achieve this.
I want to export data into csv file.
Everything works fine, but I have items separated by comma in csv file - Here, I would like to have the output as mentioned below-
Actual Data
"Country full name","Super-region name","Region name"
"Afghanistan","Asia","Southern Asia"
"Albania","Europe","Southern Europe"
Desired Output:
"Country full name";"Super-region name";"Region name"
"Afghanistan";"Asia";"Southern Asia"
"Albania";"Europe";"Southern Europe"
Code:
final ListGrid grid = (ListGrid) getMember(1);
DSRequest requestProperties = new DSRequest();
requestProperties.setExportAs(ExportFormat.CSV);
requestProperties.setOperationId(gridConfiguration.getFetchOperation());
requestProperties.setExportFilename(getGridHeader().getGridName().getContents());
String exportFooter = createExportFooter();
requestProperties.setExportFooter(exportFooter);
grid.exportData(requestProperties);
I tried to find any doc/API about it but no success.
We are using SmartClient version : v9.0p_2013-09-22/PowerEdition Deployment (built 2013-09-22)
Please help me to achieve this.
Comment