Could not load file or assembly ‘Office, Version=’

I also got this error message even if I have Office 2010 and I don’t have Microsoft.Office.Interop.Excel folder under GAC. I found the solution for my case here: You have to reference two dll-files from these folders: C:\Windows\assembly\GAC_MSIL\Microsoft.Vbe.Interop\\Microsoft.Office.Interop.Excel.dll and C:\Windows\assembly\GAC_MSIL\office\\OFFICE.DLL

Text was truncated or one or more characters had no match in the target code page When importing from Excel file

I assume you’re trying to import this using an Excel Source in the SSIS dialog? If so, the problem is probably that SSIS samples some number of rows at the beginning of your spreadsheet when it creates the Excel source. If on the [ShortDescription] column it doesn’t notice anything too large, it will default to … Read more

Reading Excel file using node.js

There are a few different libraries doing parsing of Excel files (.xlsx). I will list two projects I find interesting and worth looking into. Node-xlsx Excel parser and builder. It’s kind of a wrapper for a popular project JS-XLSX, which is a pure javascript implementation from the Office Open XML spec. node-xlsx project page Example … Read more

Reading an Excel file in PHP [closed]

You have 2 choices as far as I know: Spreadsheet_Excel_Reader, which knows the Office 2003 binary format PHPExcel, which knows both Office 2003 as well as Excel 2007 (XML). (Follow the link, and you’ll see they upgraded this library to PHPSpreadSheet) PHPExcel uses Spreadsheet_Excel_Reader for the Office 2003 format. Update: I once had to read … Read more

Excel “External table is not in the expected format.”

“External table is not in the expected format.” typically occurs when trying to use an Excel 2007 file with a connection string that uses: Microsoft.Jet.OLEDB.4.0 and Extended Properties=Excel 8.0 Using the following connection string seems to fix most problems. public static string path = @”C:\src\RedirectApplication\RedirectApplication\301s.xlsx”; public static string connStr = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” + path + … Read more