Error previewing Excel Files

[tfuhrman]

This is a new install and I have managed to get it working very well with one exception. I am on the latest version of Home Access Plus (9.7). Server is 2008R2 running IIS 7.5. When attempting to preview an excel file, either .xls or .xlsx I get the following error and was hoping to get some help from these forums. I am able to preview .docx files without issue.

 

Log Name: Application

Source: Home Access Plus+

Date: 11/23/2013 11:20:31 AM

Event ID: 0

Task Category: None

Level: Error

Keywords: Classic

User: N/A

Computer: WEBACCESS.frsd.k12.nj.us

Description:

An error occurred in Home Access Plus+

 

Page: Excel

 

Could not load file or assembly 'ICSharpCode.SharpZipLib, Version=0.85.5.452, Culture=neutral, PublicKeyToken=1b03e6acf1164f73' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

 

 

System.IO.FileLoadException: Could not load file or assembly 'ICSharpCode.SharpZipLib, Version=0.85.5.452, Culture=neutral, PublicKeyToken=1b03e6acf1164f73' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

File name: 'ICSharpCode.SharpZipLib, Version=0.85.5.452, Culture=neutral, PublicKeyToken=1b03e6acf1164f73'

at Excel.Core.ZipWorker.Extract(Stream fileStream)

at Excel.ExcelOpenXmlReader.Initialize(Stream fileStream)

at HAP.MyFiles.API.Preview(String Drive, String Path)

at SyncInvokePreview(Object , Object[] , Object[] )

at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

 

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

 

 

 

at Excel.Core.ZipWorker.Extract(Stream fileStream)

at Excel.ExcelOpenXmlReader.Initialize(Stream fileStream)

at HAP.MyFiles.API.Preview(String Drive, String Path)

at SyncInvokePreview(Object , Object[] , Object[] )

at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

Event Xml:

0

2

0

0x80000000000000

2381

Application

WEBACCESS.frsd.k12.nj.us

An error occurred in Home Access Plus+

 

Page: Excel

 

Could not load file or assembly 'ICSharpCode.SharpZipLib, Version=0.85.5.452, Culture=neutral, PublicKeyToken=1b03e6acf1164f73' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

 

 

System.IO.FileLoadException: Could not load file or assembly 'ICSharpCode.SharpZipLib, Version=0.85.5.452, Culture=neutral, PublicKeyToken=1b03e6acf1164f73' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

File name: 'ICSharpCode.SharpZipLib, Version=0.85.5.452, Culture=neutral, PublicKeyToken=1b03e6acf1164f73'

at Excel.Core.ZipWorker.Extract(Stream fileStream)

at Excel.ExcelOpenXmlReader.Initialize(Stream fileStream)

at HAP.MyFiles.API.Preview(String Drive, String Path)

at SyncInvokePreview(Object , Object[] , Object[] )

at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

 

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

 

 

 

at Excel.Core.ZipWorker.Extract(Stream fileStream)

at Excel.ExcelOpenXmlReader.Initialize(Stream fileStream)

at HAP.MyFiles.API.Preview(String Drive, String Path)

at SyncInvokePreview(Object , Object[] , Object[] )

at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)

at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

[nickbro]

Bug found and fixed: https://hap.codeplex.com/releases/view/115304

[tfuhrman]

You're incredibly good! The fixed work.

 

I replaced the one .dll (HAP.MyFiles.dll) and ADDED the Excel.4.0.dll to the BIN folder. I am curious if the Excel.dll that already existed is still needed.

 

Thanks so much.

[nickbro]

you can delete it