I am developing a program to export text into CSV format.
My text format is like 001, 0012, 000173.
If I use the following code segment:
ofstream tmp ("book1.csv");
tmp<<"001";
tmp<<",";
tmp<<"0012";
tmp.close();
and open the this file in Excel, the cell will be displayed
1 and 12 not 001 and 0012l.
How can I modify the code to let the Excel not convert the text
format?
Thanks!
The problem is inside Excel, not your program. In Excel, use menu item Data-->Import External Data->Import and select the file to be imported. In Step 1 of the Import Wizard leave the defaults value, in Step 2 change "Text Qualifier" to None. Then click Finish.
The file will need the quotes, like this
To achieve that the quotes have to be escaped, like thisCode:"001","002","003"
Code:cout << "\"001\""
Last edited by Ancient Dragon; 10-11-2005 at 04:11 AM.
