jeudi 26 février 2015

How can I ignore Excel cell value if text is struck through?

I'm parsing an Excel spreadsheet using Microsoft's Excel Interop. I was instructed to ignore any values that have been "stricken through" (see image).


enter image description here


The code I'm using to get the value is simple:


string cellValue = Convert.ToString(cell.Value);


Maybe I could check each character in the cellValue to see if its ASCII code is beyond an acceptable range?


Aucun commentaire:

Enregistrer un commentaire