Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Add columns to an existing excel sheet Post 302536866 by arunmanas on Wednesday 6th of July 2011 11:47:14 AM
Old 07-06-2011
Add columns to an existing excel sheet

Hi All,

i have an excel sheet as below:

day
-----
monday
tuesday
wenesday
thursday
friday

i need to append the two more columns in this existing file below:

insert date should be todays date---

day insert date insert user
---- ---------- -----------

monday sysdate arun
tuesday sysdate arun
wenesday sysdate arun
thursday sysdate arun
friday sysdate arun

please advise..

thanks in advance..
Arun Manas
 

10 More Discussions You Might Find Interesting

1. HP-UX

Creating Excel Sheet in Hp-UX

Dear Members, How do I create an eqvivalant of Excel sheet in Hp-UX. Is there any application like the Microsoft Excel on HP-UX. How do I invoke it. Regards, PrasadKVS (5 Replies)
Discussion started by: KVSPRASAD
5 Replies

2. Shell Programming and Scripting

writeExcelXML will work on existing excel sheet

I want to know that will SpreadSheet::WriteExcelXML will work on the existing excel file. (1 Reply)
Discussion started by: akash
1 Replies

3. Shell Programming and Scripting

How to update existing excel sheet using shell script

Hi All, I am having an excel sheet with pre-defined format which our business team specified, what i need to do is i have to write a script which need to pick values from database and update specified cells in excel sheet.. can any one please help me in this regard.. I am able to pull the... (3 Replies)
Discussion started by: balanarendra
3 Replies

4. Solaris

Excel sheet

Hello, I have an information of about 100 odd file names which i have in my server. I need to attach this information in an excel sheet and sent to the concerned team. I use uuencode for attaching a text file. But how will i have all the information in attachment. Please assist. Is there... (1 Reply)
Discussion started by: venkidhadha
1 Replies

5. Shell Programming and Scripting

Pdf to excel sheet??

Hi everyone, I want a shellscript code that takes an pdf as input and returns the data in the pdf into an excel sheet... Thanks, C10 (3 Replies)
Discussion started by: Carlton
3 Replies

6. Shell Programming and Scripting

Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)

Hi folks, I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx). Spreadsheet contains few lines of hyperlink data (pic attached). P.S. Hyperlink is behind the data and not visible in excel sheet directly. Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies

7. Shell Programming and Scripting

Format Excel sheet

Hi, I want to format Excel sheet through Unix script. Format would mean bolding the data in the cell, adding clor to it etc. Please help me if it is possible through Unix scripting? Thanks, Durga (2 Replies)
Discussion started by: Durga Prasad NK
2 Replies

8. Windows & DOS: Issues & Discussions

Comparing two columns in same Excel sheet

Hi, I have a great doubt in Lotus Symphony Spread Sheet (Hope its similar to Excel) Am new to this Lotus Symphony Please tell me a formula to compare two columns in Excel (Lotus Symphony Spread Sheet) The columns contain strings. Eg., "Column E" and "Column AO" needs to be compared Like... (1 Reply)
Discussion started by: Priya Amaresh
1 Replies

9. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies

10. Shell Programming and Scripting

Add new columns based on existing columns

Hi all, I am kind of stuck with printing my desired output. Please help me if you know how it can work. My input file(tab separated): NW_0068.1 41,16 100,900 NW_0699.1 4,2,19 200,700,80 My Output file (desired): NW_0068.1 41,16 100,900 100 - 141 NW_0068.1 41,16 100,900 ... (3 Replies)
Discussion started by: sam_2921
3 Replies
BACKUP_LISTDUMPS(8)					       AFS Command Reference					       BACKUP_LISTDUMPS(8)

NAME
backup_listdumps - Displays the dump hierarchy from the Backup Database SYNOPSIS
backup listdumps [-localauth] [-cell <cell name>] [-help] backup listd [-l] [-c <cell name>] [-h] DESCRIPTION
The backup listdumps command displays the dump hierarchy from the Backup Database. OPTIONS
-localauth Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The backup command interpreter presents it to the Backup Server, Volume Server and VL Server during mutual authentication. Do not combine this flag with the -cell argument. For more details, see backup(8). -cell <cell name> Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see backup(8). -help Prints the online help for this command. All other valid options are ignored. OUTPUT
The output displays the complete dump hierarchy and indicates the relationship between full and incremental dump levels. Full dump levels appear at the left margin. The hierarchy can include more than one full dump level; each one defines a subhierarchy of dump levels that can be used for dumping different volume sets. Incremental dump levels appear below and indented to the right of their parent dump levels, which can be either full or incremental. Since multiple incremental dump levels can share the same parent, an incremental dump level is not always directly below its parent; the amount of indentation indicates the parent/child relationship. If a dump level has an associated expiration date, it appears along with the level name. Absolute expiration dates appear in the format <dump_level> expires at <day month date time year> and relative expiration dates in the format <dump_level> expires in {<years>y | <months>m | <days>d} to indicate the number of years, months, days, or combination of the three after creation a dump expires when created at this level. EXAMPLES
The following example depicts six dump hierarchies. The expiration date for all incremental dump levels is 13 days so that the corresponding tapes can be recycled two weeks after their creation. The expiration dates for all full dump levels is 27 days so that the corresponding tapes can be recycled four weeks after their creation. % backup listdumps /week1 expires in 27d /tuesday expires in 13d /thursday expires in 13d /sunday expires in 13d /tuesday expires in 13d /thursday expires in 13d /week3 expires in 27d /tuesday expires in 13d /thursday expires in 13d /sunday expires in 13d /tuesday expires in 13d /thursday expires in 13d /sunday1 expires in 27d /monday1 expires in 13d /tuesday1 expires in 13d /wednesday1 expires in 13d /thursday1 expires in 13d /friday1 expires in 13d /sunday2 expires in 27d /monday2 expires in 13d /tuesday2 expires in 13d /wednesday2 expires in 13d /thursday2 expires in 13d /friday2 expires in 13d /sunday3 expires in 27d /monday1 expires in 13d /tuesday1 expires in 13d /wednesday1 expires in 13d /thursday1 expires in 13d /friday1 expires in 13d /sunday4 expires in 27d /monday2 expires in 13d /tuesday2 expires in 13d /wednesday2 expires in 13d /thursday2 expires in 13d /friday2 expires in 13d PRIVILEGE REQUIRED
The issuer must be listed in the /etc/openafs/server/UserList file on every machine where the Backup Server is running, or must be logged onto a server machine as the local superuser "root" if the -localauth flag is included. SEE ALSO
backup(8), backup_adddump(8), backup_deldump(8) COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved. This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell. OpenAFS 2012-03-26 BACKUP_LISTDUMPS(8)
All times are GMT -4. The time now is 03:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy