MSoffice version problem to read an excel file

Question

User671836881 posted

Hi Team,

I am trying to read the content of the excel binary file using LinqToExcel dll downloaded from nuget packages(LinqToExcel.1.11.0) and able to read the data from the file as well and do the required action in one PC.. But the problem is this solution is not working fine in my PC having this ASP.Net solution opened in VS2015 and this PC is having Windows 8 of 64 bit operating system and office 2016, the solution is throwing the error as below:

" This file was created in a previous beta version of Excel 2007. Open the file with Excel 2007 to save it to the most recent version of the Excel 2007 file format before opening the file in Access 2007." while in another system it is running fine .

Could you please let me know how to rectify this error. Do I need to install any version of office or any other alternatives. Please help me to resolve the issue.

Answer 1

User-707554951 posted

Hi Jyothirmayi

By default, some Open XML files that were saved in the prerelease versions of the 2007 Office programs cannot be opened by the Compatibility Pack for the 2007 Office system.
For solution, please refer to the following link:

https://support.microsoft.com/en-sg/help/926054/message-when-you-try-to-use-an-earlier-version-of-an-office-program-to

Best Regards

Cathy

Answer 2

User671836881 posted

The original file is created in Office 2007 but In my PC I am having Office 2016 though I have tried to install Spire.XLS and tried to read the Excel binary file content When I applied the above code snippet the following error is encountered. when trying to pass the .XLSB fiel as the input to the Spire.XLS and the error is as follows: "File format is not be supported"

Could you please provide me any help regarding this one.

Answer 3

User671836881 posted

Hi Cathy,

The original file is created in Office 2007 but In my PC I am having Office 2016. I don't see any options as provided in the Method 1 or Method 2 in my PC as p in the above provided link i.e. in https://support.microsoft.com/en-sg/help/926054/message-when-you-try-to-use-an-earlier-version-of-an-office-program-to.

AS In my PC Office 2016 I don't find any Office2007Converters.adm fiels in my PC as given in Method 1. And also I can't find out the following registry key in my PC HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Word\Security\FileOpenBlock . Instead it is as like this  HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\16.0\Excel\Security\requireaddinsig only this key is there as provided in Method 2.

But still the problem persists for me. Could you please help me out or suggest any other alternative..

Answer 4

User1166478518 posted

HI,

I was also facing the same issue and none of the options I googled helped me. Though I was using office 2017, I don't know why I am getting 2007 issue.
But I solved the problem by checking the compatibility mode of the binary excel file. If you save the file in compatibility mode, It will start working. It worked for me.

Thanks,