Upload EXCEL 256 chars in one cell and multiple sheets

[Former Member]

Hello everybody,

I have to upload Excel with multiple sheets.

I know this works with the SOFFICEINTEGRATION package.

But some cells do have more than 256 chars. all chars greater 256 get lost

Does anybody know how to solve?

We do not have the chance to modify the EXCEL manually. It has to aumomatically.

Thanks

Regards Mario

[Former Member]

Hello everybody,

I have to upload Excel with multiple sheets.

I know this works with the SOFFICEINTEGRATION package.

But some cells do have more than 256 chars. all chars greater 256 get lost

Does anybody know how to solve?

We do not have the chance to modify the EXCEL manually. It has to aumomatically.

Thanks

Regards Mario

[egenoves]

Hi Mario,

Do you have the option to develop a Z report?. You could use OLE in that case, like the SOFFICEINTEGRATION methods, but with your own structures. I think this way you could avoid the char 255  limitation.

This problem occurs also when you use the standard function ALSM_EXCEL_TO_INTERNAL_TABLE, the data element is char 255 declared.

Hope it helps

Regards

[Former Member]

Hi Enrique,

did you have a look in OLE-Package?

It is very difficult to make a copy

Regards Mario

[egenoves]

Hi Mario,

I don't understand why would you to copy an entire package... If you can fullfill your requirements with a Z report, with the use of OLE statementes i think you could avoid the problem of the char limitation,

Maybe i've misunderstood your question?

Regards