Name
xlsx.SetDefaultSheet -- set default worksheet
Synopsis
xlsx.SetDefaultSheet(id, idx)
Function
This function can be used to set the default worksheet for the XLSX document specified by id. An XLSX document's default worksheet is the worksheet that is to be used in case no worksheet is explicitly specified when calling functions like xlsx.SetCellValue() or xlsx.GetCellValue(). You need to pass the position of the desired default worksheet in the idx argument. Worksheet indices start at 1 for the first worksheet.

By default, the first worksheet in the XLSX document is the default worksheet.

Inputs
id
identifier of the XLSX document to use
idx
position of the worksheet that should be made the default (starting from 1)

Show TOC