Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

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)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Opening an Excel File in Unix

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)
Discussion started by: bubeshj
5 Replies

2. HP-UX

Creating Excel Sheet in Hp-UX

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)
Discussion started by: KVSPRASAD
5 Replies

3. HP-UX

Conver Excel file to another format ( text)

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)
Discussion started by: ZINGARO
6 Replies

4. Shell Programming and Scripting

How to edit particular cell of csv file using shell script

I have one csv file and in that I want update particular cell. I know the row and coloumn number for that respective. Please help me... (6 Replies)
Discussion started by: deepak_p86
6 Replies

5. Shell Programming and Scripting

Excel formatting

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)
Discussion started by: shaliniyadav
5 Replies

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

7. Windows & DOS: Issues & Discussions

Excel

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)
Discussion started by: Maggiepie
5 Replies

8. UNIX for Dummies Questions & Answers

Combining information from Excel files

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)
Discussion started by: Xterra
6 Replies

9. Shell Programming and Scripting

Can expr deal with decimals?

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)
Discussion started by: hxdrummerxc
12 Replies

10. Shell Programming and Scripting

Help with underline text based on specific region

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)
Discussion started by: cpp_beginner
13 Replies

11. Shell Programming and Scripting

Writing excel file using perl : Excel file formatting changed

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)
Discussion started by: mud_born
7 Replies

12. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

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)
Discussion started by: dani1234
6 Replies

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

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

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