comment on

My table names(mysql) & sheets names are same which I saved in array @tables

 
foreach my $MIS_SHEET (@tables)
{
    # Get the first worksheet.
    my $sheet = $template->worksheet($MIS_SHEET);
[download]

In this i am trying to open each sheet ony by one.

my $sth = $dbh->prepare("SELECT * from $MIS_SHEET"); #Getting data fro
+m table
    $sth->execute() or die $DBI::errstr;
    while (my @row = $sth->fetchrow_array())
    {
        ++$row;
        foreach my $value (@row)
        {
            $sheet->AddCell( $row, $col, $value );
            ++$col;
        }
    }
[download]

Here i am saving the data fetch from my DB into excel sheet.

+-----------------------+
| Tables_in_MIS_Reports |
+-----------------------+
| MIS_A2P               |
| MIS_Overall           |
| MIS_P2A               |
| MIS_P2P               |
+-----------------------+

mysql> select * from MIS_P2P;
+------------+-------+---------+---------+--------------+-----------+-
+--------------+--------------+-------------+----------+
| Date       | MDA   | Success | FDA     | Success_rate | Sub_Error | 
+Network_Error | System_Error | Total_Error | Total_MO |
+------------+-------+---------+---------+--------------+-----------+-
+--------------+--------------+-------------+----------+
| 2015-07-31 | 38002 | 95.7437 | 93.1952 |      93.0325 |   85.5974 | 
+      10.5565 |    0.0818331 |     6.34294 |    29494 |
| 2015-07-31 | 38002 | 95.7437 | 93.1952 |      93.0325 |   85.5974 | 
+      10.5565 |    0.0818331 |     6.34294 |    29494 |
| 2015-07-31 | 38002 | 95.7437 | 93.1952 |      93.0325 |   85.5974 | 
+      10.5565 |    0.0818331 |     6.34294 |    29494 |
| 2015-08-01 | 38002 | 95.7437 | 93.1952 |      93.0325 |   85.5974 | 
+      10.5565 |    0.0818331 |     6.34294 |    29494 |
| 2015-08-02 | 38002 | 95.7437 | 93.1952 |      93.0325 |   85.5974 | 
+      10.5565 |    0.0818331 |     6.34294 |    29494 |
| 2015-08-03 | 38002 | 95.7437 | 93.1952 |      93.0325 |   85.5974 | 
+      10.5565 |    0.0818331 |     6.34294 |    29494 |
+------------+-------+---------+---------+--------------+-----------+-
+--------------+--------------+-------------+----------+
6 rows in set (0.00 sec)
[download]

This is the data available in my DB.

<h> I am Sure that my sheet name are correctly spelled & no problem with that</h>

Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 242.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 242.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 242.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 242.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
Use of uninitialized value $iC in numeric le (<=) at /root/perl5/lib/p
+erl5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 274.
Use of uninitialized value $iC in array element at /root/perl5/lib/per
+l5/Spreadsheet/ParseExcel/SaveParser/Workbook.pm line 281.
[download]

In reply to Re^2: Trying to modify multisheets using Spreadsheet::ParseExcel::SaveParser by ravi45722
in thread Trying to modify multisheets using Spreadsheet::ParseExcel::SaveParser by ravi45722

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.