Skip to main content
userCold9
Inspiring
Aug 8, 2018 8:05 PM UTC
Question

Encrypt data in a created Excel file

Hi,

Is there away in Cold Fusion2016 to encrypt the contents of a create Excel file, either completely or by cell?

Then allow the user to de-encrypt the Excel file after it has been created?

Using the following to create an excel file.

<cfset TabChar = Chr(9)>
<cfset NewLine = Chr(13) & Chr(10)>
<cfheader name="Content-Disposition" value="attachment; filename=reports.xls">
<CFCONTENT TYPE="application/vnd.ms-excel" RESET="Yes">

Thanks in advance,

Mike

    This topic is closed to new replies. Start a new post to keep the conversation going.

    4 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    Aug 12, 2018 11:41 AM UTC

    If you want file encryption and decryption, then the solution is straightforward. I am assuming the user also uses ColdFusion.

    Your file encryption

    <cffile file="C:\Users\BKBK\Desktop\testDir\test.xls" action="readBinary" variable="myExcelData">

    <cfset key=generateSecretKey("AES")>

    <cfset encryptedData=encryptBinary(myExcelData, key, "AES")>

    <cffile file="C:\Users\BKBK\Desktop\testDir\test1_encrypted.xls" action="write" output="#encryptedData#">

    key:<cfoutput>#key#</cfoutput>

    Now, give the user the key, SPCX1nM2h+NPzx4j6e24tQ==, say.

    User's file decryption

    <cffile file="C:\tmp\testDir\test1_encrypted.xls" action="readBinary" variable="encryptedExcelData">

    <cfset key="SPCX1nM2h+NPzx4j6e24tQ==">

    <cfset decryptedData=decryptBinary(encryptedExcelData, key, "AES")>

    <cffile file="C:\tmp\testDir\test1_decrypted.xls" action="write" output="#decryptedData#">

    Translate
    userCold9Author
    Inspiring
    Aug 13, 2018 10:07 AM UTC

    Hi,

    The user does not have access to Cold Fusion.

    The user has access to Microsoft Excel.

    Thanks,

    Mike

    Translate
    WolfShade
    WolfShade
    Legend
    Aug 13, 2018 3:31 PM UTC

    The user must use something that can decrypt the file, using the key you provide.  If not ColdFusion, then something.  If they only have access to the Excel file without any method of decrypting it, then the whole process is pointless.

    V/r,

    ^ _ ^

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices