Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.pads4.com/llms.txt

Use this file to discover all available pages before exploring further.

The Microsoft Excel provider in PADS4 allows you to connect to Excel files (Office 2010 and earlier) to retrieve data for real-time presentations.

​
Steps to Add or Modify a Microsoft Excel Connection

​
1. Start the Data Provider Wizard

  • Open the Data Provider Wizard in PADS4.
  • Follow the steps for Adding a Data Provider or Editing a Data Provider.
  • Select Microsoft Excel as the provider type.

​
2. Configure Connection Settings

  • Specify the Location of the Excel File
    • Option 1: Use PADS4 Content Library (Recommended)
      • The content library automatically synchronizes files across all computers in the PADS4 system.
    • Option 2: Use a File Outside the Content Library
      • If you select this option, you must manually distribute the Excel file to ensure it is available for all PADS4 Viewers.
  • Select the File
    • Click Browse to locate the Excel file.
  • Enable “First Row Contains Column Information”
    • If your Excel sheet includes column headers, turn on this option to remove the first row from your dataset.
Click Next to continue.

​
3. Select the Excel Sheet to Connect To

  • PADS4 automatically detects all available sheets in the Excel file.
  • Click the drop-down box and select the desired sheet.
Click Next to continue.

​
4. Complete the Setup

  • Follow the remaining steps in the Data Provider Wizard.
  • Click Finish to finalize the setup.

​
Additional Notes

  • Using a PADS4 Data Server?
    • Ensure that Office System drivers are installed on the PADS4 Server.
    • The Excel file location must be accessible from the Data Server’s point of view.
  • Not Using a PADS4 Data Server?
    • Make sure PADS4 Designer (for previewing) and all PADS4 Viewers have:
      • The Office System drivers installed.
      • Access to the specified Excel file location.
  • Avoid Shared Network Folders
    • Referencing an Excel file in a shared network folder may cause:
      • High network traffic when refreshing data.
      • File locking issues if multiple users access the file simultaneously.
  • Automatic File Copying
    • PADS4 creates an internal copy of the Excel file before reading the data.
    • This prevents file locking conflicts and ensures smooth data retrieval.