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

C# Read Excel columns header return to list

BlackSwan answered on May 20, 2022 Popularity 1/10 Helpfulness 3/10

answer C# Read Excel columns header return to list

C# Read Excel columns header return to list

Comment

 /// <summary>
        /// Read excel columns header return to List
        /// </summary>
        /// <param name="file">ecel file path</param>
        /// <returns>List</returns>

///Note 1. Install-Package Epplus, 2. Use OfficeOpenXml namespace
        public static List<string> ReadExcelHealdersStoretoList(FileInfo file)
        {
            List<string> excelColumns = new List<string>();
            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

            //Read excel columns headers store to list
            using (var package = new ExcelPackage(file))
            {
                ExcelWorksheet workSheet = package.Workbook.Worksheets[0];
                foreach (var firstRC in workSheet.Cells[1, 1, 1, workSheet.Dimension.End.Column])
                {
                    excelColumns.Add(firstRC.Text);
                }
            }

            return excelColumns;
        }

Popularity 1/10 Helpfulness 3/10 Language csharp

Source: Grepper

Tags: c# excel header list return

Link to this answer
Share Copy Link

Contributed on May 20 2022

BlackSwan

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

C# Read Excel columns header return to list

Contents

More Related Answers

C# Read Excel columns header return to list

Grepper

Documentation

Social

Legal

Contact

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