10/24/2017 - 1:16 PM


 // For complete examples and data files, please go to
 DocumentTableOptions options = new DocumentTableOptions();
options.FirstRowContainsColumnNames = true;
// Use data of the _first_ worksheet.
DocumentTable table = new DocumentTable(excelDataFile, 0, options);
// Check column count, names, and types.
Debug.Assert(table.Columns.Count == 3);
Debug.Assert(table.Columns[0].Name == "Client");
Debug.Assert(table.Columns[0].Type == typeof(string));
Debug.Assert(table.Columns[1].Name == "Manager");
Debug.Assert(table.Columns[1].Type == typeof(string));
// NOTE: A space is replaced with an underscore, because spaces are not allowed in column names.
Debug.Assert(table.Columns[2].Name == "Contract_Price");
// NOTE: The type of the column is double, because all cells in the column contain numeric values.
Debug.Assert(table.Columns[2].Type == typeof(double));
return table;