topic Re: Save internal table on application server in .xlsx format in Application Development and Automation Discussions

Save internal table on application server in .xlsx format

sridhar_meesala — Wed, 05 Jun 2013 17:17:52 GMT

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.

Re: Save internal table on application server in .xlsx format

arindam_m — Thu, 06 Jun 2013 02:03:09 GMT

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

Re: Save internal table on application server in .xlsx format

sridhar_meesala — Thu, 18 Jul 2013 14:46:29 GMT

ABAP2XLSX project solved the problem. It is very useful.