reading data from excel using shell script Post: 302155803

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading data from a file through shell script

There is one Text file data.txt. Data within this file looks like: a.sql b.sql c.sql d.sql ..... ..... want to write a shell script which will access these values within a loop, access one value at a time and store into a variable. can anyone plz help me.

2. Shell Programming and Scripting

Filter data in Excel sheet using Shell Script

Hi, I have an excel sheet which has 100000 records. All these records are having 3 columns each with the last column as "Y" or "N". I would like to filter those records which has the value "Y". Can you please let me know how to proceed with that? Thanks in advance. -Sri ----------...

3. Shell Programming and Scripting

how to put data using shell script to a excel file

Hi, Can any one tell me how to put data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column. Say my text file data is: 15-dec-2008 15-dec-2009 16-dec-2008 16-dec-2009 say my first...

4. UNIX for Advanced & Expert Users

put data in excel file using shell script

Hi. I wish to add data in a specific excel file on daily basis.However the currect dat's data should always come on top i.e for example should always occupy cell A7,B7,C7 .. and the data of day before which was earlier on 7th row of each coloumn should move to 8th row..data on 8th row should...

5. Shell Programming and Scripting

Reading the data from CSV and performing search through shell script

Hello, I am working on building a script that does the below actions together in my Linux server. 1) First, have to read the list of strings mentioned in CSV and store it in the shell script 2) Second, pick one by one from the string list, and search a particular folder for files that...

6. Shell Programming and Scripting

Export data from database in Excel sheet with the help of Shell script and automated the report

Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig.

7. Shell Programming and Scripting

Need help on inserting data from text file to excel using shell script

Hi, Please help me on this. I want to insert data from text file to excel using shell script nawk -v r=4 -v c=4 -v val=$a -F, 'BEGIN{OFS=","}; NR != r; NR == r {$c = val; print}' "file.csv" I used above one to insert $a value in 4th row, 4th column in an excel file.csv and it...

8. Shell Programming and Scripting

How to write text file data to excel using UNIX shell script?

Hi All, I have the requirement in unix shell script. I want to write the "ls -ltr" command out put to excel file as below. Input :text file data : drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x 2 apx aim 4096 Nov 29 18:40 drwxr-xr-x 5 root root 4096 Oct 2 12:26 drwxr-xr-x...

9. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

10. Shell Programming and Scripting

Reading a column from excel using shell script in Linux environment

Hi all I am new to shell scripting. I need to read the 1st column and last of the excel file in linux environment. Can some one help me with examples

LEARN ABOUT DEBIAN

ns_connreturnnotice

Ns_ConnReturnData(3aolserver)				   AOLserver Library Procedures 			     Ns_ConnReturnData(3aolserver)

__________________________________________________________________________________________________________________________________________________

NAME

       Ns_ConnReturnAdminNotice, Ns_ConnReturnData, Ns_ConnReturnHtml, Ns_ConnReturnNotice - Routines to generate simple single-buffer responses

SYNOPSIS

       #include "ns.h"
       int
       Ns_ConnReturnAdminNotice(conn, status, title, msg)

       int
       Ns_ConnReturnData(conn, status, data, len, type)

       int
       Ns_ConnReturnCharData(conn, status, data, len, type)

       int
       Ns_ConnReturnHtml(conn, status, msg, len)

       int
       Ns_ConnReturnNotice(conn, status, title, msg)

ARGUMENTS

       Ns_Conn	 conn	(in)	  Pointer to open connection.

       int	 status (in)	  HTTP response status code.

       char	 *type	(in)	  Output content type.

       char	 *title (in)	  Pointer to HTML page title string.

       int	 len	(in)	  Length of content buffer.

       char	 *data	(in)	  Pointer to content buffer.

       char	 *msg	(in)	  Pointer to HTML message buffer.
_________________________________________________________________

DESCRIPTION

       These  routines	are used to generate complete responses, including headers, status codes, content types, and the requested data.  They all
       return a status code which is NS_OK if the response was sent or NS_ERROR if an underlying call to sent the content failed.

       int Ns_ConnReturnAdminNotice(conn, status, title, msg)
	      This routine is equivalent to Ns_ConnReturnNotice. In prior versions, it would format a slightly different response which was  later
	      considered inconsequential.

       int Ns_ConnReturnData(conn, status, data, len, type)
	      Generates  a reponse with the given HTTP status including a content-type header with the given type.  Content pointed to by the data
	      argument of length len is then sent without any modification via an underlying call to Ns_ConnFlushDirect.

       int Ns_ConnReturnCharData(conn, status, data, len, type)
	      Generates a response as with Ns_ConnReturnData except that the given content pointed to by data is assumed to be a text stream which
	      is output encoded using the appropriate Tcl_Encoding based on the given type mimetype and possibly gzip compressed via an underlying
	      call to Ns_ConnFlush.

       int Ns_ConnReturnHtml(conn, status, msg, len)
	      This is equivalent to Ns_ConnReturnCharData(conn, status, msg, len, "text/html").

       int Ns_ConnReturnNotice(conn, status, title, msg)
	      Constructs a basic HTML response and sends it via Ns_ConnReturnHtml.  The title string is placed both in the <head> portion as  well
	      as  an  <h2>  tag in the <body> portion of the document.	If the title is NULL, it defaults to the string "Server Message".  The msg
	      string, if not NULL, follows the body and is copied unaltered.  This routine is useful for generating  very  basic  responses.   For
	      example, it is used by the various builtin reponse routines such as Ns_ConnReturnUnauthorized.

SEE ALSO

       Ns_ConnFlush(3), Ns_ConnReturnFile, Ns_ConnReturnOpenFd, Ns_ConnReturnUnathorized.

KEYWORDS

       connnection, encoding, response

AOLserver								4.0					     Ns_ConnReturnData(3aolserver)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading data from a file through shell script

Discussion started by: Dip

2. Shell Programming and Scripting

Filter data in Excel sheet using Shell Script

Discussion started by: bhanusri83

3. Shell Programming and Scripting

how to put data using shell script to a excel file

Discussion started by: siri_886

4. UNIX for Advanced & Expert Users

put data in excel file using shell script

Discussion started by: kanus