UNIX files to XLS


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users UNIX files to XLS
# 1  
Old 05-28-2002
UNIX files to XLS

People,

I am wondering if there is a Software(Filter) that can convert my UNix text file (delimeted text file) to Excel, for my business users to launch and see.

Thanx

Zia
# 2  
Old 05-28-2002
Have u tried this?

Copy unix text file to Windows using FTP, and then from Excel open the file - make sure in excel you specify that the file type to be opened is text; a wizard will help with the rest.
# 3  
Old 05-28-2002
I used to do this all the time with a variety of delimited files.

You can import any delimited text file in to Excel. This is straight from the Application.

1 Click Open .
2 In the "Look in" box, locate the drive, folder, or Internet location that contains the file you want to open.
3 In the "Files of" type box, click Text Files.
4 Double-click the file you want to import.
5 Follow the instructions in the Text Import Wizard to specify how you want to divide the text into columns.

There will be an import wizard that will ask you how to import the text file. Just give it the delimiter that you wish to use and the rest should be fairly easy to understand.



Smilie
# 4  
Old 05-28-2002
THis is what I need

NO friends ! I do that today. i.e FTp'ing down and opening it in excel.
Is there a utility or package that can be run on unix box that can convert this text file on the HP box.
Point is I can then automate this process by Ftp'ing the file to the webserver from my shell script.

This reports are being accessed by business users and i want to elminate any manual process of opening it into Excel and then emailing or FTping it later.

Thanx
# 5  
Old 05-28-2002
Click here for a page from a guy who claims to have an answer. I haven't tried this stuff. If you do, post back and let us know how it goes.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies

2. Shell Programming and Scripting

How to convert Excel Files to Xls?

Hi All, I have created a BI Publisher report in Oracle apps R12. It has generated the output with *.EXCEL file extension. I have a shell script to mail this output. in my shell script I have copied this file and saved as *.xls file. But the R12 generated *.EXCEL file is not a real excel... (5 Replies)
Discussion started by: kalidoss
5 Replies

3. Shell Programming and Scripting

Rename the files with .xls file

Hi I need to reanme the multiple file using unix script I have multiple file like: 201005_SAMPLE_20110512.xls 201005_NAME_20110512.xls 201005_TEST_20110512.xls 201005_FIRST_LAST_20110512.xls I need to rename this file SAMPLE.xls NAME.xls TEST.xls FIRSTLAST.xls can you guide me the... (6 Replies)
Discussion started by: murari83.ds
6 Replies

4. Shell Programming and Scripting

Removing worksheets from xls using unix.

HI All, I have a .xls file , in which I have multiple worksheets , I need to remove all the worksheets except the worksheet by name CDR_LOAD_STATS, how can I do this in unix. Please guide me. Regards, Deepti (7 Replies)
Discussion started by: gaur.deepti
7 Replies

5. UNIX and Linux Applications

Tool for Convert XLS into CSV in UNIX

Hi I wanted to convert some XLS files into CSV format in my UNIX box. Unix box is handling very important data which are related to data warehouse.It is fully optimized by installing minimum packages since server need more resources to handle reports generating. Just for convert XLS files... (6 Replies)
Discussion started by: luke_devon
6 Replies

6. UNIX for Dummies Questions & Answers

converting xls,xlsx files ??

I think I know the answer to this :rolleyes: but thought I'd ask anyway. You never know. Does anyone know of a program or utility that will run on any unix platform and convert Microsoft Excel files to ascii/plain text files that unix can understand ? Thanks in advance. Floyd (3 Replies)
Discussion started by: fwellers
3 Replies

7. Shell Programming and Scripting

How to create xls file using unix script

Hi All, I want to create an xls file using shell script. I mean that I have written one script. It is having sql output. So I want to save that sql output into one xls file and I want to send that file as a attachment to my team MAIL_IDs. Can You any guy help me in this? Thanks in... (3 Replies)
Discussion started by: raghu.iv85
3 Replies

8. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls bbc.xls Eno Ename Eno Ename 101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies

9. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls Eno Ename 101 hello 102 hero 103 india bbc.xls Eno Ename 201 delhi 202 Hyd 203... (0 Replies)
Discussion started by: jagadish99
0 Replies

10. UNIX for Dummies Questions & Answers

WINDOWS to UNIX : xls to csv

Hi, I need to ftp a .xls file from WINDOWS to UNIX. When I do it, the file coversion doesn't happen(??) or UNIX doesn't recognixe this format I know not. But there will be junk values in the ftp'd file. Note: The ftp will be done by a script and I don't think we could place a WINDOWS script on... (5 Replies)
Discussion started by: preethgideon
5 Replies
Login or Register to Ask a Question