Encrypt and Decrypt Excel columns
-
Experts, I have a excel sheet which has 7 lakhs records in which password has been encrypted. I have to decrypt the password column and find the passord whose length is greater than 7. I have created encrypt and decrypt methods and the way to find the length of the password ---- ---- ---- OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$] where len(password) < 7", oledbConn); ---- ---- ---- My requirement is, is there any way to decrypt the whole passoword column or i have to loop through all the cells one by one.
Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]
-
Experts, I have a excel sheet which has 7 lakhs records in which password has been encrypted. I have to decrypt the password column and find the passord whose length is greater than 7. I have created encrypt and decrypt methods and the way to find the length of the password ---- ---- ---- OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$] where len(password) < 7", oledbConn); ---- ---- ---- My requirement is, is there any way to decrypt the whole passoword column or i have to loop through all the cells one by one.
Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]
One by one. Each piece of data is encrypted separately so it needs to be decrypted separately. If you have a piece of data that when encrypted turns into 12345 and another piece of data that turns into 67890 trying to decrypt 1234567890 would not give you the two original pieces of data (unless you are using a really horrible encryption method like ROT13). It's like if you took a zip file and chopped it in half, you aren't going to be able to unzip either piece by itself.