Determine if Unicode reading characters in Excel file
Posted on 2011-03-22
I have a problem when I open data from an Excel file to a DBF file in FoxPro.
I want to create a VB.NET application to see if any Unicode characters exist in an excel file before I convert to a dbf. (Stop using dbf is not an option)
I know I can determine the character set using .NET, but I dont have time to research. Anyone have a solution or sample code using "System.Text.Encoding"
Basically, I want to: read an excel file using .NET. I would then evaluate each character in the excel file. If the character is not a match for Ascii character, or is Unicode character set, then I would indicate what character was found, in what column, in what row, and exactly what character #. This record could then be extracted by someone before it is converted to dbf.