Parse excel spreadsheet with password

I have done quite a lot of diggings, but all I found were examples and
instructions about opening/reading simple xls files.

I need to open and read data from encrypted excel spreadsheets. Does
anyone know how to do that?

cheers :slight_smile:

ยทยทยท

--
Posted via http://www.ruby-forum.com/.

From Microsoft's web site:

"Caution If a user assigns password protection to a
workbook and then forgets the password, it is
impossible to perform the following activities:

    * Open the workbook.
    * Gain access to the workbook's data from another
workbook through a link.
    * Remove protection from the workbook.
    * Recover data from the workbook."

I believe you need a password cracking utility, or you
need to make use of a password cracking service
(http://www.passwordbusters.com). Recent MSOffice
versions apparently use 40-bit RC4 encryption.

You can write your own common-password cracking
utility. If you're adventurous and have a
supercomputer handy, you can write a brute force
decryption utility. Maybe, someday that will be a
ruby quiz ... no way to test, though :slight_smile:

ยทยทยท

--- lovelymmx <lovelymmx@gmail.com> wrote:

I have done quite a lot of diggings, but all I found
were examples and
instructions about opening/reading simple xls files.

I need to open and read data from encrypted excel
spreadsheets. Does
anyone know how to do that?

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Todd Benson wrote:

I believe you need a password cracking utility, or you
need to make use of a password cracking service
(http://www.passwordbusters.com). Recent MSOffice
versions apparently use 40-bit RC4 encryption.

You can write your own common-password cracking
utility. If you're adventurous and have a
supercomputer handy, you can write a brute force
decryption utility. Maybe, someday that will be a
ruby quiz ... no way to test, though :slight_smile:

thanks, but what i need is not a password cracker.
I have already found some useful reference on msdn.

password could be passed as a parameter into the Workbooks.Open method
:slight_smile:

ยทยทยท

--
Posted via http://www.ruby-forum.com/\.

thanks, but what i need is not a password cracker.
I have already found some useful reference on msdn.

password could be passed as a parameter into the
Workbooks.Open method
:slight_smile:

Yeah, I misunderstood you. My reading comprehension
skills have gone downhill recently.

ยทยทยท

--- Guanliang Liu <lovelymmx@gmail.com> wrote:

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around