Knowledge Base Article

Home Page > Knowledge Base > Rapise

Home Page > Knowledge Base > Rapise > Rapise Desktop

Home Page > Knowledge Base > Rapise > Rapise Mobile

Home Page > Knowledge Base > Rapise > Rapise Web

Article Error attaching to Excel spreadsheet when using Rapise 4.0 with MS-Excel 64-bit

by Adam S on Thursday, March 24, 2016

When you are using the global Rapise Spreadsheet object on a system running the 64-bit version of MS-Office, you may get an error attaching to the spreadsheet. This article describes the cause of the issue and provides a solution and workaround.

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 ".xls" to ".xlsx"

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.

Attachments
Article Info
Last Updated: 3/24/2016
Article ID: KB201
# Views: 537
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.