piper.xl.WorkBook.add_sql_sheet¶
-
WorkBook.add_sql_sheet(sheet_name=None, sql=None)[source]¶ Add worksheet containing SQL statement(s) used
- Parameters
sheet_name – The name of the sheet. Defaults to main sheet name prefixed with underscore. E.g. if main sheet is ‘sheet1’, sql sheet name will be ‘_sheet1’
sql – The SQL code to be stored within the sheet.
- Returns
worksheet reference
- Return type
ws