Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

excel::template::container::keepleadingzeros(3pm) [debian man page]

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)

Check Out this Related Man Page

Excel::Template::Container::Loop(3pm)			User Contributed Perl Documentation		     Excel::Template::Container::Loop(3pm)

NAME
Excel::Template::Container::Loop - Excel::Template::Container::Loop PURPOSE
To provide looping NODE NAME
LOOP INHERITANCE
Excel::Template::Container ATTRIBUTES
o NAME This is the name of the loop. It's used to identify within the parameter set what variables to expose to the children nodes each iteration. CHILDREN
None EFFECTS
None DEPENDENCIES
None USAGE
<loop name="LOOPY"> ... Children here ... </loop> In the above example, the children nodes would have access to the LOOPY array of hashes as parameters. Each iteration through the array would expose a different hash of parameters to the children. These loops work just like HTML::Template's loops. (I promise I'll give more info here!) There is one difference - I prefer using Perl-like scoping, so accessing of variables outside the LOOP scope from within is perfectly acceptable. You can also hide outside variables with inner values, if you desire, just like Perl. AUTHOR
Rob Kinyon (rob.kinyon@gmail.com) SEE ALSO
perl v5.14.2 2012-04-29 Excel::Template::Container::Loop(3pm)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove O and preceeding zeros in a string

Hi all, Can anybody help me out to write a program in perl to remove O and preceeding zeros. for eg input is O0000123089 - output 123089 Thanks Mahalakshmi.A (10 Replies)
Discussion started by: mahalakshmi
10 Replies

2. Shell Programming and Scripting

Help needed in padding leading zeros

Hi all, I have file with numeric values. I need to pad each value with leading zeros such that total lenght of each value is 16. Example: cat tmp.txt 502455 50255 5026 5027 5028 Output 0000000000502455 0000000000050255 0000000000005026 0000000000005027 0000000000005028 Any... (12 Replies)
Discussion started by: jakSun8
12 Replies

3. Shell Programming and Scripting

Gawk / Awk Merge Lines based on Key

Hi Guys, After windows died on my netbook I installed Lubuntu and discovered Gawk about a month ago. After using Excel for 10+ years I'm amazed how quick and easily Gawk can process data but I'm stuck with a little problem merging data from multiple lines. I'm an SEO Consultant and provide... (9 Replies)
Discussion started by: Jamesfirst
9 Replies

4. Shell Programming and Scripting

Removing leading zeros for a decimal column

removing leading zeros for a decimal column in a file which has string & decimal values ,,,,,6630140,XXXXXXXXXXXXXXX, 0020.00,USA ,,,,,6630150,XXXXXXXXXXXXXXXL (xyz, 0010.00,USA ,,,,,6630150,XXXXXXXXXXXXXXX(xyz), 1300.00,USA My file contains 9 columns. Out 9 columns, 8th column contains the... (9 Replies)
Discussion started by: marpadga18
9 Replies

5. Shell Programming and Scripting

How to use correctly Spreadsheet::WriteExcel to convert xml to xls

Hi to all, I want to convert xml file to binary Excel file, after googling for a while, I found cpan tool "Spreadsheet::WriteExcel::FromXML". I installed both, Spreadsheet::WriteExcel and Spreadsheet::WriteExcel::FromXML. To test Spreadsheet::WriteExcel I executed a example script that... (8 Replies)
Discussion started by: Ophiuchus
8 Replies

6. Shell Programming and Scripting

Remove trailing zeros

Hi I have a simple request but can't find the answer. I want to remove trailing zeros, and in some cases the fullstops, from the input data. Example of input file: FR002_15.000_20.000 SD475_5.000_10.500 FG5647_12.250_15.500 BH2463_30.555_32.000 Desired output file would be: ... (10 Replies)
Discussion started by: theflamingmoe
10 Replies

7. 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

8. Shell Programming and Scripting

Help deleting leading zeros in a file

I have a list of numbers extracted and need to delete the leading zeros from them, but when i do so, the command I am using also deletes numbers that end in Zero as well. eg 10, 20, 30, etc this is part of a larger script and the only way I can think of is to try and detect the 10,20 30 etc in... (19 Replies)
Discussion started by: kcpoole
19 Replies

9. UNIX for Dummies Questions & Answers

Remove zeros from first field, but print all fields

Hello Everyone, I've got a comma-delimited file that looks like this: 0012,123 ,456 ,05/12/2014 0123,525 ,286 ,05/12/2014 0456,791 ,300 ,05/12/2014 1095,759 ,300 ,05/12/2014 1344,576 ,292 ,05/12/2014 1558,551 ,283 ,05/12/2014 002183719, , ... (9 Replies)
Discussion started by: Scottie1954
9 Replies

10. Windows & DOS: Issues & Discussions

Run UNIX Script from Excel

How to run scripts from Excel and bring results back to excel? (10 Replies)
Discussion started by: santoshdrkr
10 Replies

11. Shell Programming and Scripting

Reading specific range of columns in an Excel file

Hi All, I want to read an excel file. PFA excel, I want to read the cloumn from A to G and the V to AH starting from Row number 3. Please help me on this. (7 Replies)
Discussion started by: Abhisrajput
7 Replies

12. Shell Programming and Scripting

Writing a script that creates a 1GB file with zeros using dd

I am new to Linux. Using latest version of Ubuntu. I want to make a script that creates a 1GB file filled with zeros using dd and then formats the file as vfat with a label of "MYFILE". If anyone can help me it would be appreciated. (9 Replies)
Discussion started by: paviter619
9 Replies

13. UNIX for Beginners Questions & Answers

Remove trailing zeros from numbers

Hi, I am trying to remove trailing zeros from numbers in a csv file. CSV Input : 0.5000,abc,2.00,2.400,285.850,285a.850,205.180800,mno000,a0b0,2.860 Expected Output : .5,abc,2,2.4,285.85,285a.850,205.1808,mno000,a0b0,2.86 Can you please help. Thanks. (11 Replies)
Discussion started by: manubatham20
11 Replies

14. Shell Programming and Scripting

Please help - Command to Subtract two numbers without losing prefix zeros

Hello, I have a variable LOGNUM with values 0000095, When i subtract the variable by 1, Its losing its leading zeros. Can you please help me here ? LOGNUM=0000095 $OLDLOG=`echo "${LOGNUM}-1"|bc` $ echo $OLDLOG 94 Am expecting output as 0000094 Appreciate your help! Thanks,... (11 Replies)
Discussion started by: prince1987
11 Replies

15. Shell Programming and Scripting

Exanding an array into another file.

Hi I have a text file that I need use as a osascript to format some Excel files. My commands are working between the osascript and Excel but what I would like to do is format the text file with an array. Is there a way to expand the array variables into another text file while still retaining... (9 Replies)
Discussion started by: Paul Walker
9 Replies