Description:

1. The PB in the gride export EXCEL data window, thinking of the EXCEL encryption, including Chinese characters and letters in field at the same time,
2. The need to import the encrypted EXCEL files to another PB the encrypted data window, in the imported into the database
3. The encryption requirements is not high, only ask can't open the EXCEL, or on the inside data is garbled,
4. Just now I tried to find online function with ASC conversion line by line the main field of encryption, seemingly does not support Chinese characters encryption.

Please expert help, very urgent!!!!!!
Or send me a have a ready-made functions can also be used, (both encryption and decryption function need) thanked here ~
Email address: [email protected]

CodePudding user response:

A simpler method

In fileopen open the excel file, and then switch to 20 at sixes and sevens characters, the use of excel is can't open the

Decryption, use fileopen first open the file, remove the corresponding character, can be imported

CodePudding user response:

No see!
How can you say the writing? thank you

CodePudding user response:

Ha ha, there is necessary to emphasize the Excel?

Save as is not a text can be? A text file encryption (string) save, decrypt a text file (string), parsing and then deposited in the DataStore,
It is concise,

CodePudding user response:

A simpler method

In fileopen open the excel file, and then at the beginning of the file write 20 at sixes and sevens characters, the use of excel is can't open the

Decryption, use fileopen first open the file, remove the corresponding character, can be imported

CodePudding user response:

4. Just now I tried to find online function with ASC conversion line by line the main field of encryption, seemingly does not support Chinese characters encryption.
What is your pb version

CodePudding user response:

Use fileopen in binary mode to open the excel file, read the file to the BLOB variable, modify the BLOB variable, move at the beginning of 100 bytes in the end, and then put the BLOB is saved as a file,,,,
Decryption method, on the other hand, open the file, move the last 100 bytes to the front, save to file,

CodePudding user response:

1. No need to export EXCEL, export TXT,
2. Looking for a compressed DLL, add password can be compressed,