Excel Add-In for xBase

Build 23.0.8770

Using the Excel Add-In

After Establishing a Connection, you can work with data from xBase from familiar tools in Excel.

Query Data

Click Edit Query from the ribbon to edit your query and pull data into the sheet and click Refresh Worksheet to refresh the sheet to pull in the latest changes. See Querying Data for a guide.

Using the Excel Add-In (VBA)

Write macros to automate working with xBase. See Using the Excel Add-In (VBA) for a guide.

Writing Parameterized Queries

Create spreadsheets based on dynamic queries that use cell references as the input parameters. See Writing Parameterized Queries for examples.

CData Excel Formulas

Automate operations using the corresponding formulas. See CData Excel Functions for a guide.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770