Problem while reading data from excel

[Former Member]

Hi,

I using ALSM_EXCEL_TO_INTERNAL_TABLE to read data from excel into internal table. As there is a limitation on "alsmex_tabline-value" of 50 char, i am able to read only 50 chars of single column value from excel.

I need to read the entire text in one column eventhough it is more than 50 chars. Is this possible with any function module other than gui_upload?

I need a way to directly read entire cell content from excel itself. Please let me know if anyone has any solutions.

Thanks,

Sonali.

[Former Member]

That is a restriction for this fm, but check this out - what i found for this fm

Symptom

Many customers need a function that allows them to transfer values from an Excel table to the SAP system. Up to now there

has been no formally released interface for this.

For the Asset Accounting legacy data transfer, a module was written to transfer the Excel data using the clipboard of the

Windows system by OLE (Object Linking and Embedding. This module is called ALSM_EXCEL_TO_INTERNAL_TABLE. The

module was only designed for the requirements of the Asset Accounting legacy data transfer. This leads to some restrictions,

including the following:

1. The module is not released for customers.

2. The module is only available in a SAP_APPL system.

3. The output structure is limited to 9999 rows and columns.

4. The output structure is limited to 50 characters per cell.

Other terms

AS100, OLE, EXCEL

Reason and Prerequisites

This is due to the use of function modules that are not released in customer programs.

Solution

See the attached Note 109533 for the impact on support from point 1 above.

You see from this that points 2 to 4 are correct.

If you use the module in spite of this and want to get around the restrictions from points 2 to 4, we recommend that you

proceed as follows:

1. Copy the module into your customer namespace.

2. As Associated Type for the table parameter INTERN, use your own structure that has the same components as the

original structure ALSMEX_TABLINE. By using your own component types, you can get around the restrictions on

rows, columns or cell length.

Any inquiries that relate to the module you created yourself or to how to use the module

ALSM_EXCEL_TO_INTERNAL_TABLE from customer programs will only be dealt with by chargeable Remote Consulting.

OSS Notes 933420, 129994 and 127666,

Link is

http://lkptantan.itpub.net/category/2097/4014

If this helps, please close the thread.

ashish

[Former Member]

Thank You for the solution.