using vb.net/asp.net 2005
I am opening and reading and I need to detect the encoding of the file that I am reading. There are different system users who will be using different encoding in their files so I have no control over this.
Dim myStreamRdr As System.IO.StreamReader = New System.IO.StreamReader(myFileName, System.Text.Encoding.Default)
While the default encoding normally works there are special foreign language (non-English) characters that are not being read correctly, instead there are garbage characters in their place.
I have researched this and it has been suggested to determine the encoding of the file and then use that encoding, but I have not been able to find out how to to do this.
so in a nutshell: how can I use vb.net to detect the encoding of an excel file?
View Complete Post