8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have to check whether last line of the file has time stamp or not.
File.txt
cong = 0
This formats a date and time into the given strftime() format = 09
Dates can be passed to Smarty as unix timestamps = 56789
mysql timestamps or any string made up =98
Since Smarty-2.6.10 numeric... (4 Replies)
Discussion started by: Roozo
4 Replies
2. Shell Programming and Scripting
Hi,
I have variables like
var1
var2
var3
var4
in
if loop i am trying to check the condition
if(variable == "var") then
echo $variable
endif (0 Replies)
Discussion started by: vasanth.vadalur
0 Replies
3. UNIX for Dummies Questions & Answers
I have to find the files older than 200 days from a path and copy them to some other directory with the current date stamp attached to it.
i have written like follows:
#!/bin/ksh
DSTAMP=$(date +"%y%m%d%H%M")
rm $CA_OUT_PATH/ftp_logs/temp
touch $CA_OUT_PATH/ftp_logs/temp
chmod 777... (13 Replies)
Discussion started by: sreenusola
13 Replies
4. UNIX for Advanced & Expert Users
I have to find the files older than 200 days from a path and copy them to some other directory with the current date stamp attached to it.
i have written like follows:
#!/bin/ksh
DSTAMP=$(date +"%y%m%d%H%M")
rm $CA_OUT_PATH/ftp_logs/temp
touch $CA_OUT_PATH/ftp_logs/temp
chmod 777... (1 Reply)
Discussion started by: sreenusola
1 Replies
5. Shell Programming and Scripting
I have to find the files older than 200 days from a path and copy them to some other directory with the current date stamp attached to it.
i have written like follows:
#!/bin/ksh
DSTAMP=$(date +"%y%m%d%H%M")
rm $CA_OUT_PATH/ftp_logs/temp
touch $CA_OUT_PATH/ftp_logs/temp
chmod 777... (1 Reply)
Discussion started by: sreenusola
1 Replies
6. Programming
Hello experts,
Here is my code.I can create the database.But I also want it to see standard output.Please see the blocked code.If i use them they show me weired symbols.
#include <stdio.h>
#include <stdlib.h>
struct date {
int month;
int day;
int year;
};
struct empRec{... (14 Replies)
Discussion started by: mlhazan
14 Replies
7. UNIX for Dummies Questions & Answers
my file looks like this:
D8511049777 I 04/10/08 99817 1,923.33 927156 Kaufman
D8511049777I04100829981859003924884Martin
i'd like to look like this:
D8511049777I0410080000299817000000192333927156Kaufman
D8511049777I0410080000299818000000059003924884Martin
my spec sheet:
D: starting... (4 Replies)
Discussion started by: tjmannonline
4 Replies
8. Shell Programming and Scripting
I have to write an script for..
CUST: 123 trans:
some contents
CUST: 1234 trans:
some contents
Now wat i have to do is this:
CUST:123 akash trans:
some contents
CUST:1234 akash1 trans:
I have been able to add... (3 Replies)
Discussion started by: akashag22
3 Replies
Spreadsheet::ParseExcel::Workbook(3pm) User Contributed Perl Documentation Spreadsheet::ParseExcel::Workbook(3pm)
NAME
Spreadsheet::ParseExcel::Workbook - A class for Workbooks.
SYNOPSIS
See the documentation for Spreadsheet::ParseExcel.
DESCRIPTION
This module is used in conjunction with Spreadsheet::ParseExcel. See the documentation for Spreadsheet::ParseExcel.
Methods
The following Workbook methods are available:
$workbook->worksheets()
$workbook->worksheet()
$workbook->worksheet_count()
$workbook->get_filename()
$workbook->get_print_areas()
$workbook->get_print_titles()
$workbook->using_1904_date()
worksheets()
The "worksheets()" method returns an array of Worksheet objects. This was most commonly used to iterate over the worksheets in a workbook:
for my $worksheet ( $workbook->worksheets() ) {
...
}
worksheet()
The "worksheet()" method returns a single "Worksheet" object using either its name or index:
$worksheet = $workbook->worksheet('Sheet1');
$worksheet = $workbook->worksheet(0);
Returns "undef" if the sheet name or index doesn't exist.
worksheet_count()
The "worksheet_count()" method returns the number of Woksheet objects in the Workbook.
my $worksheet_count = $workbook->worksheet_count();
get_filename()
The "get_filename()" method returns the name of the Excel file of "undef" if the data was read from a filehandle rather than a file.
my $filename = $workbook->get_filename();
get_print_areas()
The "get_print_areas()" method returns an array ref of print areas.
my $print_areas = $workbook->get_print_areas();
Each print area is as follows:
[ $start_row, $start_col, $end_row, $end_col ]
Returns undef if there are no print areas.
get_print_titles()
The "get_print_titles()" method returns an array ref of print title hash refs.
my $print_titles = $workbook->get_print_titles();
Each print title array ref is as follows:
{
Row => [ $start_row, $end_row ],
Column => [ $start_col, $end_col ],
}
Returns undef if there are no print titles.
using_1904_date()
The "using_1904_date()" method returns true if the Excel file is using the 1904 date epoch instead of the 1900 epoch.
my $using_1904_date = $workbook->using_1904_date();
The Windows version of Excel generally uses the 1900 epoch while the Mac version of Excel generally uses the 1904 epoch.
Returns 0 if the 1900 epoch is in use.
AUTHOR
Maintainer 0.40+: John McNamara jmcnamara@cpan.org
Maintainer 0.27-0.33: Gabor Szabo szabgab@cpan.org
Original author: Kawai Takanori kwitknr@cpan.org
COPYRIGHT
Copyright (c) 2009-2010 John McNamara
Copyright (c) 2006-2008 Gabor Szabo
Copyright (c) 2000-2006 Kawai Takanori
All rights reserved.
You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.
perl v5.10.1 2010-09-17 Spreadsheet::ParseExcel::Workbook(3pm)