Error in creating excel using XML

[former_member574546]

I have created an excel and attached in mail using XML.In attachment while opening it shows some table error but if I send only the header part without passing any data the excel file got opened. Pls help me with proper coding in xml to pass data to excel .

[Sandra_Rossi]

Most experienced people have abandoned this way of creating Excel files (XMLSS 2003) because of so many bugs during development, so it's a waste of time. You should better try ABAP2XLSX, and ask precise questions if you have issues.

[former_member574546]

In this part only I am having doubt pls check it and help me.This part pass the data to xml I want to know this is correct or not.

Employee code
gref_cell = gref_document->create_simple_element( name = 'Cell' parent = gref_row ).
gref_cell->set_attribute_ns( name = 'StyleID' prefix = 'ss' value = 'data' ).
gv_value = empno.("parameter value)
gref_data = gref_document->create_simple_element( name = 'Data' value = gv_value parent = gref_cell ).

gref_data->set_attribute_ns( name = 'Type' prefix = 'ss' value = 'String' ).