I have a .CSV file that contains French Characters.
The file was created:
Dim ecp862 As Encoding = Encoding.GetEncoding(1252)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
oTargetFile = New StreamWriter(hshArguments.Item("OUTFILE"), False, ecp862)
'French data written.
When I open using UltraEdit, it needs to have FORMAT as 1252 and "Open As" set to ASCII Escaped Unicode.
I am trying to load the file using ASPOSE.CELLS and save to EXCEL format.
Dim oDataWB As New Workbook("c:\Copy of 301-payroll-retro-list_20130509_047476495.csv")
The code above results in a spreadsheet that has weird characters in place of the French characters.
I can't seem to find out how to set the encoding. I could use a StreamReader, however the WORKBOOK function needs either a filename/path or a FILESTREAM.
Can you provide any suggestions?