Dear Friends,
I have a CSV file with some unicode contents, like "Tübingerstraße", Also some records spaning into multiple lines. I have attached the csv file.
I have tried the two code blocks.
The first one uses the "WorkBooks.Open" method. It opens the csv file but the encoding is lost. I got "TübingerstraÃxe" instead of "Tübingerstraße".
The second one uses the "WorkBooks.OpenText" method where i can specfiy the code page (65001 -> UTF 8). It opens the csv file with correct charectors. but the mulitline fields converted into multiple rows.
Is there any way to solve this?
-
prakash
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Uhh sorry missed the multiline aspect, seems like you have "hard" linebreaks represented by character with the ASCII code 10. I tested if you could change to a different linebreak char (13) but it made no difference.
Maybe you could come up with something different than the hard linebreak chars and thereby keep the multiline effect in the field.
Cheers
cslarsen
>Maybe you could come up with something different than the hard linebreak chars and thereby keep the multiline effect in the field.
Is there any chars I can use for the hard line breaks ?
Also the WorkBook.Open methods correctly identifies the records :) . don know how it was implemented.
kaufmed:
It worked but the unicode chars are changed to a junk one in the opened excel.
I'm not sure. When I tried to execute the code as you originally posted it, I received a file similar to what you have just attached. However, when I changed the function calls parameters to those which I posted, I received the file I attached previously. I think the key component is the XlPlatform.xlWindows parameter. That tells the Excel object that the file is a Windows-formatted file (to handle the line breaks).
Finally I got the solution.
First I have used the UTF-8 encoding to create the csv file. After I changed it to Unicode Little Endian byte order, the Workbooks.Open got working with unicode chars.
Excel._Workbook book = objBooks.Open(@"E:\Exporte
objOpt, objOpt, objOpt, objOpt, objOpt, objOpt, Excel.XlPlatform.xlWindows
ref :
http://www.myintervals.com
Thank you very much for help
using (StreamWriter swriter = new StreamWriter(destinaionCSV
{
//Write code
}
Business Accounts
Answer for Membership
by: CSLARSENPosted on 2008-12-19 at 00:04:07ID: 23210794
This one works fine for me with regards to the unicode chars.
Workbooks.OpenText Filename:= _
"C:\ExportedData.txt", Origin:=65001, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuo
ConsecutiveDelimiter:=Fals
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), _
Array(3, 1)), TrailingMinusNumbers:=True
Cheers
cslarsen