Thursday, May 7, 2015

excelreaderfactory.cs file not found

hey, yes it is the same case. But how do I catch unhandled excepted for this case.

bharathi

 public DataTable ExcelToDataTable(string fileName)
        {
            try
            {

                //open a file and returns a stream
                FileStream stream = File.Open(fileName, FileMode.Open, FileAccess.Read);

                //createxmlreader via xmlreaderfactory 
                IExcelDataReader excelreader = ExcelReaderFactory.CreateOpenXmlReader(stream);

                //set the first row as column name

                excelreader.IsFirstRowAsColumnNames = true;

                //return as dataset

                DataSet result = excelreader.AsDataSet();

                //get all the tables

                DataTableCollection table = result.Tables;

                //store it in datatable

                DataTable resulttable = table["sheet1"];
                //return
                return resulttable;
            }
            catch (Exception ex) {
                Console.WriteLine(ex.Message);
            }
        }



Fouad Roumieh

No comments:

Post a Comment