upload Excel with BSP

[Former Member]

Hi,

i have upload a excel file with BSP-Extension htmlb "fileupload". Now i get the excel-content in XString. How can i convert the Xstring to internal table?

i can convert the xstring to string but i need it in internal table!

can anyone help me!

greetings

markus

[former_member181879]

Markus,

I know of no functions that will convert a XLS file into an internal table. I suspect that even just converting the XSTRING (binary blob) into a string should be sufficient to completely destroy the XLS file.

Only idea which you might try, is to convert (save as?) the XLS into a CSV file and upload this. This is just a comma separated file and should be easy to parse. This topic (at least writing such files) have been discussed previously a number of times. Maybe you search through the forum.

++bcm

[former_member181879]

I see that the ABAP forum has a number of XLS questions/answers. Maybe you can search through that forum as well.

For example, see this link:

++bcm