Excel export to be formatted after exporting in SAP Design Studio 1,6

[former_member334960]

Hi All,

I have export to Excel in my report, when I export the crosstab, it looks like a plain excel with data like below:

capture.png.

Can you please let me know how i can export to excel with proper borders and headers formatted etc.

Thanks

Poojitha

[sinaei]

Hi,

You have export your crosstab to excel via script right? Applixation.Export....?

I did not understand excatly what do you mean by exporting to excel with proper borders and heraders...
You want an screenshot form your crosstabs?
Could you explian more?

Thanks
Sepide

[former_member334960]

Hi,

Yes, I have exported my application using script.APPLICATION.export(ExportType.EXCEL_xlsx);

But, the excel just shows the data without any formatting. I would like to have the data in excel to be slightly formatted with good borders and headers.

Is there any template that has to be placed on the server?

Can you please let me know how this can be achieved.

Thanks.

[sinaei]

Hi,

Sorry, but I have no idea how you can modify the template of excel in Design studio. I am not sure if it is feasible.
Please let us know if you find any solution.