Password protected file reading....

[Former Member]

Hi All,

I want to read password protected excel file and convert into internal table data....

Somebody (SDN forums) suggested me to use OLE .

I've gone thru some examples. But all exmples were about to create password while downloading to excel..like

'EXCEL_OLE_STANDARD_DAT'

Does anybody have an idea to read password protected excel file and convert dat into internal table using OLE??

Sudha

Message was edited by:

sapsudha rao

Message was edited by:

sapsudha rao

[Sougata]

Do you have the password to read the Excel file?

[Former Member]

Yes..I have and it's always constant

[Sougata]

Look at OLE class/methods and demo programs using OLE technology. Look at transaction ABAPDOCU and the Reuse Library (SE84, as far as I remember). It should be fairly simple.

Don't forget to reward points.

Sougata.