Background

When you use the built-in Rapise Global Spreadsheet object on a computer that has a 64-bit version of Microsoft Excel 2013 (or later) installed you may get an error similar to:

Runtime error 3706, provider cannot be found. it may not be properly installed

As described in several Microsoft KB articles, this error will be because you don't have the correct 64-bit OLEDB Jet drivers installed.

Workaround

A simple workaround that doesn't involve installing any software is to simply use Excel files in the older 'xls' format instead of 'xlsx'. It uses a different approach for opening and works on both 32-bit and 64-bit versions of Office / Excel.

So the simplest workaround is to open a data file, save it in the 2003-compatible workbook format and change the path in the .js script from "

Solution

The second approach which actually fixes the underlying issue is to install the two missing Microsoft libraries:

  1. The Microsoft Access Database Engine 2010 Redistributable (x64)
    https://www.microsoft.com/en-us/download/details.aspx?id=13255
    (press "Download" and then tick checkbox next to AccessDatabaseEngine_x64.exe and then install it)

  2. The 2007 Office System Driver: Data Connectivity Components
    https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734
    Just download and install.
After installing both libraries, Rapise should then be able to open the .XLSX format files correctly.