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.