1

I am using LinqPad in conjunction with Linq2Excel to do my own data analysis on an Excel spreadsheet (written and owned by others). These other people use a lot of cell formatting to represent data. For example, a grey background cell means "not applicable"; text format == strikethrough means "superceded".

Is there any way to get at these format values in LinqToExcel so I can filter on them?

philologon
  • 2,093
  • 4
  • 19
  • 35

1 Answers1

1

Unfortunately it's not possible to retrieve the cell format values through LinqToExel.

LinqToExcel uses OleDb to retrieve data from the spreadsheets, and OleDb doesn't include information about the cell formatting.

Paul
  • 18,349
  • 7
  • 49
  • 56