convert the internal table into XML format, then using cl_document_bcs =>xstring_to_solix convert into excel file.using ALV OO with method cl_salv_column_table~set_leading_zero to set column which needs.
Recently, I get the requirement is to keep the leading zero for an order number, I thought it’ll be quite straight forward then it cost me several hours to achieve that~ There’re many documents that describe how to achieve that.
It’s a very common requirement to remove the leading zero at ALV list output or send out an excel file as an email attachment.
