public static System.Data.DataSet ImportExcelData(ImportType importType, string fileName, bool firstRowContainsHeaders, string worksheetName, string startRange, string endRange) { string sql = String.Format(SELECT_SQL, "*", "[" + worksheetName + startRange + ":" + endRange + "]"); ExcelProperties properties = new ExcelProperties(firstRowContainsHeaders, true, importType == ImportType.CSV); return(ExcelUtility.Fill(fileName, sql, null, properties)); }
public static System.Data.DataSet ImportCSVData(string fileName, bool firstRowContainsHeaders) { string sql = String.Format(SELECT_SQL, "*", "[" + GetFileName(fileName) + "]"); ExcelProperties properties = new ExcelProperties(firstRowContainsHeaders, true, true); return(ExcelUtility.Fill(fileName, sql, null, properties)); }
public static System.Data.DataSet ImportExcelData(ImportType importType, string fileName, bool firstRowContainsHeaders, string worksheetName, string[] columns) { string selectColumns = string.Empty; for (int i = 0; i < columns.Length; i++) { if (i == 0) { selectColumns = columns[i]; } else { selectColumns += "," + columns[i]; } } if (selectColumns.Trim() == string.Empty) { selectColumns = "*"; } string sql = String.Format(SELECT_SQL, selectColumns, "[" + worksheetName + "]"); ExcelProperties properties = new ExcelProperties(firstRowContainsHeaders, true, importType == ImportType.CSV); return(ExcelUtility.Fill(fileName, sql, null, properties)); }