Excel Create Datatable
======================

Category
--------
Excel Commands

Description
-----------

This command gets a range of cells and applies them against a dataset. Use this command when you want to quickly iterate over Excel as a dataset.

Parameters
----------

**Datatable Name**
	Indicate Datatable name to create.

**Excel File Path**
	Enter or Select the path to the Excel file.

**Sheet Name**
	Indicate the sheet name within the Excel file.

**Header Row**
	Indicate if the sheet has header row.



Returned Value
--------------
	This command does not have returned value.

Example Usage
-------------

	Example Location:  
		`BYpass\\Examples\\Excel Commands\\Excel Create Datatable\\Excel Create Datatable.xml`

See Also
--------
	- :doc:`Add Workbook <exceladdworkbook>`
	- :doc:`Add Worksheet <exceladdworksheet>`
	- :doc:`Append Cell <excelappendcell>`
	- :doc:`Append Row <excelappendrow>`
	- :doc:`Close Workbook <excelcloseworkbook>`
	- :doc:`Copy Worksheet <excelcopysheet>`
	- :doc:`Delete Cell <exceldeletecell>`
	- :doc:`Delete Row <exceldeleterow>`
	- :doc:`Export to PDF <excelexporttopdf>`
	- :doc:`Get Cell <excelgetcell>`
	- :doc:`Get Cell Style <excelgetcellstyle>`
	- :doc:`Get Last Column Index <excelgetlastcolumn>`
	- :doc:`Get Last Row Index <excelgetlastrow>`
	- :doc:`Get Range <excelgetrange >`
	- :doc:`Get Range As Datatable <excelgetrangeasdt>`
	- :doc:`Get Worksheets <excelgetworksheets>`
	- :doc:`Go To Cell <excelgotocell>`
	- :doc:`Insert Cell <excelinsertcell>`
	- :doc:`Lookup Range <excellookuprange>`
	- :doc:`Open Workbook <excelopenworkbook>`
	- :doc:`Remove Duplicate <excelremoveduplicate>`
	- :doc:`Run Macro <excelrunmacro>`
	- :doc:`Save Workbook <excelsave>`
	- :doc:`Save Workbook As <excelsaveas>`
	- :doc:`Set Range <excelsetcell>`
	- :doc:`Write Range <excelwriterange>`
	- :doc:`Write Row <excelwriterow>`