I am in the unusual position of having two different templates for an Excel upload, one that is 'human friendly' and one that is machine generated. As such, the column data headers are different and it is difficult to align them.
As such, I would like to reference the column mappings using the ordinal position rather than the 'name' of the column. Currently I have this:
var excel = new ExcelQueryFactory(excelFileName);
excel.AddMapping<Student>(x => x.FirstName, "First Name");
excel.AddMapping<Student>(x => x.LastName, "Last Name");
excel.AddMapping<Student>(x => x.LastFour, "Last 4 Student ID");
excel.AddMapping<Student>(x => x.LastDate, "Last Date");
and I would like to do something like this:
var excel = new ExcelQueryFactory(excelFileName);
excel.AddMapping<Student>(x => x.FirstName, "A");
excel.AddMapping<Student>(x => x.LastName, "C");
excel.AddMapping<Student>(x => x.LastFour, "G");
excel.AddMapping<Student>(x => x.LastDate, "H");
where the letters are the column references in Excel.
Is there a way to do this?
if you order is the same you can call
var columnnames= excel.GetColumnNames("worksheetName");
excel.AddMapping<Student>(x => x.FirstName, columnnames[0]);
excel.AddMapping<Student>(x => x.FirstName, columnnames[1]);
excel.AddMapping<Student>(x => x.LastFour, columnnames[2]);
Using the WorksheetNoHeader
method is what you're looking for. Here's a code example:
var students = new List<Student>();
var excel = new ExcelQueryFactory("excelFileName");
var rows = excel.WorksheetNoHeader().ToList();
//Skip the first row since it's the header
for (int rowIndex = 1; i < rows.Count; rowIndex++)
{
var row = rows[rowIndex];
var student = new Student();
// row[0] refers to the value in the first column of the row
student.FirstName = row[0];
student.LastName = row[1];
student.LastFour = row[2];
student.LastDate = row[3];
students.Add(student);
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With