Need to Merge Cells using I_OI_SPREADSHEET Interface

[Former Member]

Using interface I_OI_SPREADSHEET, how do I merge the data in one cell to expand to several others?

I am using interface I_OI_SPREADSHEET (and others) to extract 30 internal tables from an ABAP report. It creates one MS Excel workbook with 30 tabs- one tab for each internal table.

The first cell in the first row has some text.

Column headers are on the second row.

The data starts on the third row.

I am using the FIT_WIDEST method on the column headers and data. The range starts at row 2.

The text on the first row is only visible in the first cell. It does not fit. I want to expand the text so it flows into the adjacent cells. Tried using FIT_WIDEST, but it gets reset when I use FIT_WIDEST on the data section (even though the range is clearly defined to start at row 2).

Hope my explanation is clear. Any ideas?

Norm

[Former Member]

Finally figured it out. Had to use method CELL_FORMAT and set the ALIGN parameter to '2' (left justified) before pasting the value into the cell. This allowed the value to overlap into the adjacent cells.

[Former Member]

Hi Norman,

I am trying to downlaod some data into excel sheet using SPREADSHEET interface . Program is executing but it is not opening excel application.

Will it be possible for you to send your code to me.

mail ID : madhukar_rao@yahoo.com

Best Regards,

MB