text convert to excel
 

We would like to use linux tools to convert csv file to excel file , can advise any simple tools can do that ? thx

Hi,

What does the csv file look like?

In general any csv file can be imported into excel as long as there is a unique separator (if it is an actual csv file, that is already the case).

Hope this helps.

Hmmm... I'd be inclined to be lazy and open the .csv file with OpenOffice Calc then save it as a .xls file. :) or were you looking for some sort of scripting solution...?

Play Bonny! :hattip:

Hi,
Why the long way around? As I already mentioned: You can load/import the file straight into excel (if that file is an actual csv file).

it just as a standard csv file , the text is separated by "" sige .

if I just want to use linux tool to convert it , can adivse what tool I should use ? Thx

If it's a csv file, then the separator is a comma ','. As above, Excel automatically recognises and will load a csv without any conversion needing to be done.
You may need to check that the FTP or other txfr process results in MS type line endings.

Hi elainelaw,

Maybe this will help: Excel: How to Import CSV Files

The link also explains how to set the delimiter (as in your case, the example used is a space). Based on excel 2007, but I guess the other versions are basically the same.

Hope this helps.

I know you can load .csv files directly into Excel but for me to do this under Linux I'd have to probably load up Wine and go and buy a copy of MS office to get use of Excel. I'd consider this a longer way round than using Open Office.
As this is a Linux forum I'm assuming the question was asked in a Linux context. :)
(However, I usually find "Assume" = 1st mistake! :D )

Play Bonny! :hattip:

the difficulty being that ms-excel is a proprietary format so any scripting will be fairly complex (especially since bash doesnt process binary very well):

google("bash csv to xls")[2] = http://forums.devshed.com/perl-progr...ls-603977.html

happy hacking.