AppRobotic API Documentation
AppRobotic
API Class
API Methods
ActivateAddressBar Method
ActivateAppByProcessName Method
ActivateAppByWindowTitle Method
AddToSelection Method
ApplicationSetFocus Method
ButtonClick Method
CancelListeningForSynchInput Method
CaptureScreenshot Method
CheckboxToggle Method
ClearErrorLog Method
ClearPrinter Method
Click Method
ClipboardAppendText Method
ClipboardClear Method
ClipboardGetText Method
ClipboardSetText Method
Close Method
CloseActiveApp Method
CloseActiveDocument Method
CloseApplication Method
CloseCurrentApplication Method
Collapse Method
ComboBoxItemSelect Method
CreateGlobalVariable Method
CSVRead Method
DeleteFile Method
DeleteGlobalVariable Method
DoesProcessExist Method
DownloadAllEmailAttachments Method
DownloadNextEmailAttachments Method
DragAndDrop Method
EmailDelete Method
EmailSendAndReceive Method
ExcelColumnsCount Method
ExcelCreateFile Method
ExcelDeleteColumns Method
ExcelDeleteRows Method
ExcelInputFileClose Method
ExcelInputFileGoToNextRow Method
ExcelInputFileLoad Method
ExcelInputFileRead Method
ExcelInputFileWriteComments Method
ExcelInputFileWriteStatus Method
ExcelRead Method
ExcelRowsCount Method
ExcelSaveAsCSV Method
ExcelWrite Method
Exist Method
Expand Method
GetApplication Method
GetCurrentSelection Method
GetCurrentSupportedViews Method
GetCurrentVersion Method
GetDesktop Method
GetFileMD5Hash Method
GetItem Method
GetItemChild Method
GetItemDescendent Method
GetNextEmailID Method
GetTableColumnHeaderItems Method
GetTableColumnHeaders Method
GetTableRowHeaderItems Method
GetTableRowHeaders Method
GetText Method
GetUIItemText Method
GetValue Method
GetViewName Method
GoToClickablePoint Method
HyperlinkClick Method
ImageClick Method
ImageClickOffset Method
ImageDoubleClick Method
ImageDoubleClickOffset Method
ImageDragAndDrop Method
ImageDragAndDropOffset Method
ImageRightClick Method
ImageRightClickOffset Method
InsertAddonDesignerLine Method
IsAppLicensed Method
IsChecked Method
IsImageOnScreen Method
ItemSetFocus Method
LabelGetText Method
ListBoxItemDeselect Method
ListBoxItemMultiSelect Method
ListBoxItemSelect Method
Maximize Method
MenuItemClick Method
MessageBox Method
Minimize Method
MinimizeAll Method
MouseLeftClick Method
MouseLeftDoubleClick Method
MouseLeftDown Method
MouseLeftTripleClick Method
MouseLeftUp Method
MouseMiddleClick Method
MouseMiddleDoubleClick Method
MouseMiddleDown Method
MouseMiddleTripleClick Method
MouseMiddleUp Method
MouseMoveToImage Method
MouseMoveToImageOffset Method
MouseRightClick Method
MouseRightDoubleClick Method
MouseRightDown Method
MouseRightTripleClick Method
MouseRightUp Method
Move Method
MoveCursor Method
NavigateBack Method
NavigateForward Method
OCRGetText Method
OCRImageToPDF Method
OpenFile Method
OpenShortcuts Method
OpenStartMenu Method
OpenURL Method
OpenURLChrome Method
OpenURLChromePrivate Method
OpenURLEdge Method
OpenURLFirefox Method
OpenURLFirefoxPrivate Method
OpenURLIExplorer Method
OpenURLIExplorerPrivate Method
PlayMacro Method
PressAdd Method
PressAltD Method
PressAltF4 Method
PressAltLeftArrow Method
PressAltRightArrow Method
PressAltTab Method
PressBackspace Method
PressBreak Method
PressCapsLock Method
PressCtrlA Method
PressCtrlC Method
PressCtrlEsc Method
PressCtrlF Method
PressCtrlF4 Method
PressCtrlN Method
PressCtrlO Method
PressCtrlS Method
PressCtrlV Method
PressCtrlX Method
PressDelete Method
PressDivide Method
PressDownArrow Method
PressEnd Method
PressEnter Method
PressEquals Method
PressEscape Method
PressF11 Method
PressHome Method
PressInsert Method
PressLeftArrow Method
PressMultiply Method
PressNumLock Method
PressPageDown Method
PressPageUp Method
PressPrtScn Method
PressRightArrow Method
PressShiftF10 Method
PressSpacebar Method
PressSubtract Method
PressTab Method
PressUpArrow Method
Print Method
RadioButtonSelect Method
ReadAllEmailsToFile Method
ReadGlobalVariable Method
ReadNextEmailToFile Method
RealizeVirtualizedItem Method
RemoveFromSelection Method
Resize Method
Restore Method
Rotate Method
RunAddon Method
RunApplication Method
RunBot Method
RunPowershellCmdlet Method
RunPowershellCmdletWithOutput Method
RunPowershellScript Method
RunPowershellScriptWithOutput Method
RunSeleniumIDEScript Method
RunShellCommand Method
RunShellCommandWithOutput Method
ScreenshotAboveImage Method
ScreenshotBelowImage Method
ScreenshotLeftOfImage Method
ScreenshotOffsetFromImage Method
ScreenshotRightOfImage Method
ScreenshotScreenRegion Method
Scroll Method
ScrollHorizontally Method
ScrollIntoView Method
ScrollTextIntoView Method
ScrollVertically Method
Select Method
SelectText Method
SendEmail Method
SendEmailWithAttachment Method
SendKeys Method
SendKeysSend Method
SetCurrentView Method
SetDockPosition Method
SetFocus Method
SetRangeValue Method
SetScrollPercent Method
SetValue Method
ShowDesktop Method
StartListeningForSynchInput Method
SwitchApps Method
SwitchNextTab Method
SwitchPreviousTab Method
TerminateExcel Method
TerminateProcess Method
TextBoxGetText Method
TextBoxSetText Method
Toggle Method
TreeItemSelect Method
Type Method
UnselectText Method
UpdateGlobalVariable Method
Wait Method
WaitForInputIdle Method
Click or drag to resize

APIExcelRead Method

Reads the specified cell in the Excel file.

Namespace:  AppRobotic
Assembly:  AppRobotic (in AppRobotic.dll) Version: 15.21.3.21 (15.21.03.21)
Syntax
C#
Copy
public string ExcelRead(
	Object PathToExcelFile,
	Object SheetName,
	Object RowNumber,
	Object ColumnNumber,
	Object TextOrValue
)

Parameters

PathToExcelFile
Type: SystemObject
File path of the Excel file.
SheetName
Type: SystemObject
Specify either a blank ("") for 1st found Sheet in the Workbook by default, or the Sheet name.
RowNumber
Type: SystemObject
Row of cell to read.
ColumnNumber
Type: SystemObject
Column of cell to read.
TextOrValue
Type: SystemObject
Specify Text, Value, or Value2 to get those cell values. Default is Text.

Return Value

Type: String
Returns string containing the Excel cell contents or error message.
See Also