Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
.saveResults
'Format=Excel2007,
Source=Grid,
File="/Users/nhilam/bistudio.xlsx",
Overwrite=true,
IncludeChart=true,
IncludeHeader=true,
IncludeNullText=true,
IncludeRowCount=false,
IncludeSQL=true,
AlternateRow=true,
AlternateRowBackground=#999999,
AlternateRowForeground=#000000'
The above command will insert the SQL statement at the top of the worksheet, before the data.
We will add a new parameter "IncludeSQLAtEnd", default = false.
If IncludeSQLAtEnd=true, regardless of IncludeSQL, then the SQL statement will be written at the end of the worksheet.
If IncludeSQLAtEnd=false, then the original IncludeSQL will dictate whether or not to write the SQL statement at the beginning of the worksheet.
Customer added the following: "Can we also have an option to name a tab in the sheet in the function? So that when you run a few Queries and have them come in a one book you could name the sheets. Too? "
As part of this issue, we will also consider the ability to name the tab in the excel workbook.
As part of this issue, we will also consider the ability to name the tab in the excel workbook.
Issue #15447 |
| New |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Customer added the following: "Can we also have an option to name a tab in the sheet in the function? So that when you run a few Queries and have them come in a one book you could name the sheets. Too? "