01-04-2010
or another manual way is to,
have it as CSV file
open the CSV file in excel specifying it as CSV and mention the delimiters for CSV, that should do it.
But the best way is to use CPAN module for manipulating excel sheets
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Discussion started by: miltony
1 Replies
2. Shell Programming and Scripting
Can we convert an xls file into csv format in Unix
Thanks
Suresh (1 Reply)
Discussion started by: sureshg_sampat
1 Replies
3. Shell Programming and Scripting
Hi
Please can someone tell me how i can convert .xls file into .csv on both platforms, windows and unix.
many thanks,
neil (4 Replies)
Discussion started by: neil546
4 Replies
4. Shell Programming and Scripting
how to convert a xls file into .csv file?
is tghere any command in unix for that?
please help
thanks (3 Replies)
Discussion started by: infyanurag
3 Replies
5. 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
6. Shell Programming and Scripting
Hi,
I have problem..How to convert .xls file to .csv..
Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies
7. Shell Programming and Scripting
Hi,
My requirement is to convert the xls to csv file with utf-8 conversion.
Is there any way please suggest me.
Thanks,
Raja (4 Replies)
Discussion started by: cnraja
4 Replies
8. Shell Programming and Scripting
I would like to know if have one way with read table from oracle converter in CSV o TXT and After converter in XLS or spreedsheet
Thanks so much
JAvier (3 Replies)
Discussion started by: javeiregh
3 Replies
9. UNIX for Advanced & Expert Users
Hello,
I have one csv file(";" separated). I would like to mail it as an attachment in xls format.
I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";".
unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid... (3 Replies)
Discussion started by: skhichi
3 Replies
10. Shell Programming and Scripting
Hello
I have a script which converts log to csv.
Now I need to have xls.
Is there any easy way/command which can convert csv to xls?:confused:
preferably just using bash and not perl,... is it possible? (1 Reply)
Discussion started by: frhling
1 Replies
LEARN ABOUT DEBIAN
dlags2.f
dlags2.f(3) LAPACK dlags2.f(3)
NAME
dlags2.f -
SYNOPSIS
Functions/Subroutines
subroutine dlags2 (UPPER, A1, A2, A3, B1, B2, B3, CSU, SNU, CSV, SNV, CSQ, SNQ)
DLAGS2
Function/Subroutine Documentation
subroutine dlags2 (logicalUPPER, double precisionA1, double precisionA2, double precisionA3, double precisionB1, double precisionB2, double
precisionB3, double precisionCSU, double precisionSNU, double precisionCSV, double precisionSNV, double precisionCSQ, double precisionSNQ)
DLAGS2
Purpose:
DLAGS2 computes 2-by-2 orthogonal matrices U, V and Q, such
that if ( UPPER ) then
U**T *A*Q = U**T *( A1 A2 )*Q = ( x 0 )
( 0 A3 ) ( x x )
and
V**T*B*Q = V**T *( B1 B2 )*Q = ( x 0 )
( 0 B3 ) ( x x )
or if ( .NOT.UPPER ) then
U**T *A*Q = U**T *( A1 0 )*Q = ( x x )
( A2 A3 ) ( 0 x )
and
V**T*B*Q = V**T*( B1 0 )*Q = ( x x )
( B2 B3 ) ( 0 x )
The rows of the transformed A and B are parallel, where
U = ( CSU SNU ), V = ( CSV SNV ), Q = ( CSQ SNQ )
( -SNU CSU ) ( -SNV CSV ) ( -SNQ CSQ )
Z**T denotes the transpose of Z.
Parameters:
UPPER
UPPER is LOGICAL
= .TRUE.: the input matrices A and B are upper triangular.
= .FALSE.: the input matrices A and B are lower triangular.
A1
A1 is DOUBLE PRECISION
A2
A2 is DOUBLE PRECISION
A3
A3 is DOUBLE PRECISION
On entry, A1, A2 and A3 are elements of the input 2-by-2
upper (lower) triangular matrix A.
B1
B1 is DOUBLE PRECISION
B2
B2 is DOUBLE PRECISION
B3
B3 is DOUBLE PRECISION
On entry, B1, B2 and B3 are elements of the input 2-by-2
upper (lower) triangular matrix B.
CSU
CSU is DOUBLE PRECISION
SNU
SNU is DOUBLE PRECISION
The desired orthogonal matrix U.
CSV
CSV is DOUBLE PRECISION
SNV
SNV is DOUBLE PRECISION
The desired orthogonal matrix V.
CSQ
CSQ is DOUBLE PRECISION
SNQ
SNQ is DOUBLE PRECISION
The desired orthogonal matrix Q.
Author:
Univ. of Tennessee
Univ. of California Berkeley
Univ. of Colorado Denver
NAG Ltd.
Date:
November 2011
Definition at line 152 of file dlags2.f.
Author
Generated automatically by Doxygen for LAPACK from the source code.
Version 3.4.1 Sun May 26 2013 dlags2.f(3)