How to insert " into a cell in excel

[Former Member]

Hi,

I have a z function module to download data into excel file .

Types: begin of t_file,

line(1000) type c,

end of t_file.

I need to create an internal table of above type and send it to z function module to create excel.While creating internal table one of the fields values should be something like "2(starting with ") .During debugging I am able to see " but after download there are some junk characters in that field instead of ".

Please let me know how to send " into excel file

Thanks

Bala Duvvuri

[Former Member]

Hi,

Try to pass Hexadecimal value for " and pass to excel. Check the datatype too.

If you need to convert it to hexadecimal check the classes CL_ABAP_CONV_IN_CE and CL_ABAP_CONV_OUT_CE for hexadecimal conversion.

Regards,

Ben

[Former Member]

HI Ben,

Can you give me some sample code

Thanks

Bala Duvvuri

[Former Member]

Hi Bala,

There might be error while creating an excel file.

How are you creating an excel?

Regards,

Gaurav

[Former Member]

Hi Bala,

I would suggest to go to your code in debugging and chek giving the hwx value for " and dowmload to excel. I faced a similar problem and used this method. But i had to go for other method as my requirement was to download and both upload.

I think hex value for " is 2200.

sample codes for FMs for conversion can be easily find in net.

Please try and reply.

Ben.