Ok, all I did was copy the DLL into my ASP.net 3.5, c# project and ran the following code.
using (ExcelPackage package = new ExcelPackage(existingFile))
ReturnTable = new DataTable("ExcelTabs");
foreach (ExcelWorksheet Worksheet in package.Workbook.Worksheets)
DataRow row = ReturnTable.NewRow();
row = Worksheet.Name;
It gives me the following error:
"Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=22.214.171.124, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed."
On the line "using (ExcelPackage package = new ExcelPackage(existingFile))".
The "existingFile" is pointing to a tempFiles folder under the website main folder. I have given full rights to the "network service" and "ASP.Net" accounts for the whole website, including that folder. Any ideas?