Now Check is your Worksheet, if you want to edit the Cell in work sheet then one password pop window show to ask for password Check below Screen Shot. Password Protected ) in Excel Sheet, look as below Screen Shot. Note: If User Name in Lower Case then Click on Check boxĪfter pressing Execute button or F8 Key you got Exported data( i.e. Įnter your Excel File Name with Path and User Name as a below Screen Shot. Using CALL METHOD CL_HTTP_UTILITY =>IF_HTTP_UTILITY ~DECODE_BASE64 decrypt the encrypted text (i.e. Using CALL METHOD CL_GUI_FRONTEND_SERVICES =>CLIPBOARD_EXPORT to Clipboard.
PASSWORD1 : QUJBUEA0MA= (Encrypted Password )Ĭreate Object for Excel using EXCEL.APPLICATION. Using CALL METHOD CL_HTTP_UTILITY =>IF_HTTP_UTILITY ~ENCODE_BASE64 Encrypt the password text Upload some User ID’s and it’s respective Password into Custom “Y” table.ĭecrypted Password: In your Custom Upload Program use below code for Encryption of Password, Which will store in above ‘Y’ Table.Decrypted format) both Cell and Worksheet. To Export Excel Sheet with Password Protected(i.e.Password Store in ‘Y’ Table for the Respective User in Encrypted format.
0 kommentar(er)
