topic Password protected file reading.... in Application Development and Automation Discussions

Password protected file reading....

Former Member — Tue, 23 Oct 2007 14:21:40 GMT

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

Re: Password protected file reading....

Sougata — Tue, 23 Oct 2007 14:35:04 GMT

Do you have the password to read the Excel file?

Re: Password protected file reading....

Former Member — Tue, 23 Oct 2007 14:37:06 GMT

Yes..I have and it's always constant

Re: Password protected file reading....

Sougata — Tue, 23 Oct 2007 14:38:56 GMT

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.