The best way is connect to the Excel as it was a database (using OLEDB)...
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=excel_file_path;Password=password;Extended Properties=\"Excel 12.0;IMEX=0\"");
If you want to use it as Excel file you can use the Password property of the WorkbookObject object:
https://msdn.microsoft.com/en-us/library/office/ff821529.aspx[
^]