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::Element::Formula(3pm) User Contributed Perl Documentation Excel::Template::Element::Formula(3pm)NAME
Excel::Template::Element::Formula - Excel::Template::Element::Formula
PURPOSE
To write formulas to the worksheet
NODE NAME
FORMULA
INHERITANCE
Excel::Template::Element::Cell
ATTRIBUTES
All attributes a CELL can have, a FORMULA can have, including the ability to be referenced using the 'ref' attribute.
CHILDREN
None
EFFECTS
This will consume one column on the current row.
DEPENDENCIES
None
USAGE
<formula text="=(1 + 2)"/>
<formula>=SUM(A1:A5)</formula>
<formula text="$Param2"/>
<formula>=(A1 + <var name="Param">)</formula>
In the above example, four formulas are written out. The first two have the formula hard-coded. The second two have variables. The third
and fourth items have another thing that should be noted. If you have a formula where you want a variable in the middle, you have to use
the latter form. Variables within parameters are the entire parameter's value.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
CELL
perl v5.14.2 2010-06-17 Excel::Template::Element::Formula(3pm)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)