Sponsored Content
Full Discussion: Rename Worksheet
Top Forums Shell Programming and Scripting Rename Worksheet Post 302501482 by debasis.mishra on Thursday 3rd of March 2011 04:32:00 PM
Old 03-03-2011
Rename Worksheet

Hi,

What is the syntax to rename excel worksheet present in testing.xls

Suppose my excel name is testing.xls
The worksheet name is sheet1.

I want to change this worksheet name from sheet1 to TAB11.

Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

rename using mv ?

Hi all how can can remove the underscore from this number in this series _1234567.abc _1234567.abcd I was trying mv _1234567* 1234567 but did not work ? thanks s (2 Replies)
Discussion started by: simon2000
2 Replies

2. UNIX for Dummies Questions & Answers

how can I rename the following=-^

I have a file named -^, I want to look at it, rename, etc. Any help out there?? (5 Replies)
Discussion started by: nj78
5 Replies

3. Shell Programming and Scripting

rename

hi, im doin an assignment which requires you to build a shell script to do the MS DOS style equivilant (sp?) of the rename function. What i have to do is a loop which checks the following rules and output messages (same): Can't have anything after target Can't have more than one dot Can't... (1 Reply)
Discussion started by: bohoo
1 Replies

4. UNIX for Dummies Questions & Answers

need help with rename

hi guys i am writing a script to change the filename which is enterered as input to lower case letter even if one letter is upper case i have to change it to lower case i get the input and use sed comand should i use like that sed/s/a-z/A-Z/d will it be like that can u please help me (8 Replies)
Discussion started by: farhan_t49
8 Replies

5. Shell Programming and Scripting

Bulk rename

hi, my directory has the following files I want to rename or mv them as file 1 corresponds to new_1.bed, file2 to new_2.bed and so on. How do I do it using awk or bash? TIA (4 Replies)
Discussion started by: jacobs.smith
4 Replies

6. Shell Programming and Scripting

Convert xlsx worksheet to separate csv

Hi All, I need a solution to convert my .xlsx file which has lot of worksheet, convert to separate csv file. Is there any shell script to do this? I can’t use excel macro to do this, since it was password locked. I need the csv output as an input to my shell script. (1 Reply)
Discussion started by: ranjancom2000
1 Replies

7. Shell Programming and Scripting

Rename more than 1 file

Hi, I have multiple files in a directory e.g. file1.txt.gz file2.txt.gz file3.txt.gz and I want to rename them to: file1.dat.gz file2.dat.gz file3.dat.gz I don't have 'rename' command on my system. Thanks! (4 Replies)
Discussion started by: apenkov
4 Replies

8. Shell Programming and Scripting

Redirect the output to different worksheet in excel

Hi, I need to redirect of a script to different worksheet in a single excel file. I have four queries in that script. Each query output needs to be placed in separate worksheet of a excel file. can someone help me to find this? (10 Replies)
Discussion started by: Arasu
10 Replies

9. UNIX for Dummies Questions & Answers

Using rename

I want to rename files Files show like this 1977SSD_rsdtst.pdf 1976SDP_rstdtsr.pdf 1943FDT_rstdsrt.pdf 1996DFF_stdstrd.pdf I want to introduce _ after the year, and move the characters to the end to get 1977_rsdtst_SSD.pdf 1976_rstdtsr_SDP.pdf 1943_rstdsrt_FDT.pdf... (4 Replies)
Discussion started by: kristinu
4 Replies

10. Shell Programming and Scripting

Using rename

Renaming files using rename on the following files rename 's/.99999/.99999.sac.pzs/g' *.99999 sac_pzs_iv_esml_hhz__2013.074.10.18.23.0000_2599.365.23.59.59.99999 sac_pzs_iv_favr_hhe__2010.187.00.00.00.0000_2599.365.23.59.59.99999... (1 Reply)
Discussion started by: kristinu
1 Replies
Excel::Template::Container::KeepLeadingZeros(3pm)	User Contributed Perl Documentation	 Excel::Template::Container::KeepLeadingZeros(3pm)

NAME
Excel::Template::Container::KeepLeadingZeros - Excel::Template::Container::KeepLeadingZeros PURPOSE
To set the keep_leading_zeros flag for the surrounding worksheet or any worksheets that might be contained within this node. NODE NAME
KEEP_LEADING_ZEROS INHERITANCE
CONTAINER ATTRIBUTES
None CHILDREN
None EFFECTS
Alters how leading zeros are interpreted by Spreadsheet::WriteExcel. DEPENDENCIES
None USAGE
<worksheet> ... Cells here will NOT have leading-zeros preserved <keep_leading_zeros> ... Cells here will have leading-zeros preserved </keep_leading_zeros> ... Cells here will NOT have leading-zeros preserved </worksheet> <keep_leading_zeros> <worksheet> ... Cells here will have leading-zeros preserved </worksheet> <worksheet> ... Cells here will have leading-zeros preserved </worksheet> </keep_leading_zeros> AUTHOR
Rob Kinyon (rob.kinyon@gmail.com) SEE ALSO
CELL, Spreadsheet::WriteExcel perl v5.14.2 2010-06-17 Excel::Template::Container::KeepLeadingZeros(3pm)
All times are GMT -4. The time now is 09:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy