Password protected Excel file and encryption

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument workbook = new ExcelDocument(2);
  
// Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab");
workbook.easy_getSheetAt(1).setSheetName("Second tab");
        
// Set the password for protecting the Excel file when the file is open
workbook.easy_getOptions().setPasswordToOpen("password");

// Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Password protected and encrypted Excel.xlsx");

' Create an instance of the class that exports Excel file, having two sheets
Dim workbook As New ExcelDocument(2)

' Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab")
workbook.easy_getSheetAt(1).setSheetName("Second tab")

' Set the password for protecting the Excel file when the file is open
workbook.easy_getOptions().setPasswordToOpen("password")

' Create Excel file
workbook.easy_WriteXLSXFile("C:\Samples\Password protected and encrypted Excel.xlsx")

C++

// Create a pointer to the interface that generates Excel files
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelDocument),
		      (void**) &workbook) ;

// Create two sheets
workbook->easy_addWorksheet_2("First tab");
workbook->easy_addWorksheet_2("Second tab");

// Set the password for protecting the Excel file when the file is open
workbook->easy_getOptions()->setPasswordToOpen("password");

// Create Excel file
workbook->easy_WriteXLSXFile("C:\\Samples\\Password protected and encrypted Excel.xlsx");

Click here to see Continuous Code Listing


C++.NET

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument ^workbook = gcnew ExcelDocument(2);

// Set the sheet names
workbook->easy_getSheetAt(0)->setSheetName("First tab");
workbook->easy_getSheetAt(1)->setSheetName("Second tab");

// Set the password for protecting the Excel file when the file is open
workbook->easy_getOptions()->setPasswordToOpen("password");

// Create Excel file
workbook->easy_WriteXLSXFile("C:\\Samples\\Password protected and encrypted Excel.xlsx");

Click here to see Continuous Code Listing

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument workbook = new ExcelDocument(2);
  
// Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab");
workbook.easy_getSheetAt(1).setSheetName("Second tab");
        
// Set the password for protecting the Excel file when the file is open
workbook.easy_getOptions().setPasswordToOpen("password");

// Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Password protected and encrypted Excel.xlsx");

.NET:

// Create an instance of the class that exports Excel file
$workbook = new COM("EasyXLS.ExcelDocument");

// Create two sheets
$workbook->easy_addWorksheet_2("First tab");
$workbook->easy_addWorksheet_2("Second tab");

// Set the password for protecting the Excel file when the file is open
$workbook->easy_getOptions()->setPasswordToOpen("password");

// Export Excel file
$workbook->easy_WriteXLSXFile("C:\\Samples\\Password protected and encrypted Excel.xlsx");

Click here to see Continuous Code Listing


Java:

// Create an instance of the class that exports Excel files
$workbook = new java("EasyXLS.ExcelDocument");
	
// Create two worksheets
$workbook->easy_addWorksheet("First tab");
$workbook->easy_addWorksheet("Second tab");

// Set the password for protecting the Excel file when the file is open
$workbook->easy_getOptions()->setPasswordToOpen("password");
		
// Export Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Password protected and encrypted Excel.xlsx");

Click here to see Continuous Code Listing

' Create an instance of the class that exports Excel file
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Create two sheets
workbook.easy_addWorksheet_2("First tab")
workbook.easy_addWorksheet_2("Second tab")

' Set the password for protecting the Excel file when the file is open
workbook.easy_getOptions().setPasswordToOpen("password")

' Create Excel file
workbook.easy_WriteXLSXFile ("C:\Samples\Password protected and encrypted Excel.xlsx")

' Create an instance of the class that exports Excel file
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Create two sheets
workbook.easy_addWorksheet_2 ("First tab")
workbook.easy_addWorksheet_2 ("Second tab")

' Set the password for protecting the Excel file when the file is open
workbook.easy_getOptions().setPasswordToOpen("password")

' Create Excel file
workbook.easy_WriteXLSXFile ("C:\Samples\Password protected and encrypted Excel.xlsx")

' Create an instance of the class that exports Excel file
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Create two sheets
workbook.easy_addWorksheet_2("First tab")
workbook.easy_addWorksheet_2("Second tab")

' Set the password for protecting the Excel file when the file is open
workbook.easy_getOptions().setPasswordToOpen("password")

' Create Excel file
workbook.easy_WriteXLSXFile ("C:\Samples\Password protected and encrypted Excel.xlsx")

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

<!-- Create two sheets -->
<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")>

<!-- Create Excel file -->
<cfset ret = workbook.easy_WriteXLSXFile(
        "C:\Samples\Password protected and encrypted Excel.xlsx")>

.NET:

# Create an instance of the class that exports Excel files, having two sheets
workbook = ExcelDocument(2)

# Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab")
workbook.easy_getSheetAt(1).setSheetName("Second tab")

# Set the password for protecting the Excel file when the file is open
workbook.easy_getOptions().setPasswordToOpen("password")

# Export Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Password protected and encrypted Excel.xlsx")

Click here to see Continuous Code Listing


Java:

# Create an instance of the class that exports Excel files, having two sheets
workbook = gateway.jvm.ExcelDocument(2)

# Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab")
workbook.easy_getSheetAt(1).setSheetName("Second tab")

# Set the password for protecting the Excel file when the file is open
workbook.easy_getOptions().setPasswordToOpen("password")

# Export Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Password protected and encrypted Excel.xlsx")

Click here to see Continuous Code Listing

// Create an instance of the class that loads Excel file
ExcelDocument workbook = new ExcelDocument();

// Set the password for opening the Excel file
workbook.easy_getOptions().setPasswordToOpen("password");

// Load Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\Password protected Excel.xlsx");

' Create an instance of the class that loads Excel file
Dim workbook As New ExcelDocument()

' Set the password for opening the Excel file
workbook.easy_getOptions().setPasswordToOpen("password")

' Load Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\Password protected Excel.xlsx")

C++

// Create an instance of the class that loads Excel file
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelDocument),
		      (void**) &workbook);

// Set the password for opening the Excel file
workbook->easy_getOptions()->setPasswordToOpen("password");

// Load Excel file
workbook->easy_LoadXLSXFile("C:\\Samples\\Password protected Excel.xlsx");


C++.NET

// Create an instance of the class that loads Excel file
ExcelDocument ^workbook = gcnew ExcelDocument();

// Set the password for opening the Excel file
workbook->easy_getOptions()->setPasswordToOpen("password");

// Load Excel file
workbook->easy_LoadXLSXFile("C:\\Samples\\Password protected Excel.xlsx");

// Create an instance of the class that loads Excel file
ExcelDocument workbook = new ExcelDocument();

// Set the password for opening the Excel file
workbook.easy_getOptions().setPasswordToOpen("password");

// Load Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\Password protected Excel.xlsx");

.NET:

// Create an instance of the class that loads Excel file
$workbook = new COM("EasyXLS.ExcelDocument");

// Set the password for opening the Excel file
$workbook->easy_getOptions()->setPasswordToOpen("password");

// Load Excel file
$workbook->easy_LoadXLSXFile("C:\Samples\Password protected Excel.xlsx");


Java:

// Create an instance of the class that loads Excel file
$workbook = new java("EasyXLS.ExcelDocument");

// Set the password for opening the Excel file
$workbook->easy_getOptions()->setPasswordToOpen("password");

// Load Excel file
$workbook->easy_LoadXLSXFile("C:\Samples\Password protected Excel.xlsx");

' Create an instance of the class that loads Excel file
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Set the password for opening the Excel file
workbook.easy_getOptions().setPasswordToOpen("password")

' Load Excel file
workbook.easy_LoadXLSXFile("C:\Samples\Password protected Excel.xlsx")

' Create an instance of the class that loads Excel file
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Set the password for opening the Excel file
workbook.easy_getOptions().setPasswordToOpen ("password")

' Load Excel file
workbook.easy_LoadXLSXFile ("C:\Samples\Password protected Excel.xlsx")

' Create an instance of the class that loads Excel file
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Set the password for opening the Excel file
workbook.easy_getOptions().setPasswordToOpen("password")

' Load Excel file
workbook.easy_LoadXLSXFile("C:\Samples\Password protected Excel.xlsx")

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

<!-- Set the password for opening the Excel file -->
<cfset workbook.easy_getOptions().setPasswordToOpen("password")>

<!-- Load Excel file -->
<cfset ret = workbook.easy_LoadXLSXFile("C:\\Samples\\Password protected Excel.xlsx")>

.NET:

# Create an instance of the class that loads Excel file
workbook = ExcelDocument()

# Set the password for opening the Excel file
workbook.easy_getOptions().setPasswordToOpen("password")

# Load Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\Password protected Excel.xlsx")


Java:

# Create an instance of the class that loads Excel file
workbook = gateway.jvm.ExcelDocument()

# Set the password for opening the Excel file
workbook.easy_getOptions().setPasswordToOpen("password")

# Load Excel file
workbook.easy_LoadXLSXFile("C:\\Samples\\Password protected Excel.xlsx")

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument workbook = new ExcelDocument(2);

// Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab");
workbook.easy_getSheetAt(1).setSheetName("Second tab");

// Set the password for protecting the workbook
workbook.setWorkbookProtection(true, true, "password");

// Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Encrypted Excel.xlsx");

' Create an instance of the class that exports Excel file, having two sheets
Dim workbook As New ExcelDocument(2)

' Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab")
workbook.easy_getSheetAt(1).setSheetName("Second tab")

' Set the password for protecting the workbook
workbook.setWorkbookProtection(True, True, "password")

' Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Encrypted Excel.xlsx")

C++

// Create an instance of the class that exports Excel file
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelDocument),
		      (void**) &workbook);

// Create two sheets
workbook->easy_addWorksheet_2("First tab");
workbook->easy_addWorksheet_2("Second tab");

// Set the password for protecting the workbook
workbook->setWorkbookProtection(true, true, "password");

// Create Excel file
workbook->easy_WriteXLSXFile("C:\\Samples\\Encrypted Excel.xlsx");


C++.NET

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument ^workbook = gcnew ExcelDocument(2);

// Set the sheet names
workbook->easy_getSheetAt(0)->setSheetName("First tab");
workbook->easy_getSheetAt(1)->setSheetName("Second tab");

// Set the password for protecting the workbook
workbook->setWorkbookProtection(true, true, "password");

// Create Excel file
workbook->easy_WriteXLSXFile("C:\\Samples\\Encrypted Excel.xlsx");

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument workbook = new ExcelDocument(2);

// Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab");
workbook.easy_getSheetAt(1).setSheetName("Second tab");

// Set the password for protecting the workbook
workbook.setWorkbookProtection(true, true, "password");

// Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Encrypted Excel.xlsx");

.NET:

// Create an instance of the class that exports Excel file
$workbook = new COM("EasyXLS.ExcelDocument");

// Create two sheets
$workbook->easy_addWorksheet_2("First tab");
$workbook->easy_addWorksheet_2("Second tab");

// Set the password for protecting the workbook
$workbook->setWorkbookProtection(true, true, "password");

// Create Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Encrypted Excel.xlsx");


Java:

// Create an instance of the class that exports Excel file
$workbook = new java("EasyXLS.ExcelDocument");

// Create two sheets
$workbook->easy_addWorksheet("First tab");
$workbook->easy_addWorksheet("Second tab");

// Set the password for protecting the workbook
$workbook->setWorkbookProtection(true, true, "password");

// Create Excel file
$workbook->easy_WriteXLSXFile("C:\Samples\Encrypted Excel.xlsx");

' Create an instance of the class that exports Excel file
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Create two sheets
workbook.easy_addWorksheet_2("First tab")
workbook.easy_addWorksheet_2("Second tab")

' Set the password for protecting the workbook
workbook.setWorkbookProtection true, true, "password"

' Create Excel file
workbook.easy_WriteXLSXFile("C:\Samples\Encrypted Excel.xlsx")

' Create an instance of the class that exports Excel file
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Create two sheets
workbook.easy_addWorksheet_2 ("First tab")
workbook.easy_addWorksheet_2 ("Second tab")

' Set the password for protecting the workbook
workbook.setWorkbookProtection True, True, "password"

' Create Excel file
workbook.easy_WriteXLSXFile ("C:\Samples\Encrypted Excel.xlsx")

' Create an instance of the class that exports Excel file
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Create two sheets
workbook.easy_addWorksheet_2("First tab")
workbook.easy_addWorksheet_2("Second tab")

' Set the password for protecting the workbook
workbook.setWorkbookProtection True, True, "password"

' Create Excel file
workbook.easy_WriteXLSXFile("C:\Samples\Encrypted Excel.xlsx")

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

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

<!-- Set the password for protecting the workbook -->
<cfset workbook.setWorkbookProtection(true, true, "password")>

<!-- Create Excel file -->
<cfset ret = workbook.easy_WriteXLSXFile("C:\\Samples\\Encrypted Excel.xlsx")>

.NET:

# Create an instance of the class that exports Excel file, having two sheets
workbook = ExcelDocument(2)

# Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab")
workbook.easy_getSheetAt(1).setSheetName("Second tab")

# Set the password for protecting the workbook
workbook.setWorkbookProtection(True, True, "password")

# Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Encrypted Excel.xlsx")


Java:

# Create an instance of the class that exports Excel file, having two sheets
workbook = gateway.jvm.ExcelDocument(2)

# Set the sheet names
workbook.easy_getSheetAt(0).setSheetName("First tab")
workbook.easy_getSheetAt(1).setSheetName("Second tab")

# Set the password for protecting the workbook
workbook.setWorkbookProtection(True, True, "password")

# Create Excel file
workbook.easy_WriteXLSXFile("C:\\Samples\\Encrypted Excel.xlsx")

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument workbook = new ExcelDocument(2);

// Set encryption algorithm and password 
workbook.easy_getOptions().setEncryptionOptions(EasyXLS.Constants.Encrypt.ENCRYPTION_WEAK_XOR, "password");

