I'm sending an Excel(.XLS) file as an attachment to an E-Mail from SAP by using the CL_BCS class.
The problem with the attached Excel file is that it has a column which consists of MATERIAL number.
I've material numbers like "575121.010".
These are being displayed as "575121.01" with the trailing zeros being truncated in the excel file.
When I open the Excel file from the E-Mail, the Material Number is Not being formatted as a text.
Instead all the columns are being formatted as 'General'.
Is there a way in SAP which allows me to format the Excel column properties as TEXT while creating the File.
I'm creating the EXCEL document in SAP by using the process below.
I'm creating the document by using the cl_document_bcs=>create_document( ) with type as "RAW".
After that I'm attaching the document to the mail and sending the document as an attachment with the mail.
Please help me with this one.
Narayana Reddy A V L.