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.
![Big Grin Smilie](https://www.unix.com/images/smilies/biggrin.gif)
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
nicotine-import-winconfig
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)