Breaking News: Grepper is joining You.com. Read the official announcement!

c# read excel file using epplus save to datatable

BlackSwan answered on May 6, 2022 Popularity 7/10 Helpfulness 2/10

answer c# read excel file using epplus save to datatable

related Convert DataTable to excel file c# using epplus

c# read excel file using epplus save to datatable

Comment

// Pass to param the excel file location (path)
public DataTable Read(string filePath)
        {
            try
            {
                DataTable dt = new DataTable();
                FileInfo excelFile = new FileInfo(filePath);
                ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
                using (var package = new ExcelPackage(excelFile))
                {
                    ExcelWorksheet workSheet = package.Workbook.Worksheets[0];
                    //add column header
                    foreach (var firstRC in workSheet.Cells[1, 1, 1, workSheet.Dimension.End.Column])
                    {
                        dt.Columns.Add(firstRC.Text);
                    }

                    // add rows
                    for (int rN = 2; rN <= workSheet.Dimension.End.Row; rN++)
                    {
                        ExcelRange row = workSheet.Cells[rN, 1, rN, workSheet.Dimension.End.Column];
                        DataRow newR = dt.NewRow();
                        foreach (var cell in row)
                        {
                            newR[cell.Start.Column - 1] = cell.Text;
                        }

                        dt.Rows.Add(newR);
                    }
                }

                return dt;
            }
            catch (Exception ex)
            {

                throw new Exception(ex.Message);
            }
        }

Popularity 7/10 Helpfulness 2/10 Language csharp

Source: Grepper

Tags: c# datatable epplus excel file save using

Link to this answer
Share Copy Link

Contributed on May 06 2022

BlackSwan

0 Answers Avg Quality 2/10

Closely Related Answers

Convert DataTable to excel file c# using epplus

Comment

 /// <summary>
        /// Convert DataTable to Excel File
        /// </summary>
        /// <param name="filePath">Excel FilePath</param>
        /// <param name="table">DataTable</param>
        /// <param name="fileName">Excel Filename</param>
        /// <returns></returns>
        public bool Write(string filePath, DataTable table, string fileName)
        {
            try
            {
                bool success = false;
                var today = Convert.ToDateTime(DateTime.Now).ToString("yyyyMMddHHmmss");
                //delete existing files
                // Util_Directory.DeleteFiles(filePath);
                var newDir = filePath + "\\" + today;
                //if dir not exist create
                Util_Directory.CreateDirectory(newDir);
                FileInfo file = new FileInfo(Path.Combine(newDir, fileName));
                ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
          
                using (var package = new ExcelPackage(file))
                {
                    var workSheet = package.Workbook.Worksheets.Add("Sheet1");
                    //add column headers
                    var columns = table.Columns.Cast<DataColumn>().Select(x => x.ColumnName).ToList();
                    int i = 1;
                    foreach (var column in columns)
                    {
                        workSheet.Cells[1, i].Value = column;
                        i++;
                    }

                    // add row values
                    int startRow = 2;
                    foreach (DataRow row in table.Rows)
                    {
                        int startColumn = 1;
                        foreach (var item in row.ItemArray)
                        {
                            workSheet.Cells[startRow, startColumn].Value = item;
                            startColumn++;
                        }
                        startRow++;
                    }

                    workSheet.Cells.AutoFitColumns();
                    package.Save();
                    success = true;
                }

                return success;
            }
            catch (Exception)
            {
                throw;
            }
        }

Popularity 9/10 Helpfulness 3/10 Language csharp

Source: Grepper

Tags: c# datatable

Link to this answer
Share Copy Link

Contributed on May 10 2022

BlackSwan

0 Answers Avg Quality 2/10

c# read excel file using epplus save to datatable

Contents

More Related Answers

c# read excel file using epplus save to datatable

Closely Related Answers

Convert DataTable to excel file c# using epplus

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.