excel::template::element::backref(3pm) [debian man page]
Excel::Template::Element::Backref(3pm) User Contributed Perl Documentation Excel::Template::Element::Backref(3pm)NAME
Excel::Template::Element::Backref - Excel::Template::Element::Backref
PURPOSE
Returns the cell location (i.e. B2) of the last cell to name this reference. To return the location of the entire range of cells to name
this reference see RANGE.
NODE NAME
BACKREF
INHERITANCE
Excel::Template::Element
ATTRIBUTES
o REF
This is the name of the reference to look up.
CHILDREN
None
EFFECTS
None
DEPENDENCIES
This will only be used within CELL tags.
USAGE
In the example...
<row>
<cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
</row>
<row>
<formula>=<backref ref="this_cell">+<backref ref="that_cell"></formula>
</row>
The formula in row 2 would be =A1+C1. C1 is the last to reference "that_cell".
AUTHOR
Rob Kinyon (rkinyon@columbus.rr.com)
SEE ALSO
CELL, RANGE
perl v5.14.2 2012-04-29 Excel::Template::Element::Backref(3pm)
Check Out this Related Man Page
Excel::Template::Element::Image(3pm) User Contributed Perl Documentation Excel::Template::Element::Image(3pm)NAME
Excel::Template::Element::Image - Excel::Template::Element::Image
PURPOSE
To insert an image into the worksheet
NODE NAME
IMAGE
INHERITANCE
ELEMENT
EFFECTS
This will consume one column in the current row.
DEPENDENCIES
None
USAGE
<image path="/Some/Full/Path" />
<image path="/Some/Full/Path" offset="2,5" />
<image path="/Some/Full/Path" scale="2,0.4" />
<image path="/Some/Full/Path" offset="4,0" scale="0,2" />
Please see "" in Spreadsheet::WriteExcel for more information about the offset and scaling options as well as any other restrictions that
might be in place. This node does NOT perform any sort of validation upon your parameters. You are assumed to know what you are doing.
Note that the offset and scaling values are "X,Y". You must provide both values, even if the Y value is 0. If you provide a 0 value for
either scaling option, "" in Spreadsheet::WriteExcel will default that to 1.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
Nothing
perl v5.14.2 2010-06-17 Excel::Template::Element::Image(3pm)
Hi all,
I want to open an Excel file in Unix(ABC.xls) and copy one column of the file onto another text file (xyz.txt) .Please let me know if there is a way of going about to perform this operation.
Thanks in Advance,
bubeshj (5 Replies)
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)
I can convert a excel file to another format , for example text type ( TXT) whit anoter caracter from delimiter a rows ???
I can change the default delimiter " | " ( or space ) of cell to another caracter ( for example @@ or ## ) without change the other space ??? (6 Replies)
Dear folks,
Need a help in Excel processing, I have a sheet which need to be changed to a format as below:
Name Eng Hin SS
A 100 90 83
B 76 99 90
C 55 34 78
Want the above sheet to below format
Name Sub Marks
A Eng 100
... (5 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)
Hello,
I have received very much needed help in the past from this forum and hope that someone can assist me once more. I am in the military and I am tracking classroom specific training for each one of our units per sailor in that unit. I am attaching the spreadsheet for your review. There are... (5 Replies)
Hi,
I am looking for an AWK or grep script (join will not work here since the data is not sorted) to combine two Excel files that look lke this:
Infile1:
Georgia Atlanta 1234 1234
Georgia Marrieta 2134 2134
Georgia Scottdale 3414 3414
Georgia Clarkston 2321 2321
Infile2:
... (6 Replies)
Hello,
Im trying to work on a small script for a formula converting temperatures, Celsius to fahrenheit.
I have a formula, and it works.... it works every way I try it. But it keeps giving me the wrong results every time with expr.
The formula for C to F would be:
divide by 5, multiply by... (12 Replies)
Input file
2 5 ASFGEWTEWRQWEQ
10 20 QEWIORUEIOUEWORUQWEQWRQRQWGQWGFQ
1 6 WRQTQWTQTQWTQT
Desired output file
2 5 ASFGEWTEWRQWEQ
10 20 QEWIORUEIOUEWORUQWEQWRQRQWGQWGFQ
1 6 WRQTQWTQTQWTQT
Column 1 is the start region of underline the text in column 3;
Column 2 is the end region of... (13 Replies)
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 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)
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)