<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Help with string to xstring in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/help-with-string-to-xstring/m-p/2366826#M524119</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi, I'm pulling an excel file from the application server and then attaching the file to the method "attach_file_to_response". However, when I view the file in excel I have an unwanted column. Can anyone tell me how to fix this, or even if there is another way of doing this.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have inserted my code below and thanks in advance.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;***&lt;STRONG&gt;CODE&lt;/STRONG&gt;***&lt;/P&gt;&lt;P&gt;open dataset lv_dataset for input in text mode encoding default.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;do.&lt;/P&gt;&lt;P&gt;read dataset lv_dataset into wa.&lt;/P&gt;&lt;P&gt;if sy-subrc ne 0.&lt;/P&gt;&lt;P&gt;exit.&lt;/P&gt;&lt;P&gt;endif.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;concatenate: lv_string_s&lt;/P&gt;&lt;P&gt;                    wa&lt;/P&gt;&lt;P&gt;                    cl_abap_char_utilities=&amp;gt;cr_lf into lv_string_s&lt;/P&gt;&lt;P&gt;                    separated by cl_abap_char_utilities=&amp;gt;horizontal_tab.&lt;/P&gt;&lt;P&gt;enddo.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;close dataset lv_dataset.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;cl_abap_conv_out_ce=&amp;gt;create( receiving conv = lr_conv ).&lt;/P&gt;&lt;P&gt;lr_conv-&amp;gt;convert( exporting data = lv_string_s&lt;/P&gt;&lt;P&gt;importing buffer = lv_xfile ).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;cl_wd_runtime_services=&amp;gt;attach_file_to_response(&lt;/P&gt;&lt;P&gt;exporting i_filename = i_filename&lt;/P&gt;&lt;P&gt;i_content = lv_xfile&lt;/P&gt;&lt;P&gt;i_mime_type = 'application/vnd.ms-excel' ).&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 07 Jun 2007 08:41:33 GMT</pubDate>
    <dc:creator>Former Member</dc:creator>
    <dc:date>2007-06-07T08:41:33Z</dc:date>
    <item>
      <title>Help with string to xstring</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/help-with-string-to-xstring/m-p/2366826#M524119</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi, I'm pulling an excel file from the application server and then attaching the file to the method "attach_file_to_response". However, when I view the file in excel I have an unwanted column. Can anyone tell me how to fix this, or even if there is another way of doing this.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have inserted my code below and thanks in advance.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;***&lt;STRONG&gt;CODE&lt;/STRONG&gt;***&lt;/P&gt;&lt;P&gt;open dataset lv_dataset for input in text mode encoding default.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;do.&lt;/P&gt;&lt;P&gt;read dataset lv_dataset into wa.&lt;/P&gt;&lt;P&gt;if sy-subrc ne 0.&lt;/P&gt;&lt;P&gt;exit.&lt;/P&gt;&lt;P&gt;endif.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;concatenate: lv_string_s&lt;/P&gt;&lt;P&gt;                    wa&lt;/P&gt;&lt;P&gt;                    cl_abap_char_utilities=&amp;gt;cr_lf into lv_string_s&lt;/P&gt;&lt;P&gt;                    separated by cl_abap_char_utilities=&amp;gt;horizontal_tab.&lt;/P&gt;&lt;P&gt;enddo.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;close dataset lv_dataset.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;cl_abap_conv_out_ce=&amp;gt;create( receiving conv = lr_conv ).&lt;/P&gt;&lt;P&gt;lr_conv-&amp;gt;convert( exporting data = lv_string_s&lt;/P&gt;&lt;P&gt;importing buffer = lv_xfile ).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;cl_wd_runtime_services=&amp;gt;attach_file_to_response(&lt;/P&gt;&lt;P&gt;exporting i_filename = i_filename&lt;/P&gt;&lt;P&gt;i_content = lv_xfile&lt;/P&gt;&lt;P&gt;i_mime_type = 'application/vnd.ms-excel' ).&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 07 Jun 2007 08:41:33 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/help-with-string-to-xstring/m-p/2366826#M524119</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-06-07T08:41:33Z</dc:date>
    </item>
    <item>
      <title>Re: Help with string to xstring</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/help-with-string-to-xstring/m-p/2366827#M524120</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;hi,&lt;/P&gt;&lt;P&gt;          try this one&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;data: xl_content type xstring .&lt;/P&gt;&lt;P&gt;DATA: binary_content TYPE solix_tab.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;CALL FUNCTION 'SCMS_XSTRING_TO_BINARY'&lt;/P&gt;&lt;P&gt;EXPORTING&lt;/P&gt;&lt;P&gt;buffer = xl_content&lt;/P&gt;&lt;P&gt;TABLES&lt;/P&gt;&lt;P&gt;binary_tab = binary_content.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;regards&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 07 Jun 2007 08:45:51 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/help-with-string-to-xstring/m-p/2366827#M524120</guid>
      <dc:creator>Former Member</dc:creator>
      <dc:date>2007-06-07T08:45:51Z</dc:date>
    </item>
    <item>
      <title>Re: Help with string to xstring</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/help-with-string-to-xstring/m-p/2366828#M524121</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Try function module 'HR_KR_STRING_TO_XSTRING'.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks and regards,&lt;/P&gt;&lt;P&gt;S. Chandra Mouli.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 07 Jun 2007 08:59:08 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/help-with-string-to-xstring/m-p/2366828#M524121</guid>
      <dc:creator>former_member784222</dc:creator>
      <dc:date>2007-06-07T08:59:08Z</dc:date>
    </item>
  </channel>
</rss>

