Developing secure products are as important as the product itself. Most security measures involve data encryption and passwords. Excel sheets are mostly used for reporting purposes and reports mostly based on confidential data, so security is very important for Excel based reports.
Here, I have tried to develop a small utility for a security implementation. The same code can be used in both Visual Studio 2003 and 2005, and the code can be implemented in C# with proper syntax changes.
Public Filename As String
Public oexcel As Excel.Application
Public obook As Excel.Workbook
Public osheet As Excel.Worksheet
Filename = AppDomain.CurrentDomain.BaseDirectory & _
If File.Exists(Filename) Then
If Not File.Exists(Filename) Then
oexcel = CreateObject("Excel.Application")
oexcel.Application.DisplayAlerts = False
obook = oexcel.Workbooks.Add
oexcel.Visible = True
Console.WriteLine("Generating Auto Report")
osheet = oexcel.Worksheets(1)
osheet.Name = "Test Sheet"
osheet.Range("A1").Value = "Implementing " & _
"Password Security on Excel " & _
"Workbook Using Studio.Net"
osheet.Range("A1").Font.Color = RGB(255, 255, 255)
osheet.Range("A1").Interior.ColorIndex = 5
osheet.Range("A1").Font.Bold = True
Dim password As String = "abc"
obook.Password = password
osheet = Nothing
obook = Nothing
oexcel = Nothing
Catch ex As Exception
Working With the Demo
Download the demo project and unzip it, and then run "Excel_Automation.exe". It will generate an Excel sheet in the same directory with the name "abc.xls". When you try to open the Excel sheet, it will ask to enter the password, enter "abc", then the book will be visible to you.
Working With the Code
Here, I have attached the VB.NET code file, download it and then create a new console application project, and add the file to that project, and try with your desired changes. You can run the same code in both versions of Visual Studio .NET.
This is a small effort to generate a secure report for your critical data. Any feedback/comments are welcomed.
I am currently based in Islamabad,Pakistan. I have done my MS Computer Science and I am involved in Microsoft Visual Studio.net Windows/Web application development since 2003 untill that i have been working in VB, ASP and web scripting languages. Currently i am working in ZonG as Team LEad IT Projects and Planing. I am also the administrator of Business Process