problem with "merge_range" in Spreadsheet::WriteExcel" module

9 More Discussions You Might Find Interesting

1. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ...

2. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing...

3. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing �To� e-mail address and column 3 contains �cc� e-mail address to include with same email. Sample input file, email.txt Below is an sample code where...

4. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz

5. Programming

extract the same format from existing excel file using " Spreadsheet::ParseExcel " module

Hi , can any one tell me,"How to extract the same format from existing excel file to new excel file " using Spreadsheet::WriteExcel or Spreadsheet::ParseExcel module ??? Example_pgm: Below program is used to read existing excel file..In this program "my $cell = $_;" line is used to...

6. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone...

7. UNIX for Advanced & Expert Users

A question/problem about oracle "tns listener" and "enterprise manager"

hi, I have a problem about the Oracle related components. I'm not able to find any answer yet, and waiting for your responses... Here is the configuration of my system: * an IBM P550 machine, * an AIX 5.3 running on it and * an oracle database, already installed on it. The problem (or...

8. UNIX and Linux Applications

A question/problem about oracle "tns listener" and "enterprise manager"

hi, I have * an IBM P550 machine, * an AIX 5.3 running on it and * an oracle database, already installed on it. The problem (or question of my own) is: Oracle tns listener, "CT_LISTENER", and the enterprise manager (EM) of the instance, which is uniq instance and called...

9. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha

LEARN ABOUT DEBIAN

text::csv::encoded::coder::encodeguess

Text::CSV::Encoded::Coder::EncodeGuess(3pm)		User Contributed Perl Documentation	       Text::CSV::Encoded::Coder::EncodeGuess(3pm)

NAME

       Text::CSV::Encoded::Coder::EncodeGuess - Text::CSV::Encoded coder class using Encode::Guess

SYNOPSIS

	   use Text::CSV::Encoded  coder_class => 'Text::CSV::Encoded::Coder::EncodeGuess';
	   use Spreadsheet::ParseExcel;

	   my $csv = Text::CSV::Encoded->new();

	   $csv->encoding( ['ucs2', 'ascii'] ); # guessing ucs2 or ascii?
	   $csv->encoding_to_combine('shiftjis');

	   my $excel = Spreadsheet::ParseExcel::Workbook->Parse( $file );
	   my $sheet = $excel->{Worksheet}->[0];

	   for my $row ( $sheet->{MinRow} .. $sheet->{MaxRow} ) {
	       my @fields;

	       for my $col ( $sheet->{MinCol} ..  $sheet->{MaxCol} ) {
		   my $cell = $sheet->{Cells}[$row][$col];
		   push @fields, $cell->{Val};
	       }

	       $csv->combine( @fields ) or die;
	       print $csv->string, "
";
	   }

DESCRIPTION

       This module is inherited from Text::CSV::Encoded::Coder::Encode.

USE

       Except for 2 attributes, same as Text::CSV::Encoded::Coder::Encode.

   encoding_in
	   $csv = $csv->encoding_in( $encoding_list_ref );

       The accessor to an encoding for pre-parsing CSV strings.  If no encoding is given, returns current $encoding, otherwise the object itself.

	   $encoding_list_ref = $csv->encoding_in()

       When you pass a list reference, it might guess the encoding from the given list.

	   $csv->encoding_in( ['shiftjis', 'euc-jp', 'iso-20022-jp'] );

       If it cannot guess the encoding, the first encoding of the list is used.

   encoding
	   $csv = $csv->encoding( $encoding_list_ref );
	   $encoding_list_ref = $csv->encoding();

       You can pass a list reference to this attribute only:

	 * For list data consumed by combine().
	 * For list reference returned by getline().

       In other word, in "combine" and "print", it might guess an encoding for the passing list data.  If it cannot guess the encoding, the first
       encoding of the list is used.

SEE ALSO

       Encode, Encode::Guess

AUTHOR

       Makamaka Hannyaharamitu, <makamaka[at]cpan.org>

COPYRIGHT AND LICENSE

       Copyright 2008-2010 by Makamaka Hannyaharamitu

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2010-04-26			       Text::CSV::Encoded::Coder::EncodeGuess(3pm)

Shell Programming and Scripting