Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to handle Microsoft Excel in Linux Scripting

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to handle Microsoft Excel in Linux Scripting
Prev   Next
# 1  
Old 02-04-2008
How to handle Microsoft Excel in Linux Scripting
Hi,

I am having a Excel sheets with 4 columns and 50 rows.
I need a script which check Date columns in excel sheet and then replace few cells with the random number (based on a date check operator).

I then need the excel sheet back to my window system, where is Linux is the remote system.

Thanks
 
Login or Register to Ask a Question

Previous Thread | Next Thread

2 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Read microsoft excel in Unix

Hey guys, Can we read a microsoft excel spreadsheet in Unix / linux. If so, what are the steps to be followed? I know we can convert the excel workbook as a CSV and then read it in unix. Are there any other direct methods? thanks prasan81 (2 Replies)
Discussion started by: prasan81
2 Replies

2. Shell Programming and Scripting

How to handle case insensitive in shell scripting

Hi All, I am new to this forum also new to shell scripting. I have a requirement to read a text from a file which can be in any case like LOGFILE or LogFile or logfile or lOgfILE etc.. Can you guys help me out. Thanks, Bacsi01 (1 Reply)
Discussion started by: bacsi01
1 Replies
Login or Register to Ask a Question

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)