Error Messages/49780
Error Message
- Error during SpreadsheetOpen(...): Excel not installed on this computer.
- If you really don't have Excel installed, consider using
SpreadsheetOpen(..., backend:'LibXl')instead. - If you do have Excel installed and want its calculation engine, you probably didn't include the COM API option when you installed it. Rerun its installer and enable that option.
Description
By default, SpreadsheetOpen attempts to open the requested spreadsheet file in Microsoft Excel, which must be installed on your computer for this to work. If you don't have Excel installed, Analytica provides another option that allows you to open it without anything extra installed. This option uses LibXL as the backend. To select it you just specify the backend explicity:
SpreadsheetOpen( "myFile.xlsx", backend:'LibXl' )
LibXL does not provide a calculation engine, but it can read the values that were there at the time the spreadsheet was saved. So if your goal is just to read the values in an existing spreadsheet, or to add data to a spreadsheet, without a need to recalculate cells after changing inputs, then LibXl will suffice.
But I DO have Excel installed!
When you install Excel, buried deep in the optional features is a setting controlling whether to install the Excel COM API. Since this is what Analytica uses to communicate with Excel, it won't work unless you installed with that option turned on. The remedy is to re-run the Excel installer, find that option, and let the installer add that option to your installation.
Enable comment auto-refresher