I have an excel file as above. I want to fetch data present in front of each label (Name, Class, Gender) and data present in column (Subject, Marks, OutOff). There are no column headers in the excel sheet. Can we use the LINQ query to fetch data? If yes, Can you please provide me the query?
Excel is not fixed. In some excel you will find above mentioned column/labels and in some excel you will not find it or may be they are placed at different location. Also I want to write this data into another excel file which will be having column headers with same name as label/columns present in this excel file.
Need to use for each and lots of if statement with this approach as columns are not fixed. coulmn can be present at any location in excel file. (for e.g.in one file “Subject” heading and its data will be present in column A and in another file it will be present in column B). Can we use linq query here?