How to solve formate peroblem

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check time stamp formate in file

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

2. Shell Programming and Scripting

csh if loop variable condition check peroblem

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

3. UNIX for Dummies Questions & Answers

Can somebody solve this

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

4. UNIX for Advanced & Expert Users

Can somebody solve this

5. Shell Programming and Scripting

Can somebody solve this please

6. Programming

does any one know how to solve?

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

7. UNIX for Dummies Questions & Answers

formate file in unix

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

8. Shell Programming and Scripting

How to solve this

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

LEARN ABOUT DEBIAN

spreadsheet::xlsx

Spreadsheet::XLSX(3pm)					User Contributed Perl Documentation				    Spreadsheet::XLSX(3pm)

NAME

       Spreadsheet::XLSX - Perl extension for reading MS Excel 2007 files;

SYNOPSIS

	use Text::Iconv;
	my $converter = Text::Iconv -> new ("utf-8", "windows-1251");

	# Text::Iconv is not really required.
	# This can be any object with the convert method. Or nothing.

	use Spreadsheet::XLSX;

	my $excel = Spreadsheet::XLSX -> new ('test.xlsx', $converter);

	foreach my $sheet (@{$excel -> {Worksheet}}) {

	       printf("Sheet: %s
", $sheet->{Name});

	       $sheet -> {MaxRow} ||= $sheet -> {MinRow};

		foreach my $row ($sheet -> {MinRow} .. $sheet -> {MaxRow}) {

		       $sheet -> {MaxCol} ||= $sheet -> {MinCol};

		       foreach my $col ($sheet -> {MinCol} ..  $sheet -> {MaxCol}) {

			       my $cell = $sheet -> {Cells} [$row] [$col];

			       if ($cell) {
				   printf("( %s , %s ) => %s
", $row, $col, $cell -> {Val});
			       }

		       }

	       }

	}

DESCRIPTION

       This module is a (quick and dirty) emulation of Spreadsheet::ParseExcel for Excel 2007 (.xlsx) file format.  It supports styles and many of
       Excel's quirks, but not all.  It populates the classes from Spreadsheet::ParseExcel for interoperability; including Workbook, Worksheet,
       and Cell.

SEE ALSO

       Text::CSV_XS, Text::CSV_PP
	 http://search.cpan.org/~hmbrand/

	 A pure perl version is available on http://search.cpan.org/~makamaka/

       Spreadsheet::ParseExcel
	 http://search.cpan.org/~kwitknr/

       Spreadsheet::ReadSXC
	 http://search.cpan.org/~terhechte/

       Spreadsheet::BasicRead
	 http://search.cpan.org/~gng/ for xlscat likewise functionality (Excel only)

       Spreadsheet::ConvertAA
	 http://search.cpan.org/~nkh/ for an alternative set of cell2cr () / cr2cell () pair

       Spreadsheet::Perl
	 http://search.cpan.org/~nkh/ offers a Pure Perl implementation of a spreadsheet engine. Users that want this format to be supported in
	 Spreadsheet::Read are hereby motivated to offer patches. It's not high on my todo-list.

       xls2csv
	 http://search.cpan.org/~ken/ offers an alternative for my "xlscat -c", in the xls2csv tool, but this tool focusses on character encoding
	 transparency, and requires some other modules.

       Spreadsheet::Read
	 http://search.cpan.org/~hmbrand/ read the data from a spreadsheet (interface module)

AUTHOR

       Dmitry Ovsyanko, <do@eludia.ru<gt>, http://eludia.ru/wiki/

       Patches by:

	       Steve Simms
	       Joerg Meltzer
	       Loreyna Yeung
	       Rob Polocz
	       Gregor Herrmann
	       H.Merijn Brand
	       endacoe
	       Pat Mariani
	       Sergey Pushkin

ACKNOWLEDGEMENTS

	       Thanks to TrackVia Inc. (http://www.trackvia.com) for paying for Rob Polocz working time.

COPYRIGHT AND LICENSE

       Copyright (C) 2008 by Dmitry Ovsyanko

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or,
       at your option, any later version of Perl 5 you may have available.

perl v5.10.1							    2010-05-16						    Spreadsheet::XLSX(3pm)

Shell Programming and Scripting