xls_link
xls_link
>> xls_link
xls_link
xls_AddWorkbook
—
Creates a new workbook
xls_AddWorksheet
—
Creates a new worksheet
xls_CalculateRange
—
calculate a excel range
xls_CallMacro
—
Call an Excel macro.
xls_Close
—
Close the workbook.
xls_CopyDataRange
—
Copy data between ranges
xls_DeleteWorksheet
—
Delete current worksheet
xls_DisplayAlerts
—
Set show alerts setting.
xls_ExtendRange
—
Change dimension of an Excel range.
xls_GetColor
—
Get color of a range.
xls_GetData
—
Get range data.
xls_GetDfltSaveFmt
—
Get Excel save format.
xls_GetFont
—
Get range font property.
xls_GetRange
—
Get range information.
xls_GetWorksheetName
—
Get current worksheet name.
xls_IsExcelRunning
—
Is Excel running.
xls_NewExcel
—
Open new Excel.
xls_OffsetRange
—
Add offset to a range.
xls_Open
—
Open an Excel file.
xls_Protect
—
Protect Excel file.
xls_Quit
—
Close Excel.
xls_RecoverExcel
—
Reconnect an existing Excel.
xls_Save
—
Save workbook.
xls_SaveAs
—
Save workbook.
xls_SelectRange
—
Select a range.
xls_SetColor
—
Set color of a range.
xls_SetData
—
Set range data.
xls_SetDfltSaveFmt
—
Set Excel save format.
xls_SetFont
—
Set font properties.
xls_SetPic
—
Add picture to a cell.
xls_SetSave
—
Force save status.
xls_SetVisible
—
Show/hide Excel window.
xls_SetWorksheet
—
Active a specific sheet.
xls_SetWorksheetName
—
Set Active worksheet name.
xls_ShowGrid
—
Show/hide sheet grid.
xls_UnProtect
—
Unprotect Excel file.
xls_Undo
—
Undo last change done manually.
Report an issue
xls_link