topic Re: Internal Table to EXCEL in Application Development and Automation Discussions

Internal Table to EXCEL

Former Member — Mon, 31 May 2010 12:43:32 GMT

Hell all,

I have a requirement where in which I need to download the dynamic internal table to Excel sheet and save the excel sheet in the application server and send the same in emai as attachmentl. All these need to be done in background. The no of columns in the internal table may vary from 40 to 60. Please help me with this.

Thanks & Regards

Hemanth

Re: Internal Table to EXCEL

Former Member — Mon, 31 May 2010 12:56:12 GMT

Hi,

See:

Best regards,

Leandro Mengue

Hi,

You can create the file in XML format.

Create a XLS (in Excel) with your formats and needs. Save it as XML. Open this file with Nodepad.

Your program have to follow this format.

Best regards,

Leandro Mengue

Example:

<?xml version="1.0"?>

<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:o="urn:schemas-microsoft-com:office:office"

xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:html="http://www.w3.org/TR/REC-html40">

<Author>bmengue</Author>

<LastAuthor>bmengue</LastAuthor>

<Company>xxxxx</Company>

</DocumentProperties>

<ProtectStructure>False</ProtectStructure>

<ProtectWindows>False</ProtectWindows>

</ExcelWorkbook>

...

<Table ss:ExpandedColumnCount="4" ss:ExpandedRowCount="4" x:FullColumns="1"

x:FullRows="1">

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

</Table>

...

replace A1,B2,C3,D4 by your values for cells A1,B2,C2,D4 ...

Re: Internal Table to EXCEL

former_member214857 — Mon, 31 May 2010 13:24:04 GMT

Hi Hemanth

Actually, as your needs you have to write a program to export internal data manually to an XLS file. You will need work with tags defined in XLS definition

Export process like sample below:

OPEN DATASET myfile FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.
  
    LOOP AT my_table.
        CONCATENATE '<Cell ss:Index="X">' my_table </cell> INTO x_value.        
        TRANSFER x_value TO myfile.
    ENDLOOP.

    CLOSE DATASET myfile.

After that, you can use FM SO_DOCUMENT_SEND_API1 to send emails and use exported file as attachment.

Kind regards

Edited by: Carlos Machado on May 31, 2010 3:30 PM

Re: Internal Table to EXCEL

Former Member — Tue, 01 Jun 2010 06:03:30 GMT

Thanks Carlos. I have a doubt here. So in the '<Cell>'. Do I need to give the Cell numbaer like A1,B1 as in excel??

Regards

Hemanth

Re: Internal Table to EXCEL

former_member214857 — Thu, 03 Jun 2010 00:11:26 GMT

Hi Hemanth

Actually, is necessary to nest <Row> and <Cell> tags, please check as sample below:

<Row ss:Index="3">
        <Cell ss:StyleID="s1">
          <Data ss:Type="String">Product</Data>
        </Cell>
        <Cell ss:StyleID="s1">
          <Data ss:Type="String">Sold</Data>
        </Cell>
        <Cell ss:StyleID="s1">
          <Data ss:Type="String">Price</Data>
        </Cell>
        <Cell ss:StyleID="s1">
          <Data ss:Type="String">Sum</Data>
        </Cell>
      </Row>

Edited by: Carlos Machado on Jun 3, 2010 2:11 AM

Re: Internal Table to EXCEL

Former Member — Fri, 04 Jun 2010 03:21:47 GMT

This message was moderated.