// Create Excel file
workbook.easy_WriteXLSFile("C:\\Samples\\Encrypted Excel.xls");

' Create an instance of the class that exports Excel file, having two sheets
Dim workbook As New ExcelDocument(2)

' Set encryption algorithm and password
workbook.easy_getOptions().setEncryptionOptions(EasyXLS.Constants.Encrypt.ENCRYPTION_WEAK_XOR, "password")

' Create Excel file
workbook.easy_WriteXLSFile("C:\\Samples\\Encrypted Excel.xls")

C++
// Create an instance of the class that exports Excel file
EasyXLS::IExcelDocumentPtr workbook;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelDocument),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelDocument),
		      (void**) &workbook);

// Set encryption algorithm and password
workbook->easy_getOptions()->setEncryptionOptions(ENCRYPT_ENCRYPTION_WEAK_XOR, 
						  "password");

// Create Excel file
workbook->easy_WriteXLSFile("C:\\Samples\\Encrypted Excel.xls");


C++.NET

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument ^workbook = gcnew ExcelDocument(2);
	    
// Set encryption algorithm and password
workbook->easy_getOptions()->setEncryptionOptions(
	  EasyXLS::Constants::Encrypt::ENCRYPTION_WEAK_XOR, "password");

// Create Excel file
workbook->easy_WriteXLSFile("C:\\Samples\\Encrypted Excel.xls");

// Create an instance of the class that exports Excel file, having two sheets
ExcelDocument workbook = new ExcelDocument(2);

// Set encryption algorithm and password 
workbook.easy_getOptions().setEncryptionOptions(EasyXLS.Constants.Encrypt.ENCRYPTION_WEAK_XOR, "password");

// Create Excel file
workbook.easy_WriteXLSFile("C:\\Samples\\Encrypted Excel.xls");

.NET:

// Create an instance of the class that exports Excel file
$workbook = new COM("EasyXLS.ExcelDocument");

// Set encryption algorithm and password
$workbook->easy_getOptions()->setEncryptionOptions($ENCRYPTION_WEAK_XOR, "password");

// Create Excel file
$workbook->easy_WriteXLSFile("C:\Samples\Encrypted Excel.xls");


Java:

// Create an instance of the class that exports Excel file
$workbook = new java("EasyXLS.ExcelDocument");

// Set encryption algorithm and password
$workbook->easy_getOptions()->setEncryptionOptions($ENCRYPTION_WEAK_XOR, "password");

// Create Excel file
$workbook->easy_WriteXLSFile("C:\Samples\Encrypted Excel.xls");

' Create an instance of the class that exports Excel file
set workbook = Server.CreateObject("EasyXLS.ExcelDocument")

' Set encryption algorithm and password
workbook.easy_getOptions().setEncryptionOptions ENCRYPTION_WEAK_XOR, "password"

' Create Excel file
workbook.easy_WriteXLSFile("C:\Samples\Encrypted Excel.xls")

' Create an instance of the class that exports Excel file
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Set encryption algorithm and password
workbook.easy_getOptions().setEncryptionOptions Encrypt.ENCRYPTION_WEAK_XOR, "password"

' Create Excel file
workbook.easy_WriteXLSFile ("C:\Samples\Encrypted Excel.xls")

' Create an instance of the class that exports Excel file
Set workbook = CreateObject("EasyXLS.ExcelDocument")

' Set encryption algorithm and password
workbook.easy_getOptions().setEncryptionOptions ENCRYPTION_WEAK_XOR, "password"

' Create Excel file
workbook.easy_WriteXLSFile("C:\Samples\Encrypted Excel.xls")

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

<!-- Set encryption algorithm and password -->
<cfset workbook.easy_getOptions().setEncryptionOptions(Encrypt.ENCRYPTION_WEAK_XOR, "password")>

<!-- Create Excel file  -->
<cfset ret = workbook.easy_WriteXLSFile("C:\Samples\Encrypted Excel.xls")>

.NET:

# Create an instance of the class that exports Excel file, having two sheets
workbook = ExcelDocument(2)

# Set encryption algorithm and password
workbook.easy_getOptions().setEncryptionOptions(Encrypt.ENCRYPTION_WEAK_XOR, "password");

# Create Excel file
workbook.easy_WriteXLSFile("C:\\Samples\\Encrypted Excel.xls");


Java:

# Create an instance of the class that exports Excel file, having two sheets
workbook = gateway.jvm.ExcelDocument(2)

# Set encryption algorithm and password
workbook.easy_getOptions().setEncryptionOptions(gateway.jvm.Encrypt.ENCRYPTION_WEAK_XOR, "password");

# Create Excel file
workbook.easy_WriteXLSFile("C:\\Samples\\Encrypted Excel.xls");