Sponsored Content
Full Discussion: UNIX files to XLS
Top Forums UNIX for Advanced & Expert Users UNIX files to XLS Post 22127 by Kelam_Magnus on Tuesday 28th of May 2002 04:09:44 PM
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
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
NICOTINE(1)						      General Commands Manual						       NICOTINE(1)

NAME
nicotine-import-winconfig - import configuration from the Windows soulseek client SYNOPSIS
nicotine-import-winconfig [OPTIONS] old-config-file DESCRIPTION
This manual page documents briefly the nicotine-import-winconfig command. This manual page was written for the Debian distribution because the original program does not have a manual page. nicotine-import-winconfig is a program to import your queue, user list, password information, auto-joined chatrooms, banlist, and user information from the Windows SoulSeek configuration. USAGE
A typical invocation would be : nicotine-import-winconfig "/mnt/win9x/Program Files/SoulSeek" The program should be run when nicotine is not running. It will add the information (download queue, userlist, password info, etc.) to the existing configuration or write a new configuration from scratch when no configuration exists. FILES
$HOME/.nicotine/config The per-user configuration file for nicotine(1) will be overwritten. You might want to back up the file first, but it should not be necessary. A different config file can be chosen using the --config flag. configfile-userinfo.ext In case there's an image included in the Windows SoulSeek userinfo, the image will be extracted and written to that file, where con- figfile is the path to your nicotine configuration file, and ext is the appropriate file extension for the image type. OPTIONS
When you don't want to import all configuration options, you can choose what to import using command line flags. -c file | --config=file Use a non-default nicotine configuration file to write to. -q | --queue Import the queue. -u | --userlist Import the userlist. -l | --login Import the login information. -C | --chatrooms Import the list of autojoined chatrooms. -b | --banned Import the list of banned users. -i | --userinfo Import the user information and the image. -h | --help Print the summary of command line options and exit. TIPS
It is possible to share the download directory between platforms. Nicotine can even continue downloads that started using the Windows client. Of course, the download directories should be the same for nicotine and Windows, e.g. if your Windows sharing directory is F:slsk_in and your F drive is mounted on /mnt/media, then you must set your download directory to /mnt/media/slsk_in. SEE ALSO
nicotine(1). AUTHOR
Geert Kloosterman <geertk@ai.rug.nl>, 2003. August 25, 2003 NICOTINE(1)
All times are GMT -4. The time now is 04:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy