How to take input from excel for shell script. Post: 302375964

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

reading data from excel using shell script

Hi all I am new to shell scripting. I need to write a shell script that reads each row of an USER_ID colume in a excel file. the excel has around 10000 rows of data. Can someone gives me some example or advice what's best way to do this thanks

2. Shell Programming and Scripting

Shell script to turn on Autofilter in Excel.

Hi, I have a shellscript that produces a csv that can be opened in Microsoft Excel. It has two columns and about 10 rows in each column, so only twenty cells (at the moment). When the user opened the csv, I wanted it so autofilter was already turned on in columns A1 and B1 (and potentially C1,...

3. Shell Programming and Scripting

How to get values from an excel in a shell script

Hi All, Am trying to write a shell script which will get values from an excel and do some calculations. Can any one pls help me out in the commands used to get the values from ms-excel. Thanks!!!:)

4. Shell Programming and Scripting

Export to Microsoft excel using shell script

I have requirement where i have to export the data extracted from a flat file to a microsoft excel sheet. If the awk returns multiple records then all these records should go in into different rows of same column in excel. Eg. say data returned by excel is A,B,C,D then these 4 records should go...

5. Shell Programming and Scripting

editing excel file through shell script

Hi, I am having a business file in excel having charts based on data already present on it. I would like to add new rows after the existing data and refesh the chart on it using shell script. For example-- In excel file in "sheet1", There is some data in first 10 rows ( from column A to F)....

6. Shell Programming and Scripting

Zip an excel in a shell script

I am getting an xls file in the dir errorpath. I would like to zip it. Kindly help me on this. The code is as below. sqllst=$errorpath/$run_pgm.${date_stamp}".xls" sqlstatus=$errorpath/$run_pgm"."${date_stamp}".sqlstatus" sqlscript=$binpath"/im_rpt.sql"

7. UNIX for Dummies Questions & Answers

Read excel file using shell script

Is it possible to read an excel sheet using shell script ?

8. Shell Programming and Scripting

Formatting Shell script output to Excel

I am facing a problem formatting the output of my shell script in excel. We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation). Also, leading zeroes(if any) in the output are getting...

9. Shell Programming and Scripting

Excel from shell script

Is it possible to generate excel sheet from a shell script and rename the worksheet..? Thanks for your answer

10. UNIX for Dummies Questions & Answers

How to Create excel file(.csv) using shell script?

Hi, i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test...

LEARN ABOUT DEBIAN

slags2.f

slags2.f(3)							      LAPACK							       slags2.f(3)

NAME

       slags2.f -

SYNOPSIS

   Functions/Subroutines
       subroutine slags2 (UPPER, A1, A2, A3, B1, B2, B3, CSU, SNU, CSV, SNV, CSQ, SNQ)
	   SLAGS2

Function/Subroutine Documentation
   subroutine slags2 (logicalUPPER, realA1, realA2, realA3, realB1, realB2, realB3, realCSU, realSNU, realCSV, realSNV, realCSQ, realSNQ)
       SLAGS2

       Purpose:

	    SLAGS2 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 REAL

	   A2

		     A2 is REAL

	   A3

		     A3 is REAL
		     On entry, A1, A2 and A3 are elements of the input 2-by-2
		     upper (lower) triangular matrix A.

	   B1

		     B1 is REAL

	   B2

		     B2 is REAL

	   B3

		     B3 is REAL
		     On entry, B1, B2 and B3 are elements of the input 2-by-2
		     upper (lower) triangular matrix B.

	   CSU

		     CSU is REAL

	   SNU

		     SNU is REAL
		     The desired orthogonal matrix U.

	   CSV

		     CSV is REAL

	   SNV

		     SNV is REAL
		     The desired orthogonal matrix V.

	   CSQ

		     CSQ is REAL

	   SNQ

		     SNQ is REAL
		     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 slags2.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.1							  Sun May 26 2013						       slags2.f(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

reading data from excel using shell script

Discussion started by: tiger99

2. Shell Programming and Scripting

Shell script to turn on Autofilter in Excel.

Discussion started by: rainemaida

3. Shell Programming and Scripting

How to get values from an excel in a shell script

Discussion started by: msri.1900

4. Shell Programming and Scripting

Export to Microsoft excel using shell script

Discussion started by: goutam_igate