I'm using interops excel methods to get data from an excel spreadsheet and save it to a dat file. The problem I'm running into is that I don't know ahead of time what formatting will be in the range. So with currency, I would want to use value2 since I need greater precision than what currency allows, but this screws up dates. I want to save the dates to the dat file as date formats.
Essentially, I need to extract currency without formatting and dates with formatting, and I can't figure out how to do that.
by Skillet_Lasagna via /r/csharp