If its the Spreadsheet::WriteExcel which is generating the xls files.
you can force the values to be "string" with write_string method.
Probably you are using the write method which automatically resolves the datatype and set the property accordingly.
Hi Guys,
I'm a Perl newbie and was wondering if there's a way of displaying
double quotes within double quotes.
I'm try to print the contents of the variable to a file by using the system function.
Here is an example of my code:
#==============================
$website = <STDIN>;... (2 Replies)
I am having issue dispalying text file in browser using perl.
Here is my code:
#!/usr/bin/perl
print "content-type: text/html \n\n";
open (FH , "access.log") || die "Blah $!";
while (<FH>) {
print $_ ;
}
I have correct permissions and everything. The weired thing is when I... (1 Reply)
Don't know why this didn't get posted before but...
I am having issues displaying a log file in the browser using perl and I can't get it to display at all, All i get is WHITE (blank page). I have proper permissions in my cgi-bin directory and everywhere else. So I know that's NOT the issue. ... (3 Replies)
Hi,
My requirement is that I should search for a particular string and display the string only once if there is more occurrence of the same string in a file.
e.g In the given below log file,the string AMQ5037 comes twice.I want to search for this string and display it only once.grep will... (5 Replies)
Hi Friends,
I've an exponent value like,
$val="9.57669e-05";
I want to convert this value to floating point value in PERL scripting.
I tried googling for the solution, and also asked many perl friends. Unfortunately, I didn't get answer.
Could you please help me?
Thanks in advance... (4 Replies)
I am trying to write a script that raises a integer (m) by a exponent (n) using a while loop
ex. 5 raised to the power of 2 ..
I am a beginner and i dont know what is the opperand or command i have to use to make this happen..this is what i have so far...
echo "Enter a integer for the... (3 Replies)
Hi folks.
I am trying to script a query of a backup server that will display sessions that are "waiting" for a mount...
So for, i query my system which returns a process # that is waiting...
The output looks like this:
20,984 Backup Storage Pool Primary Pool T950_TAPE_WIN, Copy Pool... (3 Replies)
Hi,
I'm new to perl and i have to write a perl script that will compare to log/txt files and display the differences. Unfortunately I'm not allowed to use any complied binaries or applications like diff or comm.
So far i've across a code like this:
use strict;
use warnings;
my $list1;... (2 Replies)
I have input like this :
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 07-FEB-2012 04:19:45
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/t3local_apps/apps/oracle/product/11.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve... (3 Replies)
printf FH2" 3'b%b : begin\n",$i;
where i is an integer in the loop
is displaying
3'b1 : begin
expected output was
3'b001 : begin (1 Reply)
Discussion started by: dll_fpga
1 Replies
LEARN ABOUT DEBIAN
excel::template::element::cell
Excel::Template::Element::Cell(3pm) User Contributed Perl Documentation Excel::Template::Element::Cell(3pm)NAME
Excel::Template::Element::Cell - Excel::Template::Element::Cell
PURPOSE
To actually write stuff to the worksheet
NODE NAME
CELL
INHERITANCE
ELEMENT
ATTRIBUTES
o TEXT
This is the text to write to the cell. This can either be text or a parameter with a dollar-sign in front of the parameter name.
o COL
Optionally, you can specify which column you want this cell to be in. It can be either a number (zero-based) or an offset. See
Excel::Template for more info on offset-based numbering.
o REF
Adds the current cell to the a list of cells that can be backreferenced. This is useful when the current cell needs to be referenced
by a formula. See BACKREF and RANGE.
o WIDTH
Sets the width of the column the cell is in. The last setting for a given column will win out.
o TYPE
This allows you to specify what write_*() method will be used. The default is to call write() and let Spreadsheet::WriteExcel make the
right call. However, you may wish to override it. Excel::Template will not do any form of validation on what you provide. You are
assumed to know what you're doing.
The legal types (taken from Spreadsheet::WriteExcel) are:
o COMMENT
Add a comment to the cell
o blank
o formula
o number
o string
o url
o date_time
other write_* methods as defined defined Spreadsheet::WriteExcel would be integrated by request
CHILDREN
FORMULA
EFFECTS
This will consume one column in the current row.
DEPENDENCIES
None
USAGE
<cell text="Some Text Here"/>
<cell>Some other text here</cell>
<cell text="$Param2"/>
<cell>Some <var name="Param"> text here</cell>
In the above example, four cells are written out. The first two have text hard-coded. The second two have variables. The third and fourth
items have another thing that should be noted. If you have text where you want a variable in the middle, you have to use the latter form.
Variables within parameters are the entire parameter's value.
Please see Spreadsheet::WriteExcel for what constitutes a legal formula.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
ROW, VAR, FORMULA
perl v5.14.2 2012-04-29 Excel::Template::Element::Cell(3pm)