xlsread_easy

Reads specified sheet in a workbook, even if the worksheet is protected.

XLSREAD_EASY Reads specified sheet in a workbook, even if the worksheet is protected with a password.

XLSREAD_EASY(File_path,sheet_name,WB_Password) Reads a protected sheet in a cell array without unprotecting it. Alternative to xlsread when sheets are protected.

Inputs:

(1) full_file_path -> Full file path of the Excel file

(2) sheet_name -> Valid Worksheet Name

(3) WB_Password -> Workbook password, if any

Note: Works only for XLSX and XLS file types. Please modify as needed.