Excel files are BIFF format files - they don't have any special 'identifying' string.
Attached is the WORD binary file format.
Neither is very helpful. You can try Wotsit.org for more details.
AFAIK windows actually uses the extension to determine what app to to use to open
XLS and DOC files.
Hi All,
I'm a rookie using HPUX and I know this is going to sound like a bonehead question, but when I list the contents of a directory, how can I determine which objects are files and which are folders? I'm using the ll and ls commands to lists the contents. So far I've been determining the... (6 Replies)
Hi,
I am using Solaris 8. My script outputs 4 .csv files. Currently I am SFTPing the files and creating a new excel file with the 4 files as sheets.
Can anyone suggest ways to do this in UNIX ?
Thanks,
David. (2 Replies)
Hi all,
I am faced with a rather unusual problem regarding interaction between NT and UNIX. I am using an ETL (Extract-Transform-Load) tool on unix that has the capability to read .xls files. So, when I FTP an excel (.xls) file from a windows server to unix and attempt to read it with this... (3 Replies)
Hello
I have an excel file , it has 4 tabs , each having specific details
for example it has a customer tab , it has a payments tab and it has an address tab
Question is
How do I seperate each of these tabs and load them into 3 different excel files Using Unix
That is the... (2 Replies)
Hi All,
I am new to this unix stuff.I just have one doubt:suppose i have two tar files and sometimes it happens that when we just check these files from outside these two tar files look same
"Eg:
ls -lrt
drw-r--r-- 1 oasis logadmin 37067 Apr 3 05:48 file1.tar
drw-r--r-- 1 oasis ... (7 Replies)
Hi All
I need to put 5 different files from Unix box in 5 different tabs in a single excel. For this, I need to code only using Unix.
Kindly help me on this.
---------- Post updated at 07:23 AM ---------- Previous update was at 06:24 AM ----------
Hi All
I need to put 5 different... (2 Replies)
how to differentiate between two machine in Unix,whether it is logged in from local machine or from Server( both may be 2 or more).
Please help. (5 Replies)
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Hello All,
I have 2 Type of files.
1. MYTEST001_RKP_DORALDO_20150402120000.zip
2. CMP001_STD001_MOGANO_RPSL_20150409_C.zip
I can receive these Two type of file at one location.
If i receive second type of file
CMP001_STD001_MOGANO_RPSL_20150409_C.zip I have to process without... (9 Replies)
Discussion started by: yadavricky
9 Replies
LEARN ABOUT DEBIAN
excel::template::element::backref
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)