From_Excel_To_DataTable
Description
Converts a range of cells in an Excel workbook to a DataTable.
Additional Info
Culture InArgument<CultureInfo>
Provides access to the culture-specific settings of the spreadsheet.
Encoding InArgument<Encoding>
The text encoding to be used to interpret the file if it is in CSV or TXT format. If no encoding is specified, then DocsMarshal will auto-detect the encoding based on content.
DataTable
CellFormats InArgument<Dictionary<Int32,ECellFormat>>
Provide a custom type for each column of the DataTable.
Input file
DocumentFormat DocumentFormat
Specifies in which format to read the source document.
File InArgument<IDmFile> REQUIRED
The excel file to convert.
Misc
Result OutArgument<DataTable>
Range
LeftColumnIndex InArgument<Int32?>
An integer that is the zero-based index of the left column.
RangeHasHeader InArgument<Boolean>
True, to use the content of the first row in a range as column names in a data table; otherwise, false.
RightColumnIndex InArgument<Int32?>
An integer that is the zero-based index of the right column.
TopRowIndex InArgument<Int32?>
An integer that is the zero-based index of the top row.
UseCurrentRegionForColumns InArgument<Boolean>
Automatically gets a range of cells surrounded by empty rows and columns in the given worksheet.
Worksheet
WorksheetName InArgument<String>
The name of the worksheet to convert.