sq.Environ |
sq.Error |
sq.Load |
sq.Name |
sq.Save |
Excel General
Schematiq environment
Azure connectivity
az.FetchSecret |
azTbl.ConnectCustom |
azTbl.ConnectMI |
azTbl.ConnectSas |
azTbl.ConnectSecret |
azTbl.DownloadTable |
User-defined functions
fn.Call |
fn.Connect |
fn.FixInput |
fn.FromSnippet |
fn.FromTemplate |
fn.FromWorkbook |
fn.RemoteCall |
fn.SetAsync |
Ranges
rng.ColumnCount |
rng.Create |
rng.ExportExcel |
rng.GetValue |
rng.GetValues |
rng.LeftToRight |
rng.RowCount |
rng.Sequence |
rng.Subset |
rng.TopToBottom |
rng.Transpose |
Excel
xl.Blank |
xl.CellAddress |
xl.CellFormula |
xl.Export |
xl.GetRange |
xl.InsertTable |
xl.Load |
xl.Save |
Web connectivity
web.BasicAuthLogin |
web.Content |
web.CustomRequest |
web.Delete |
web.Get |
web.Head |
web.Header |
web.MultiPartContent |
web.Page |
web.Patch |
web.Post |
web.Put |
web.Response |
Trees
tree.Add |
tree.Create |
tree.ExportJson |
tree.ExportXml |
tree.GetNames |
tree.GetNodes |
tree.GetValue |
tree.GetValues |
tree.ImportJson |
tree.ImportXml |
tree.NodeCount |
tree.Remove |
tree.Replace |
tree.Union |
Database connectivity
db.Commit |
db.Connect |
db.ConnectCustom |
db.Insert |
db.Query |
Tables
tbl.ColumnCount |
tbl.ColumnIndex |
tbl.ColumnName |
tbl.ColumnNames |
tbl.Connect |
tbl.Create |
tbl.Download |
tbl.ExportDelimited |
tbl.ExportExcel |
tbl.ExportJson |
tbl.Filter |
tbl.GetValue |
tbl.GetValues |
tbl.Group |
tbl.ImportDelimited |
tbl.ImportHtml |
tbl.ImportJson |
tbl.ImportXml |
tbl.Join |
tbl.Lookup |
tbl.Pack |
tbl.Pivot |
tbl.RenameColumns |
tbl.RowCount |
tbl.SelectColumns |
tbl.SelectRows |
tbl.Sort |
tbl.Structure |
tbl.Union |
tbl.Unpack |
tbl.Unpivot |
tbl.UpdateColumns |
Schematiq Server
svr.Connect |
svr.Evaluate |
Files and folders
file.ListFiles |
file.ListFolders |
file.Open |
file.OpenText |
file.Save |
file.SaveText |
file.Split |
file.UnzipSingleFile |
Dates and times
dt.ChangeTimeZone |
dt.FormatLocal |
dt.Offset |
dt.PeriodsBetween |
dt.Sequence |
dt.SequenceBetween |
Regular expressions
regex.Escape |
regex.IsMatch |
regex.Match |
regex.Matches |
regex.Replace |
regex.ReplaceEval |
regex.Split |
regex.Unescape |
Text
txt.Encrypt |
txt.Format |
txt.FromNumber |
txt.Join |
txt.Reverse |
txt.Split |