Exporting sheets from Excel documents

Skip to end of metadata
Go to start of metadata

Table of Contents

Overview

The testData API of Squish only supports reading the first sheet from Excel documents.

However, the following external tool (export_xls_sheet, based on Python 2.6 (or higher) and the xlrd and xlwt modules) can be used to export every desired sheet into a separate Excel document, so that it can then be read via the testData API.

General usage of export_xls_sheet

The sheet_index for the first sheet is 0.

Using export_xls_sheet with JavaScript test scripts

test.js

Using export_xls_sheet with Python test scripts

test.py

Related Information

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.