hi all.
I export some of my data from my application in CSV format. When i open that csv in excel all the data of CSV is opened in the single (first) column of excel sheet.
I understand that i can use the "Text to Columns" feature of excel to specify the delimiter and to format my csv across multiple columns.
But i do not want to do this step (text to columns step). I want to put the delimiter settings in my csv file so that excel automatically format my csv according to the separator/ delimiter given in the csv file.
I achieved this by putting "sep=," as the first line in my CSV file, but this made problem to my currency signs in the CSV file specially for euro and bhat. (the encoding is not a problem as encoding is already Unicode and before this experiment currency signs were alright with this encoding format)
So kindly tell me how can i put the delimiter in my csv file so that excel opens it in multiple columns knowing that delimiter? a ...
Go to the complete details ...