Exemplo n.º 1
0
        public DataTable ConvertToDataTable(string fileName, string sheetName)
        {
            if (string.IsNullOrEmpty(sheetName))
            {
                sheetName = GetFirstSheetName(fileName);
            }

            DataTable table = ConvertToDataTableWithoutData(fileName, sheetName);

            //if (!ConfirmSheetNameOrGetFirstIfNull(fileName, ref sheetName))
            //{
            //    throw new DuradosException("Sheet name was not found in the Excel file!");
            //}

            ExcelHandler excelHandler = new ExcelHandler(fileName, sheetName);

            if (excelHandler.ReadDocument(table.Columns.Count, ref table))
            {
                excelHandler.Dispose();

                for (int i = 0; i < table.Columns.Count; i++)
                {
                    table.Columns[i].ColumnName = table.Rows[0][i].ToString();
                }
                table.Rows.RemoveAt(0); //...so i'm taking it out here.

                return(table);
            }

            throw new FileNotFoundException("Failed to convert Excel to data table");
        }
Exemplo n.º 2
0
        public void AddRow(string[] rowData)
        {
            switch (_dataResultType)
            {
            case DataResultType.DataTableType:
                while (_table.Columns.Count < rowData.Length)
                {
                    _table.Columns.Add(ExcelHandler.GetColumnName(_table.Columns.Count));
                }
                _table.Rows.Add(rowData);
                break;

            case DataResultType.ListType:
                _list.Add(rowData);
                break;

            default:
                throw new ArgumentOutOfRangeException("DataResult.DataResultType does not exist");
            }
        }