EasyXLS

How to protect Excel file with password in ColdFusion

<!--
=============================================================================
Tutorial 27

This tutorial shows how to create an Excel file in ColdFusion and
encrypt the Excel file by setting the password required for opening the file.
=============================================================================
-->
Click here to see the Excel file

Tutorial 27<br>
----------<br>

<!-- Create an instance of the class that exports Excel files -->
<cfobject type="java" class="EasyXLS.ExcelDocument" name="workbook" action="CREATE">

<!-- Create two worksheets -->
<cfset ret = workbook.easy_addWorksheet("First tab")>
<cfset ret = workbook.easy_addWorksheet("Second tab")>

<!-- Set the password for protecting the Excel file when the file is open -->
<cfset ret = workbook.easy_getOptions().setPasswordToOpen("password")>

<!-- Export Excel file -->
Writing file C:\Samples\Tutorial27.xls<br>
<cfset ret = workbook.easy_WriteXLSFile("C:\Samples\Tutorial27.xls")>

<!-- Confirm export of Excel file -->
<cfset sError = workbook.easy_getError()>
<cfif (sError is "")>
    <cfoutput>
        File successfully created.
    </cfoutput>
<cfelse>
    <cfoutput>
        Error encountered: #sError#
    </cfoutput>
</cfif>

<!-- Dispose memory -->
<cfset workbook.Dispose()>

EasyXLS Excel libraries:

Java
Excel Library for ColdFusion
full Java version to import, export or convert Excel files
Excel Writer for ColdFusion
Java version to create and export Excel files
Download EasyXLS™ Excel Library for ColdFusion

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSX XLSM XLSB XLS
XML HTML CSV TXT