I need help getting formatted data from an Excel range.

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

Leave a Reply