Your Excel Klip is not displaying any data.
This article includes the following sections. Be sure to go through the Basic Requirements and General Tips for Excel Klip Development sections first:
---------------- Basic Requirements ----------------
Double-check to make sure that all of the following requirements are met:
- The Excel workbook file is located on a local or network drive, not on a web server.
- You can access the workbook file from your computer.
Open the file in Windows Explorer to ensure that you are able to access the file.
- The workbook file is either closed by all users or shared.
While an Excel file is opened, it is locked and prevents others from gaining full access. Make sure that the file is closed, or change its settings to make it a shared workbook.
Excel 2007: check the Microsoft Support site.
Excel 2003: check the Microsoft Support site.
- The Excel file is saved with the XLSX or XLS extensions.
Klipfolio Dashboard version 5.3 supports Excel workbooks with the XLS and XLSX file extensions; version 5.2 supported only XLS. If you are using MS Office 2003 or earlier and the Klip needs to access a file created in Excel 2007, be sure to save the Excel file in Excel 97-2003 format by clicking the Office button > Save As > Excel 97-2003 Workbook. See the Microsoft Support page for details.
- You have Excel 2007 installed on your computer if your Klip is to load data from a file with the XLSX extension.
Klipfolio Dashboard accesses the XLSX file using the Excel driver that is installed with Microsoft Excel 2007. This driver from Microsoft also includes support for XLS files; therefore, if you have Excel 2007 on your machine, your Klip can access files with either of these extensions (as long as you are running it in Klipfolio Dashboard version 5.3 or above).
If you are using Excel 2003 or earlier with Microsoft's Office 2007 compatibility pack, note that this driver runs only when your Excel software is running; therefore, even with this pack installed, your Excel Klip cannot access an XLSX file unless Excel is also launched.
- You are running Klipfolio Dashboard version 5.2 or later.
The Excel support was introduced in version 5.2. If you are running an earlier version, be sure to upgrade to the latest version.
---------------- General Tips for Excel Klip Development ----------------
Do you have multiple Excel Klip users? Are some users able to display the data in the Klip but not others?
- If the file is located on a shared network drive, use the actual name of the drive, not the drive letter which can differ depending on the user's computer setup. For example, use \server\share\example.xls, not Y:\share\example.xls.
- Check to make sure that every user has access to the Excel file from his or her computer before trying the Klip. If the computer has no access to the file, Klipfolio Dashboard cannot access it, either.
Is data from the worksheet being displayed in the Klip except for the first row?
- Don't forget to include the header row from the worksheet in your Klip's Excel range. For example, in order to include the "Sales and marketing" row in the following worksheet, your range must include row 5 (e.g. B5:G12):
Are you fairly certain that your file, sheet and range settings are correct, but still no data is displayed in the Klip?
- Is the <style> block using the alphabetical column headings? For an Excel Klip, you must use the column headings, such as A, B and C.
- Did you define the row at the bottom of the <style> block?
---------------- Troubleshooting a Klip that uses JavaScript (<klipscript>) to specify content source ----------------
When in doubt, output script errors in the Debug Window by using the Engines.Excel.lasterror property. They are usually quite descriptive and provide clear clues about the problems.
In addition, here are some of the commonly asked questions when no data is displayed in the Klip.
- Why can't my Klip open the Excel file?
- Make sure you are escaping the backslashes in the file path. For example, use C:\\temp\\example.xls, not C:\temp\example.xls; use \\server\\share\\example.xls, not \server\share\example.xls.
- Be sure to include the full path to the file, including the file name and the .xls or .xlsx extension.
Engines.Excel.open( "C:\\temp\\example.xls", "2009", "B5:G12" ); ---------------- Troubleshooting a Klip that uses XML (<contentsource>) to specify content source ----------------
After going through the Basic Requirements and General Tips above, double-check the following if the Klip isn't displaying any data:
<html>
<contentsource>
<excel>
<file>C:\temp\example.xls</file>
<sheet>2009</sheet>
<range>B5:G12</range>
</excel>
</contentsource>
</html>- Are you fairly certain that you have followed all the requirements, yet still no data is being displayed?
- At this point, try using <klipscript> to set the content source instead of <contentsource> by following the instructions in the Excel Klip article's "3. Using JavaScript to specify content source" section. It gives you access to error messages that are not accessible through a Klip that uses <contentsource>.
