Insert Cell =========== Category -------- Excel Commands Description ----------- This command allows you to insert a specified cell in Excel. Use this command when you want to insert a specific cell from the current sheet. Parameters ---------- **Instance Name** Enter the instance name to indicate the selected workbook **Sheet Name** Indicate the name of the sheet within the Workbook to activate **Range** Indicate the range to insert (ex. A1 or A1:C1) **Shift Direction** Choose how the cells below shift after insert - Down: insert value and shift cells down - Right: insert value and shift cells right - Entire row: insert value entire row - Entire column: insert value entire column Returned Value -------------- This command does not have returned value. Example Usage ------------- Example Location: `BYpass\\Examples\\Excel Commands\\Insert Cell\\Insert Cell.xml` See Also -------- - :doc:`Add Workbook ` - :doc:`Add Worksheet ` - :doc:`Append Cell ` - :doc:`Append Row ` - :doc:`Close Workbook ` - :doc:`Copy Worksheet ` - :doc:`Delete Cell ` - :doc:`Delete Row ` - :doc:`Excel Create Datatable ` - :doc:`Export to PDF ` - :doc:`Get Cell ` - :doc:`Get Cell Style ` - :doc:`Get Last Column Index ` - :doc:`Get Last Row Index ` - :doc:`Get Range ` - :doc:`Get Range As Datatable ` - :doc:`Get Worksheets ` - :doc:`Go To Cell ` - :doc:`Lookup Range ` - :doc:`Open Workbook ` - :doc:`Remove Duplicate ` - :doc:`Run Macro ` - :doc:`Save Workbook ` - :doc:`Save Workbook As ` - :doc:`Set Range ` - :doc:`Write Range ` - :doc:`Write Row `