We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Failed to open Excel 2007 file in version V8.103

Thread ID:

Created:

Updated:

Platform:

Replies:

131105 Jun 20,2017 04:10 PM Jun 29,2017 03:01 AM ASP.NET Web Forms 9
loading
Tags: XlsIO
vivian
Asked On June 20, 2017 04:10 PM

I am able to create Excel 2007 in version V8.103, but  failed to open the created file, it said "the method or operation is not implemented "

Abirami Varadharajan [Syncfusion]
Replied On June 21, 2017 05:45 AM

Hi Vivian, 
 
Thank you for contacting Syncfusion support. 
 
We are unable to reproduce issue from the shared information. We suggest you to upgrade to our latest version (15.2.0.43) of Essential Studio which has more bug fixes and enhancements which is available for download under the following link. 
 
 
If the issue still persists after upgrading, please share us the code snippet along with the input and output Excel documents which will be helpful for us to investigate further on this.  
 
Regards, 
Abirami. 


vivian
Replied On June 21, 2017 02:48 PM

Actually I can open the Excel file, but if I make some changes on  file and save it, failed to open it .


I used this code to create Excel:

myWorkbook.SaveAs("myFile.xlsx", ExcelSaveType.SaveAsXLS, objResponse, ExcelHttpContentType.Excel2007)

and this one to open excel:

               Dim excelEngine As New ExcelEngine()
            Dim application As IApplication = excelEngine.Excel
            application.DefaultVersion = ExcelVersion.Excel2007
      Dim myWorkbook As IWorkbook = Nothing
 myWorkbook = excelEngine.Excel.Workbooks.Open("myFile.xlsx", ExcelVersion.Excel2007)




Abirami Varadharajan [Syncfusion]
Replied On June 22, 2017 07:18 AM

Hi Vivian, 
 
We are unable to reproduce the issue. We request you to share us the Excel file created using XlsIO which you are trying to open along with details or code snippet for the changes which you are performing after opening the Excel file. This will be helpful for us to investigate further and provide you a prompt solution at the earliest.  
 
Regards, 
Abirami. 


vivian
Replied On June 22, 2017 09:43 AM

Please see the attached Excel files.


I created my template file in Excel 2016, open the template file in XISIO  and generated  the "original.xlsx" by XlsIO  and  I can open it with the following code, then I make some changes base on this file with Excel 2016(not using XISIO), save it as "modified.xlsx" but can't open it in XISIO with the same code.

    Dim excelEngine As New ExcelEngine()
            Dim application As IApplication = excelEngine.Excel
            application.DefaultVersion = ExcelVersion.Excel2007
      Dim myWorkbook As IWorkbook = Nothing
 myWorkbook = excelEngine.Excel.Workbooks.Open("myFile.xlsx", ExcelVersion.Excel2007)


Attachment: excel_files_ddd9347a.zip

Abirami Varadharajan [Syncfusion]
Replied On June 23, 2017 01:28 AM

Hi Vivian, 
 
Thank you for updating us. 
 
We are able to reproduce the reported issue in version 8.1v. However, the issue is resolved with our release version 8.4v. As suggested earlier, we request you to upgrade to our latest version (15.2.0.43) of Essential Studio which has more bug fixes and enhancements which is available for download under the following link.  
  
 
Please let us know if you have any concerns. 
 
Regards, 
Abirami.

vivian
Replied On June 27, 2017 05:19 PM

I download V8.4, but get the error when adding it to my project:

Error 2 Could not load file or assembly 'Syncfusion.Compression.Base' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.  

how to resolve it?


Abirami Varadharajan [Syncfusion]
Replied On June 28, 2017 08:51 AM

Hi Vivian, 
 

While deploying an application that references Syncfusion Essential XlsIO assembly, the following dependencies must be included in the project. 

 

  1. Syncfusion.Core.dll

 

  1. Syncfusion.Compression.dll

 

  1. Syncfusion.XlsIO.Base.dll

 

We suspect that the issue might be raised due to reference of improper assemblies. So, try to build the application after deleting bin and obj folders of the project.  

 

Please refer below link for installing an uninstalling assemblies from GAC. 
 
https://help.syncfusion.com/common/essential-studio/utilities#assembly-manager 

 

We also request you to add the above listed assemblies whose framework version should be same as that of the visual studio’s target framework version. For an example, 4.0 target version of visual studio should refer an assembly version of 8.404.0.10. 

 
Regards, 
Abirami. 


vivian
Replied On June 28, 2017 03:39 PM

All issues have been resolved, thank you Abirami.


Abirami Varadharajan [Syncfusion]
Replied On June 29, 2017 03:01 AM

Hi Vivian, 

Thank you for updating us. 

We are glad that the issue is resolved at your end. Please let us know if you need any further assistance. 

Regards, 
Abirami. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;