Save internal table on application server in .xlsx format

[sridhar_meesala]

Hello All,

We have a requirement to save the data in an internal table on to the application server in .xlsx format.

Can someone please let me know if this is possible. And I do not want to save it as microsoft xml format (.xml extension).

On searching for this requirement we found abap2xlsx SAPLink. But is there any standard method provided by SAP to download data in .xlsx format on application server. And can we download .xlsx to application server directly using abap2xlsx.

Thank you,

Sri.

[arindam_m]

Hi,

You should try OPEN and CLOSE dataset option and if you want OPEN CLOSE encapsulated in fancy Class try CL_RSAN_UT_APPSERV_FILE_WRITER. Does the same thing only you don't have bother on OPEN.. CLOSE DATASET handling.

Cheers,

Arindam

[sridhar_meesala]

ABAP2XLSX project solved the problem. It is very useful.