04-12-2011
I have doubts that a *nix command line interface can properly translate a proprietary format such as '*.xls' and convert it to a 'non-proprietary simple *.csv' without utilizing some kind of binary program.
So, let's use the most common binary office suite...
I would think that OpenOffice Calc (spreadsheet) would be the easiest method to obtain the op's goal.
Just open the .xls file and save the tabbed spreadsheet as it's own file!
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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 (4 Replies)
Discussion started by: rahzia
4 Replies
2. Shell Programming and Scripting
Hi,
I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused:
Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Discussion started by: nimish
0 Replies
3. Shell Programming and Scripting
Hi,
I am using sqlplus (called inside my ksh) to create a file which is mailed to the users as an xls.
There is one DESCRIPTION column which is currently coming as wrapped, but, the users want a new line for each of the fields present in the desricription column.
Below is an example -
... (11 Replies)
Discussion started by: Sree_2503
11 Replies
4. 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
5. 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
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 Guys,
I am creating a comma separated file by quering the table and routing it to a file with an extension .xls.
I am using the mailx command to send the .xls file to windows mail box.
The file is coming as a excel attachment, but the cells are not expanded.
Is there a way by which... (4 Replies)
Discussion started by: mac4rfree
4 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I am creating an XLS using unix which fetches the data from database.
In the first row i have 2 columns which i want to merge. Is it possible to merge the columns using unix command?
Thanks,
Sashanka (1 Reply)
Discussion started by: Sashanka_545
1 Replies
9. UNIX for Advanced & Expert Users
Hey Guys ,
Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below :
1. Convert one XLS file with multiple tabs to multiple CSV files.
-- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Discussion started by: himanshu sood
2 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
PSC(1) General Commands Manual PSC(1)
NAME
psc - prepare sc files
SYNOPSIS
psc [-fLkrSPv] [-s cell] [-R n] [-C n] [-n n] [-d c]
DESCRIPTION
Psc is used to prepare data for input to the spreadsheet calculator sc(1). It accepts normal ascii data on standard input. Standard out-
put is a sc file. With no options, psc starts the spreadsheet in cell A0. Strings are right justified. All data on a line is entered on
the same row; new input lines cause the output row number to increment by one. The default delimiters are tab and space. The column for-
mats are set to one larger than the number of columns required to hold the largest value in the column.
OPTIONS
-f Omit column width calculations. This option is for preparing data to be merged with an existing spreadsheet. If the option is not
specified, the column widths calculated for the data read by psc will override those already set in the existing spreadsheet.
-L Left justify strings.
-k Keep all delimiters. This option causes the output cell to change on each new delimiter encountered in the input stream. The
default action is to condense multiple delimiters to one, so that the cell only changes once per input data item.
-r Output the data by row first then column. For input consisting of a single column, this option will result in output of one row
with multiple columns instead of a single column spreadsheet.
-s cell
Start the top left corner of the spreadsheet in cell. For example, -s B33 will arrange the output data so that the spreadsheet
starts in column B, row 33.
-R n Increment by n on each new output row.
-C n Increment by n on each new output column.
-n n Output n rows before advancing to the next column. This option is used when the input is arranged in a single column and the
spreadsheet is to have multiple columns, each of which is to be length n.
-d c Use the single character c as the delimiter between input fields.
-P Plain numbers only. A field is a number only when there is no imbedded [-+eE].
-S All numbers are strings.
-v Print the version of psc
SEE ALSO
sc(1)
AUTHOR
Robert Bond
PSC 7.16 19 September 2002 PSC(1)