How to get Column name from a table in excel file

Jun 28, 2011 at 6:50 AM

How to get Column name from a table in excel file.

I have imported a excel file (2010) using ClosedXML, but I'm unable to get column name of that table, only table data is retrieving. Please help me.

Jun 28, 2011 at 2:09 PM
                foreach (var table in ws.Tables)

Jun 28, 2011 at 2:51 PM

No, this gives the names of the tables in the given worksheet and not the names of the columns in a table. However, I was able to find a solution to get the column names by 

var workbook = new XLWorkbook(filePath);
var xlWorksheet = workbook.Worksheet(1);
var xlTable = xlWorksheet.Tables.FirstOrDefault();
IXLRangeRow xlRangeRow = xlTable.HeadersRow();

var datatable = new DataTable();
foreach (var cell in xlRangeRow.Cells())

Jun 28, 2011 at 2:55 PM

Sorry about that,