JDBC Driver for Microsoft Excel Online

Build 22.0.8462

Worksheets

Retrieve a list of worksheet objects. If listing sheets in a workbook which do not belong to the user's drive, please specify the drive id using the Drive connection property.

Columns

Name Type References Description
Id [KEY] String Returns a value that uniquely identifies the worksheet in a given workbook. The value of the identifier remains the same even when the worksheet is renamed or moved.
WorkbookId String

Workbooks.Id

The Id of the workbook containing this worksheet.
Name String The display name of the worksheet.
Position Integer The zero-based position of the worksheet within the workbook.
Visibility String The visibility of the worksheet. Possible values are: Visible, Hidden, VeryHidden.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462