+ Post New Thread
Results 1 to 4 of 4
Home Access Plus+ Thread, Error previewing Excel Files in Projects:; This is a new install and I have managed to get it working very well with one exception. I am ...
  1. #1

    Join Date
    Aug 2011
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Error previewing Excel Files

    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.I nvoke(Object instance, Object[] inputs, Object[]& outputs)
    at System.ServiceModel.Dispatcher.DispatchOperationRu ntime.InvokeBegin(MessageRpc& rpc)
    at System.ServiceModel.Dispatcher.ImmutableDispatchRu ntime.ProcessMessage5(MessageRpc& rpc)
    at System.ServiceModel.Dispatcher.ImmutableDispatchRu ntime.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.I nvoke(Object instance, Object[] inputs, Object[]& outputs)
    at System.ServiceModel.Dispatcher.DispatchOperationRu ntime.InvokeBegin(MessageRpc& rpc)
    at System.ServiceModel.Dispatcher.ImmutableDispatchRu ntime.ProcessMessage5(MessageRpc& rpc)
    at System.ServiceModel.Dispatcher.ImmutableDispatchRu ntime.ProcessMessage31(MessageRpc& rpc)
    at System.ServiceModel.Dispatcher.MessageRpc.Process( Boolean isOperationContextSet)
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="Home Access Plus+" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-11-23T16:20:31.000000000Z" />
    <EventRecordID>2381</EventRecordID>
    <Channel>Application</Channel>
    <Computer>WEBACCESS.frsd.k12.nj.us</Computer>
    <Security />
    </System>
    <EventData>
    <Data>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.I nvoke(Object instance, Object[] inputs, Object[]&amp; outputs)
    at System.ServiceModel.Dispatcher.DispatchOperationRu ntime.InvokeBegin(MessageRpc&amp; rpc)
    at System.ServiceModel.Dispatcher.ImmutableDispatchRu ntime.ProcessMessage5(MessageRpc&amp; rpc)
    at System.ServiceModel.Dispatcher.ImmutableDispatchRu ntime.ProcessMessage31(MessageRpc&amp; 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.I nvoke(Object instance, Object[] inputs, Object[]&amp; outputs)
    at System.ServiceModel.Dispatcher.DispatchOperationRu ntime.InvokeBegin(MessageRpc&amp; rpc)
    at System.ServiceModel.Dispatcher.ImmutableDispatchRu ntime.ProcessMessage5(MessageRpc&amp; rpc)
    at System.ServiceModel.Dispatcher.ImmutableDispatchRu ntime.ProcessMessage31(MessageRpc&amp; rpc)
    at System.ServiceModel.Dispatcher.MessageRpc.Process( Boolean isOperationContextSet)</Data>
    </EventData>
    </Event>

  2. #2
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,486
    Thank Post
    37
    Thanked 490 Times in 422 Posts
    Rep Power
    110

  3. #3

    Join Date
    Aug 2011
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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.

  4. #4
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,486
    Thank Post
    37
    Thanked 490 Times in 422 Posts
    Rep Power
    110
    you can delete it

SHARE:
+ Post New Thread

Similar Threads

  1. VB Script - saving an excel file?
    By Rawns in forum Coding
    Replies: 11
    Last Post: 17th July 2009, 10:44 AM
  2. [MS Office - 2007] The curious case of the 0-byte Excel file
    By AngryTechnician in forum Office Software
    Replies: 6
    Last Post: 24th February 2009, 06:09 PM
  3. Corrupt Excel file
    By googlemad in forum Office Software
    Replies: 6
    Last Post: 2nd August 2008, 12:05 AM
  4. Corrupt Word/Excel files
    By ind13 in forum Office Software
    Replies: 5
    Last Post: 6th June 2008, 02:03 PM
  5. Preview PSD files
    By ZeroHour in forum Windows
    Replies: 0
    Last Post: 4th July 2006, 01:50 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •