|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX for Advanced & Expert Users Advanced UNIX and Linux questions go here. Expert-to-Expert. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert each field to excel | ganga.dharan | Shell Programming and Scripting | 4 | 01-22-2008 05:36 PM |
| Convert to excel | ganga.dharan | Shell Programming and Scripting | 6 | 01-18-2008 03:28 AM |
| Converting excel to text | stevefox | Shell Programming and Scripting | 5 | 05-17-2006 05:56 AM |
| convert Text to Excel | Pavankk | Shell Programming and Scripting | 1 | 03-20-2006 12:33 PM |
| How a program to convert '|' delimited file into excel? | wilsonchan1000 | UNIX for Dummies Questions & Answers | 11 | 08-06-2002 07:31 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
|
#1
08-06-2006
|
|||
|
|||
|
how to convert text/csv to excel
Hello All,
I have a sql report with 50 columns and 1000 rows result in a file ( txt / csv). is there is any way that we can move them to excel in KSH. Thanks, Sateesh 
|
| Forum Sponsor | ||
|
|
|
#2
08-07-2006
|
||||
|
||||
|
If you have Excel 2002, then you could make an XML Spreadsheet
|
|
#3
08-07-2006
|
||||
|
||||
|
You can use ODF (http://en.wikipedia.org/wiki/OpenDocument, XML-based), Microsoft said it will support the Open Document Format (I don't know the state of this support in nowdays Excel)
|
|
#4
04-29-2008
|
|||
|
|||
|
hi
how do i convert a group of csv files into an excel sheet,where each .csv gets converted into a single worksheet(tab)?i.e if there are 5 .csv files,then i need an excel sheet with five worksheets(tabs).
|
|
#5
04-29-2008
|
|||
|
|||
|
If you want a windows solution you could use Active State's Perl. Here is a link to the docs: ActivePerl 5.8 - Online Docs : Using OLE with Perl
You would have to install Active State Perl on your PC and you would have to have Excel available also.
|
|||
| Google The UNIX and Linux Forums |
Linear Mode
