12-22-2006
How to input .txt file into .xls spreadsheet
I need to take the totals from my script and input them into a excel spreadsheet. Right now, I just copy and paste. Is there an easier way?
3906
is the total jobs in ABEND state
4005
is the total jobs in SUCC state
1050
is the total jobs in HOLD state
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How to convert a txt file(tab delimiter) to xls file.
Looking forward help.
Thanks,
Venkatesh. (2 Replies)
Discussion started by: venkatesht
2 Replies
2. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
3. UNIX for Dummies Questions & Answers
i want to convert a comma seprated file into a .xls file
the file contains 3 fields seprated by a comma.
i want to convert it into a .xls file with 3 columns and 37 rows
DPRPT400,01/15/2009-15:03:06,01/15/2009-15:03:08
DPRPT401,01/15/2009-15:03:15,01/15/2009-15:03:32... (11 Replies)
Discussion started by: manit
11 Replies
4. Shell Programming and Scripting
Hi,
i don't know anything about PERL. Can anyone help me providing PERL scripts for
1. converting XLS to CSV (and vice-versa)
2. converting DOC/RTF to TXT
Thanks much
Prvn (1 Reply)
Discussion started by: prvnrk
1 Replies
5. Shell Programming and Scripting
Hello All,
I just want help in coding a simple shell script since i am a newbie for UNIX and i started learning unix and shell scripting basics recently.
I am having a data like this in .txt file.
Product Name : XYZ
Price : 678.1
Best Buy Price : 600
Product Name : ABC
Price : 465... (3 Replies)
Discussion started by: vasanth_123
3 Replies
6. Shell Programming and Scripting
Hi ,
I am getting data as below for one of my table as below in a .txt format.I am manually opening a xls sheet, and then selecting import data from option and importing the data in to xls and then saving it as .csv file and this .csv file I am using for one of the shell script.
I am... (3 Replies)
Discussion started by: shruthidwh
3 Replies
7. Shell Programming and Scripting
Hi to all,
I want to convert xml file to binary Excel file, after googling for a while, I found cpan tool "Spreadsheet::WriteExcel::FromXML". I installed both,
Spreadsheet::WriteExcel and Spreadsheet::WriteExcel::FromXML.
To test Spreadsheet::WriteExcel I executed a example script that... (8 Replies)
Discussion started by: Ophiuchus
8 Replies
8. Shell Programming and Scripting
i have hundreds of thousands of txt files as below,
RADARSAT 1 SCENE DESCRIPTION
SCENE_ID c0005098
MDA ORDER NUMBER
GEOGRAPHICAL AREA CIS ScanSar Canada
SCENE START TIME APR 02 1997 23:05:10.222
SCENE STOP TIME APR 02 1997 23:02:49.695... (5 Replies)
Discussion started by: sunnydanniel
5 Replies
9. Shell Programming and Scripting
Hi dears
i have text file like this:
INPUT.txt
001_1_173 j nuh ]az
001_1_174 j ]esma. nuh ]/.xori
.
.
. and have another text
like this
TABLE.txt
j j
nuh word1... (6 Replies)
Discussion started by: alii
6 Replies
10. Shell Programming and Scripting
Hi dears
i use bash shell
i have INPUT.txt
like this
number of columns different in one
some row have 12 , some 11 columns
see last column
INPUT.txt
CodeGender Age Grade Dialect Session Sentence Start End Length Phonemic Phonetic
63 M 27 BS/BA TEHRANI 3 4 298320 310050... (2 Replies)
Discussion started by: alii
2 Replies
LEARN ABOUT OPENSOLARIS
atq
atq(1) User Commands atq(1)
NAME
atq - display the jobs queued to run at specified times
SYNOPSIS
atq [-c] [-n] [username]...
DESCRIPTION
The atq utility displays the at jobs queued up for the current user. at(1) is a utility that allows users to execute commands at a later
date. If invoked by a user with the solaris.jobs.admin authorization, atq will display all jobs in the queue.
If no options are given, the jobs are displayed in chronological order of execution.
When an authorized user invokes atq without specifying username, the entire queue is displayed; when a username is specified, only those
jobs belonging to the named user are displayed.
OPTIONS
The following options are supported:
-c Displays the queued jobs in the order they were created (that is, the time that the at command was given).
-n Displays only the total number of jobs currently in the queue.
FILES
/var/spool/cron/atjobs spool area for at jobs.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO
at(1), atrm(1), auths(1), cron(1M), auth_attr(4), attributes(5)
SunOS 5.11 13 Aug 1999 atq(1)