topic Re: file is corrupted error while creating excel using xml in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487167#M1850774 <HTML><HEAD></HEAD><BODY><P><STRONG style="color: #ff0000;">Moderator message</STRONG></P><P></P><P><SPAN style="color: #333333; font-size: 12px;"><EM> please review and tell what is wrong in it ASAP :</EM></SPAN></P><P><SPAN style="color: #333333; font-size: 12px;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #333333; font-size: 12px;">Please note - the use of "ASAP" and "urgent" and similar words is not permitted and can result in your post being rejected - which if you're in a hurry presumably isn't what you want. Everyone wants an answer ASAP. Everyone's needs are urgent.</SPAN></P><P><SPAN style="color: #333333; font-size: 12px;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #333333; font-size: 12px;">Please do not do this again.<EM><BR /></EM></SPAN></P></BODY></HTML> Fri, 08 Aug 2014 08:30:20 GMT matt 2014-08-08T08:30:20Z file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487161#M1850768 <HTML><HEAD></HEAD><BODY><P>&nbsp; Hi have created one excel file using XML code and sent it to mail as attachement. But when i open it, it displays error&nbsp; message - file is corrupted and cannot be opened.</P><P>below is my code - please review and tell what is wrong in it ASAP :</P><P></P><P></P><P> <SPAN class="L0S31">* Creating a ixml Factory</SPAN></P><P>&nbsp;&nbsp; l_ixml <SPAN class="L0S55">= </SPAN>cl_ixml<SPAN class="L0S70">=&gt;</SPAN><SPAN class="L0S52">create</SPAN><SPAN class="L0S55">( </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Creating the DOM Object Model</SPAN></P><P>&nbsp;&nbsp; l_document <SPAN class="L0S55">= </SPAN>l_ixml<SPAN class="L0S70">-&gt;</SPAN>create_document<SPAN class="L0S55">( </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Create Root Node 'Workbook'</SPAN></P><P>&nbsp;&nbsp; l_element_root&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Workbook'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>l_document <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; l_element_root<SPAN class="L0S70">-&gt;</SPAN>set_attribute<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'xmlns'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'urn:schemas-microsoft-com:office:spreadsheet' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; ns_attribute <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_namespace_decl<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'xmlns'&nbsp; </SPAN>uri <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'urn:schemas-microsoft-com:office:spreadsheet' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; l_element_root<SPAN class="L0S70">-&gt;</SPAN>set_attribute_node<SPAN class="L0S55">( </SPAN>ns_attribute <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; ns_attribute <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_namespace_decl<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'x'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'xmlns'&nbsp; </SPAN>uri <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'urn:schemas-microsoft-com:office:excel' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; l_element_root<SPAN class="L0S70">-&gt;</SPAN>set_attribute_node<SPAN class="L0S55">( </SPAN>ns_attribute <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Create node for document properties.</SPAN></P><P>&nbsp;&nbsp; r_element_properties <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'TEST_REPORT'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>l_element_root <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>sy<SPAN class="L0S70">-</SPAN>uname<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Author'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp; parent <SPAN class="L0S55">= </SPAN>r_element_properties&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Styles</SPAN></P><P>&nbsp;&nbsp; r_styles <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Styles'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>l_element_root&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Style for Header</SPAN></P><P>&nbsp;&nbsp; r_style&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Style'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_styles&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_style<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Font'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_style&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Bold'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Interior' </SPAN>parent <SPAN class="L0S55">= </SPAN>r_style&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Color'&nbsp;&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'#92D050' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Pattern' </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Solid' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Alignment'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_style&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Vertical'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Center' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'WrapText'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_border&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Borders'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_style <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Border'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_border&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Position'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Bottom' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'LineStyle'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Continuous' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Weight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Border'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_border&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Position'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Left' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'LineStyle'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Continuous' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Weight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Border'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_border&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Position'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Top' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'LineStyle'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Continuous' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Weight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Border'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_border&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Position'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Right' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'LineStyle'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Continuous' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Weight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Style for Data</SPAN></P><P>&nbsp;&nbsp; r_style1&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Style'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_styles&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_style1<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_border&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Borders'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_style1 <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Border'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_border&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Position'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Bottom' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'LineStyle'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Continuous' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Weight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Border'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_border&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Position'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Left' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'LineStyle'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Continuous' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Weight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Border'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_border&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Position'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Top' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'LineStyle'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Continuous' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Weight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_format&nbsp; <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Border'&nbsp;&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_border&nbsp; <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Position'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Right' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'LineStyle'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Continuous' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_format<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Weight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P></P><P> <SPAN class="L0S31">* Worksheet</SPAN></P><P>&nbsp;&nbsp; r_worksheet <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Worksheet'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>l_element_root <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_worksheet<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Name'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Sheet1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">*&nbsp; r_worksheet-&gt;set_attribute_ns( name = 'Protected'&nbsp; prefix = 'ss'&nbsp; value = '1' ).&nbsp;&nbsp;&nbsp; " WORKING</SPAN></P><P></P><P> <SPAN class="L0S31">* Table</SPAN></P><P>&nbsp;&nbsp; r_table <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Table'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_worksheet <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_table<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'FullColumns'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'x'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_table<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'FullRows'&nbsp;&nbsp;&nbsp;&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'x'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Column Formatting</SPAN></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'40' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'90' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'140' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'150' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'90' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'90' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'90' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'90' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_column <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Column'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_column<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Width'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'90' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Blank Row</SPAN></P><P>&nbsp;&nbsp; r_row <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Row'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Column Headers Row</SPAN></P><P>&nbsp;&nbsp; r_row <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Row'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_row<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'AutoFitHeight'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* RFQ No.</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'RFQ No.'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P></P><P> <SPAN class="L0S31">* RFQ Line Item No</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'RFQ Line Item No.'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Material</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Material'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Quantity</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Quantity'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">*&nbsp; Order UNIT</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Order Unit'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">*&nbsp; Delivery Date</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Delivery Date'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">*&nbsp; RFQ Creation Date</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'RFQ Creation Date'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">*&nbsp; RFQ Deadline Date</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'RFQ Deadline Date'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Price</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Header' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Net Price'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss' </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">** Login</SPAN></P><P> <SPAN class="L0S31">*&nbsp; r_cell = l_document-&gt;create_simple_element( name = 'Cell'&nbsp; parent = r_row ).</SPAN></P><P> <SPAN class="L0S31">*&nbsp; r_cell-&gt;set_attribute_ns( name = 'StyleID'&nbsp; prefix = 'ss'&nbsp; value = 'Header' ).</SPAN></P><P> <SPAN class="L0S31">*&nbsp; CONCATENATE 'Login - ' lv_date+6(2) '/' lv_date+4(2) '/' lv_date+0(4) INTO l_value.</SPAN></P><P> <SPAN class="L0S31">*&nbsp; r_data = l_document-&gt;create_simple_element( name = 'Data'&nbsp; value = l_value&nbsp; parent = r_cell ).</SPAN></P><P> <SPAN class="L0S31">*&nbsp; r_data-&gt;set_attribute_ns( name = 'Type'&nbsp; prefix = 'ss' value = 'String' ).</SPAN></P><P></P><P> <SPAN class="L0S31">* Blank Row after Column Headers</SPAN></P><P>&nbsp;&nbsp; r_row <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Row'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Data Table</SPAN></P><P>&nbsp;&nbsp; <SPAN class="L0S52">LOOP </SPAN><SPAN class="L0S52">AT </SPAN>it_final1 <SPAN class="L0S52">INTO </SPAN>wa_final1<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_row <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Row'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* RFQ No.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>wa_final1<SPAN class="L0S70">-</SPAN>ebeln <SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*&nbsp;&nbsp;&nbsp; CONDENSE l_value NO-GAPS.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp; parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Data</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Cell format</SPAN></P><P></P><P> <SPAN class="L0S31">* Line Item No</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>wa_final1<SPAN class="L0S70">-</SPAN>ebelp<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp;&nbsp; parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Data</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Number' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Cell format</SPAN></P><P></P><P> <SPAN class="L0S31">* Material</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>wa_final1<SPAN class="L0S70">-</SPAN>txz01<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp;&nbsp; parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Data</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Cell format</SPAN></P><P></P><P> <SPAN class="L0S31">* RFQ QTY</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>wa_final1<SPAN class="L0S70">-</SPAN>ktmng<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp;&nbsp; parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Data</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Number' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Cell format</SPAN></P><P></P><P> <SPAN class="L0S31">* UNIT</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>wa_final1<SPAN class="L0S70">-</SPAN>meins<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp;&nbsp; parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Data</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Cell format</SPAN></P><P></P><P> <SPAN class="L0S31">* DElivery Date</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>wa_final1<SPAN class="L0S70">-</SPAN>eindt<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp;&nbsp; parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Data</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Cell format</SPAN></P><P></P><P> <SPAN class="L0S31">* RFQ Date</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>wa_final1<SPAN class="L0S70">-</SPAN>aedat<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp;&nbsp; parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Data</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Cell format</SPAN></P><P></P><P> <SPAN class="L0S31">* RFQ Deadline</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; l_value <SPAN class="L0S55">= </SPAN>wa_final1<SPAN class="L0S70">-</SPAN>agdat<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_value&nbsp;&nbsp; parent <SPAN class="L0S55">= </SPAN>r_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Data</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'String' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="L0S31">" Cell format</SPAN></P><P></P><P> <SPAN class="L0S31">* price</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">CLEAR </SPAN>l_value<SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell <SPAN class="L0S55">= </SPAN>l_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Cell'&nbsp; </SPAN>parent <SPAN class="L0S55">= </SPAN>r_row <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; r_cell<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'StyleID'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P> <SPAN class="L0S31">*&nbsp;&nbsp;&nbsp; r_data = l_document-&gt;create_simple_element( name = 'Data'&nbsp; value = l_value&nbsp;&nbsp; parent = r_cell ).&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; " Data</SPAN></P><P> <SPAN class="L0S31">*&nbsp;&nbsp;&nbsp; r_data-&gt;set_attribute_ns( name = 'Type'&nbsp; prefix = 'ss'&nbsp; value = 'String' ).&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; " Cell format</SPAN></P><P></P><P>&nbsp;&nbsp; <SPAN class="L0S52">ENDLOOP</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Creating a Stream Factory</SPAN></P><P>&nbsp;&nbsp; l_streamfactory <SPAN class="L0S55">= </SPAN>l_ixml<SPAN class="L0S70">-&gt;</SPAN>create_stream_factory<SPAN class="L0S55">( </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Connect Internal XML Table to Stream Factory</SPAN></P><P>&nbsp;&nbsp; l_ostream <SPAN class="L0S55">= </SPAN>l_streamfactory<SPAN class="L0S70">-&gt;</SPAN>create_ostream_itable<SPAN class="L0S55">( </SPAN><SPAN class="L0S52">table </SPAN><SPAN class="L0S55">= </SPAN>l_xml_table <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Rendering the Document</SPAN></P><P>&nbsp;&nbsp; l_renderer <SPAN class="L0S55">= </SPAN>l_ixml<SPAN class="L0S70">-&gt;</SPAN>create_renderer<SPAN class="L0S55">( </SPAN>ostream&nbsp; <SPAN class="L0S55">= </SPAN>l_ostream&nbsp; document <SPAN class="L0S55">= </SPAN>l_document <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P>&nbsp;&nbsp; l_rc <SPAN class="L0S55">= </SPAN>l_renderer<SPAN class="L0S70">-&gt;</SPAN>render<SPAN class="L0S55">( </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P> <SPAN class="L0S31">* Saving the XML Document</SPAN></P><P>&nbsp;&nbsp; l_xml_size <SPAN class="L0S55">= </SPAN>l_ostream<SPAN class="L0S70">-&gt;</SPAN>get_num_written_raw<SPAN class="L0S55">( </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P></BODY></HTML> Fri, 08 Aug 2014 05:19:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487161#M1850768 Former Member 2014-08-08T05:19:33Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487162#M1850769 <HTML><HEAD></HEAD><BODY><P>Hi Seema,</P><P></P><P>Try to debug that code.</P><P></P><P>follow these steps.</P><P>click on variable lv_buffer.</P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/516092" width="450" /></P><P>&nbsp;&nbsp; Choose 'XML browser' .</P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/516093" width="450" /></P><P>Check that xml code and it will be easy to find the error.</P><P></P><P>If you find any difficulty send the screen shot of XML code from XML browser.</P><P></P><P></P><P>thanks,</P><P></P><P>vidyasagar</P></BODY></HTML> Fri, 08 Aug 2014 05:37:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487162#M1850769 former_member212124 2014-08-08T05:37:02Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487163#M1850770 <HTML><HEAD></HEAD><BODY><P>And one more quick info.</P><P></P><P>normally errors occur due to following reasons.</P><P></P><P>1) passing negative value example l_value = '4-' try to reverse it to '-4'.</P><P>2) not creating a row at proper places.</P><P>3) not condensing l_value after passing a numeric value.</P><P>4) preparing wrong formula(not using proper condense and concatenate statements). </P><P></P><P>Hope these help you to resolve issues.</P><P></P><P>thanks,</P><P>vidyasagar</P></BODY></HTML> Fri, 08 Aug 2014 05:42:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487163#M1850770 former_member212124 2014-08-08T05:42:59Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487164#M1850771 <HTML><HEAD></HEAD><BODY><P>Thanks . Condensing the numeric value worked. You really saved my day. </P><P></P><P>one more thing. I want to know, which method you have used in creating xml file (in the screenshot ). because my output file is getting saved in&nbsp; SOLIX type structure. so it cannot be opened as XML browser while debugging. Please tell me , I am really curious to know.</P><P></P><P>and Thanks again.</P><P></P><P>Regards,</P><P>Seema</P></BODY></HTML> Fri, 08 Aug 2014 05:55:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487164#M1850771 Former Member 2014-08-08T05:55:53Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487165#M1850772 <HTML><HEAD></HEAD><BODY><P>One more help,,,, I need to lock(make non-editable) only particular column for the user in this excel. </P><P>I know how to lock the whole excel sheet ( r_worksheet<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Protected'&nbsp; </SPAN>prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'&nbsp; </SPAN><SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'1' </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN>), </P><P></P><P>but need to know for only one column .</P><P>Could you please help in this.</P><P></P><P>Regards,</P><P>Seema </P></BODY></HTML> Fri, 08 Aug 2014 06:00:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487165#M1850772 Former Member 2014-08-08T06:00:42Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487166#M1850773 <HTML><HEAD></HEAD><BODY><P>How to make a particular column non editable?</P><P>Make your style protected and pass that style name to your required column while passing data.</P><P></P><P>for example:</P><P>Find below the code for protection of a style.</P><P>Last two lines are very important.</P><P></P><P><SPAN class="L1S31">* Style for Headert<BR />&nbsp;&nbsp; r_style&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Style'</SPAN>&nbsp;&nbsp; parent = r_styles&nbsp; ).<BR />&nbsp;&nbsp; r_style-&gt;set_attribute_ns( name = <SPAN class="L1S33">'ID'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Headert'</SPAN> ).<BR /> <BR />&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Font'</SPAN>&nbsp; parent = r_style&nbsp; ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Bold'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'1'</SPAN> ).<BR /> <BR />&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Interior'</SPAN> parent = r_style&nbsp; ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Color'</SPAN>&nbsp;&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'#B2FF64'</SPAN> ).&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L1S31"> </SPAN><BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Pattern'</SPAN> prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Solid'</SPAN> ).<BR /> <BR />&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Alignment'</SPAN>&nbsp; parent = r_style&nbsp; ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Vertical'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Bottom'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'WrapText'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'1'</SPAN> ).<BR /> <BR />&nbsp;&nbsp; r_border&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Borders'</SPAN>&nbsp; parent = r_style ).<BR />&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Border'</SPAN>&nbsp;&nbsp; parent = r_border&nbsp; ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Position'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Bottom'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'LineStyle'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Continuous'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Weight'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'1'</SPAN> ).<BR /> <BR />&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Border'</SPAN>&nbsp;&nbsp; parent = r_border&nbsp; ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Position'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Left'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'LineStyle'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Continuous'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Weight'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'1'</SPAN> ).<BR /> <BR />&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Border'</SPAN>&nbsp;&nbsp; parent = r_border&nbsp; ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Position'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Top'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'LineStyle'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Continuous'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Weight'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'1'</SPAN> ).<BR /> <BR />&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Border'</SPAN>&nbsp;&nbsp; parent = r_border&nbsp; ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Position'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Right'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'LineStyle'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'Continuous'</SPAN> ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Weight'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'1'</SPAN> ).</SPAN></P><P><SPAN class="L1S31"><BR />&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33">'Protection'</SPAN>&nbsp; parent = r_style&nbsp; ).<BR />&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33">'Protected'</SPAN>&nbsp; prefix = <SPAN class="L1S33">'ss'</SPAN>&nbsp; <SPAN class="L1S52">value</SPAN> = <SPAN class="L1S33">'1'</SPAN> ).</SPAN> </P></BODY></HTML> Fri, 08 Aug 2014 06:40:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487166#M1850773 former_member212124 2014-08-08T06:40:23Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487167#M1850774 <HTML><HEAD></HEAD><BODY><P><STRONG style="color: #ff0000;">Moderator message</STRONG></P><P></P><P><SPAN style="color: #333333; font-size: 12px;"><EM> please review and tell what is wrong in it ASAP :</EM></SPAN></P><P><SPAN style="color: #333333; font-size: 12px;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #333333; font-size: 12px;">Please note - the use of "ASAP" and "urgent" and similar words is not permitted and can result in your post being rejected - which if you're in a hurry presumably isn't what you want. Everyone wants an answer ASAP. Everyone's needs are urgent.</SPAN></P><P><SPAN style="color: #333333; font-size: 12px;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #333333; font-size: 12px;">Please do not do this again.<EM><BR /></EM></SPAN></P></BODY></HTML> Fri, 08 Aug 2014 08:30:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487167#M1850774 matt 2014-08-08T08:30:20Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487168#M1850775 <HTML><HEAD></HEAD><BODY><P>Ok Matthew . I will take care of it.</P></BODY></HTML> Fri, 08 Aug 2014 10:23:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487168#M1850775 Former Member 2014-08-08T10:23:35Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487169#M1850776 <HTML><HEAD></HEAD><BODY><P>Hello Vidyasagar,</P><P></P><P>It didnt worked .</P><P></P><P>Thanks &amp; Regards,</P><P>Seema</P></BODY></HTML> Sun, 10 Aug 2014 06:37:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487169#M1850776 Former Member 2014-08-10T06:37:59Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487170#M1850777 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Sorry for late response I am bit busy here.</P><P>try and use this with your style for header.</P><P>add this code at the end of the style for header code section.</P><P>&nbsp;&nbsp; r_format&nbsp; = l_document-&gt;create_simple_element( name = <SPAN class="L1S33" style="font-weight: inherit; font-style: inherit; font-size: 12px; font-family: inherit;">'Protection'</SPAN>&nbsp; parent = r_style&nbsp; ).</P><P>&nbsp;&nbsp; r_format-&gt;set_attribute_ns( name = <SPAN class="L1S33" style="font-weight: inherit; font-style: inherit; font-size: 12px; font-family: inherit;">'Protected'</SPAN>&nbsp; prefix = <SPAN class="L1S33" style="font-weight: inherit; font-style: inherit; font-size: 12px; font-family: inherit;">'ss'</SPAN>&nbsp; <SPAN class="L1S52" style="font-weight: inherit; font-style: inherit; font-size: 12px; font-family: inherit;">value</SPAN> = <SPAN class="L1S33" style="font-weight: inherit; font-style: inherit; font-size: 12px; font-family: inherit;">'1'</SPAN> ).</P><P></P><P></P><P>thanks,</P><P>vidyasagar</P></BODY></HTML> Wed, 13 Aug 2014 04:34:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487170#M1850777 former_member212124 2014-08-13T04:34:07Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487171#M1850778 <HTML><HEAD></HEAD><BODY><P>Hello ,</P><P>I didn't worked.</P><P>Tried for changing style header</P><P></P><P>Please suggest.</P><P></P><P>Regards</P></BODY></HTML> Wed, 13 Aug 2014 10:31:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487171#M1850778 Former Member 2014-08-13T10:31:08Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487172#M1850779 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this code from attachment this will give you some idea.</P><P></P><P>Double click on the 'column2' which is marked in yellow.You will see it is read only.</P></BODY></HTML> Thu, 14 Aug 2014 04:35:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487172#M1850779 former_member212124 2014-08-14T04:35:19Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487173#M1850780 <HTML><HEAD></HEAD><BODY><P>Thanks Vidyasagar, It worked. But when I click on 'Uprotect Sheet' option in excel (after opening it), all the locked cells/columns becomes unprotected. any way to avoid this?</P><P></P><P>Regards,</P><P>Seema </P></BODY></HTML> Sun, 17 Aug 2014 18:00:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487173#M1850780 Former Member 2014-08-17T18:00:13Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487174#M1850781 <HTML><HEAD></HEAD><BODY><P>Hi Vidyasagar,</P><P></P><P>Your input over here helped me a lot, thanks for the help.</P><P></P><P>Just wanted to know, if it is possible to display image in Excel using this method ?</P><P></P><P>Also, I just wonder every time, how do you people come to know, about these different functionality,</P><P>is there any SAP document for these classes ?</P><P></P><P>Thanking You All.</P></BODY></HTML> Mon, 25 Aug 2014 06:45:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487174#M1850781 Former Member 2014-08-25T06:45:31Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487175#M1850782 <HTML><HEAD></HEAD><BODY><P>Hi Vidyasagar,</P><P></P><P>This solution was very helpful and I am now able to download an xls and xlsx file using this approach.</P><P>I have column headings included in my excel template. But I noticed one thing, When I enter data to be uploaded in this template and hit save , it saves it as an XML Spreadsheet, with a file extension of .XML. Is this the normal behavior, can I prevent this default.</P><P></P><P>Also, When I upload the excel file, it is pulling it up as an XML structure and not as an internal table</P><P>as I expected. The xlsx version is working fine, but the xls is coming up as XML.</P><P></P><P>I am doing the upload and download in WDA.</P><P></P><P>For uploading the xls version, I use the following approach -</P><TABLE><TBODY><TR><TD></TD><TD>CALL FUNCTION 'HR_KR_XSTRING_TO_STRING'</TD></TR><TR><TD></TD><TD>EXPORTING</TD></TR><TR><TD></TD><TD>in_xstring = lv_data_source</TD></TR><TR><TD></TD><TD>IMPORTING</TD></TR><TR><TD></TD><TD>out_string = l_string.</TD></TR></TBODY></TABLE><P></P><P>where lv_data_source is the file content from the WDA.</P><P>Here l_string is returned all gibberish.</P><P>If I save it as .XML, it returns the XML structure.</P><P></P><P>Using the following option for xlsx file and that is working fine.</P><TABLE><TBODY><TR><TD>*</TD><TD>Create object of class to read .xlsx file contents</TD></TR><TR><TD></TD><TD>CREATE OBJECT lref_excel</TD></TR><TR><TD></TD><TD>EXPORTING</TD></TR><TR><TD></TD><TD>document_name = lv_file_name</TD></TR><TR><TD></TD><TD>xdocument</TD><TD>= lv_data_source.</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>Can anyone help me with the xls version, how do we read the file without having to work with the XML. Or if I am using the wrong FM to retrieve the data from the file.</P><P></P><P>Appreciate your input.</P><P></P><P>Thank you</P><P>Lalitha</P></BODY></HTML> Wed, 27 Aug 2014 23:29:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487175#M1850782 Former Member 2014-08-27T23:29:08Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487176#M1850783 <HTML><HEAD></HEAD><BODY><P>Hi Ankit,</P><P></P><P>I am happy that you were benefited by this.</P><P></P><P>I think we can display image using this method but I still have to figure out how to do that.As soon as I figure it out ill be sharing it with you.</P><P></P><P>And how I got to know about this class? to be honest my senior colleague used this method and I learnt it from him. </P><P></P><P>thanks,</P><P>vidyasagar </P></BODY></HTML> Thu, 28 Aug 2014 04:54:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487176#M1850783 former_member212124 2014-08-28T04:54:42Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487177#M1850784 <HTML><HEAD></HEAD><BODY><P>Hi lalitha,</P><P></P><P>I will be sending you some example for uploading this excel data soon.</P><P></P><P></P><P></P><P>thanks,</P><P>vidyasagar</P></BODY></HTML> Thu, 28 Aug 2014 04:58:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487177#M1850784 former_member212124 2014-08-28T04:58:37Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487178#M1850785 <HTML><HEAD></HEAD><BODY><P>Hi seema,</P><P></P><P>Yeah I know the sheet becomes unprotected on click of&nbsp; 'Unprotect Sheet', I am trying to find a solution for that.</P><P></P><P>I will get back to you as soon as I get some solution.</P><P></P><P></P><P>thanks,</P><P>vidyasagar </P></BODY></HTML> Thu, 28 Aug 2014 06:26:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487178#M1850785 former_member212124 2014-08-28T06:26:04Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487179#M1850786 <HTML><HEAD></HEAD><BODY><P>Hi Vidyasagar,</P><P></P><P>I have been debugging this further, here is what I have found.</P><P></P><P>When I download the file as an xls file, it gets saved as a "Microsoft Excel 97-2003 Worksheet".</P><P>Now when I upload it as it is, without adding any data , the xstring is converted to XML -</P><P>&lt;?xml version="1.0"?&gt;&lt;workbook xmlns="urn:schemas-Microsoft-com: office: spreadsheet" etc</P><P>When I view this xstring in the XML browser , I can see the whole XML structure.(image one, after the split at the horizontal tab.</P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/529236" width="450" /></P><P></P><P>But if the same file, I open and add some data, and then do a save as , it defaults to an xml spreadsheet. (image 2) . I have office 2003 in my system.</P><P></P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/529237" width="450" /></P><P>Also I noticed that users with 2010 and above are not able to download the xlsx version , they get the error&nbsp; "Excel cannot open the file 'Blank Template.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file" (image 3).</P><P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/jiveimages/529274" width="450" /><BR />But I am able to download this. and also the upload for this works fine.</P><P></P><P>So am in a fix right now. XLS downloads ok, but not able to upload using it.</P><P>XLSX issue downloading, but upload works.</P><P></P><P><BR />Please do let me know if you need any other info.</P><P></P><P>Thank you</P><P>Lalitha</P></BODY></HTML> Thu, 28 Aug 2014 06:36:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487179#M1850786 Former Member 2014-08-28T06:36:19Z Re: file is corrupted error while creating excel using xml https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487180#M1850787 <HTML><HEAD></HEAD><BODY><P>Hi Lalitha,</P><P></P><P>Thank you for details.</P><P></P><P>Can you send the code for both upload and download that you are using, so that it will help me to understand the problem better.</P><P></P><P></P><P></P><P>thanks,</P><P>vidyasagar </P></BODY></HTML> Thu, 28 Aug 2014 08:24:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/file-is-corrupted-error-while-creating-excel-using-xml/m-p/10487180#M1850787 former_member212124 2014-08-28T08:24:03Z