Hi Gurus,
I am in need of your guidance.
I have installed Perl5.8.8 on my server running with SunOS 5.8
and then I installed Spreadsheet::WriteExcel perl module. It has been installed successfully. Howver when I try to run a command to check whether it emails an excel sheet or not, it showed me the below.
# /home/oracle8/oradba/admin/utils/sqlplus2xls/sqlplus2xls.pl
ERROR (Missing Parameter): <config_file> not specified!
Usage: perl /home/oracle8/oradba/admin/utils/sqlplus2xls/sqlplus2xls.pl
<config_file>
#
Any help will be greatly appreceiated.
Thanks,
Vithya
5 2800
Hi Gurus,
I am in need of your guidance.
I have installed Perl5.8.8 on my server running with SunOS 5.8
and then I installed Spreadsheet::WriteExcel perl module. It has been installed successfully. Howver when I try to run a command to check whether it emails an excel sheet or not, it showed me the below.
# /home/oracle8/oradba/admin/utils/sqlplus2xls/sqlplus2xls.pl
ERROR (Missing Parameter): <config_file> not specified!
Usage: perl /home/oracle8/oradba/admin/utils/sqlplus2xls/sqlplus2xls.pl
<config_file>
#
Any help will be greatly appreceiated.
Thanks,
Vithya
You have posted your question under Perl Articles instead of the Perl Forum.
I have moved it across for you.
Please be sure that ALL questions get posted to the forum as the Articles section is for things like tutorials, not help/assistance!
- MODERATOR
Hi Gurus,
I am in need of your guidance.
I have installed Perl5.8.8 on my server running with SunOS 5.8
and then I installed Spreadsheet::WriteExcel perl module. It has been installed successfully. Howver when I try to run a command to check whether it emails an excel sheet or not, it showed me the below.
# /home/oracle8/oradba/admin/utils/sqlplus2xls/sqlplus2xls.pl
ERROR (Missing Parameter): <config_file> not specified!
Usage: perl /home/oracle8/oradba/admin/utils/sqlplus2xls/sqlplus2xls.pl
<config_file>
#
Any help will be greatly appreceiated.
Thanks,
Vithya
First, is this something that you coded? I ask because if you coded this script to accept and check for a config file, then you should know to supply it.
The script seems to check for it. I would examine the code and see what it is expecting. Did this script come with instructions for usage when you downloaded it?
You may want to post the code here (in proper code tags please) so we can see what it is expecting and maybe assist you.
Regards,
Jeff
First, is this something that you coded? I ask because if you coded this script to accept and check for a config file, then you should know to supply it.
The script seems to check for it. I would examine the code and see what it is expecting. Did this script come with instructions for usage when you downloaded it?
You may want to post the code here (in proper code tags please) so we can see what it is expecting and maybe assist you.
Regards,
Jeff
Thanks for your reply,
Below is the code, please have a look, -
# more sqlplus2xls.pl
-
#!/usr/local/bin/perl
-
################################################################
-
# INCLUDED LIBRARY FILES
-
use lib '/home/oracle8/oradba/admin/utils/sqlplus2xls';
-
use strict;
-
use Spreadsheet::WriteExcel;
-
################################################################
-
# CONSTANTS AND GLOBAL VARIABLES
-
my $pth = "/home/oracle8/oradba/admin/utils/sqlplus2xls";
-
my ($orclhome, $sqlfile, $spool, $batfile, $xlsfile) = undef;
-
my ($i, $j, $k, $daycnt, $col) = 0;
-
my (@datarec, @recipients, @tmp) = undef;
-
my ($workbook, $f, $c1, $msg, $usg, $sidname, $miss_param,
-
$cfgfile, @tabname) = undef;
-
my (@fldVisible,@fldNam,@fldHdrNam,@fldWdth,@fldType,
-
@fldDesc, @tablename, @fld_order, @where, @build_dict) = undef;
-
################################################################
-
# FUNCTION DECLARATIONS & DEFINITIONS
-
# --------------------------------------------------------------
-
# BuildQuery()
-
# --------------------------------------------------------------
-
# BuildDictionary()
-
################################################################
-
-
################################################################
-
#---------------------------------------------------------------
-
# FUNCTION Main
-
# ARGUMENTS <cfg file>
-
# RETURNS sends excel file as an email attachment
-
# EXPECTS arguments indicating the config file
-
# DOES creates an excel file containing query information
-
# defined in config file
-
#
-
#---------------------------------------------------------------
-
$cfgfile = ((@ARGV) && ($ARGV[0])) ? $ARGV[0] : 'none' ;
-
$miss_param = ($cfgfile =~ m/none/) ? " <config_file>" : "" ;
-
-
if (length($miss_param) > 0) {
-
$msg = "\nERROR (Missing Parameter): $miss_param not specified!\n";
-
$usg = "\n\tUsage: perl $0 <config_file>\n";
-
print STDOUT "$msg$usg";
-
exit(0);
-
}
-
# Load Configuration File
-
$cfgfile = "$pth/$cfgfile";
-
open CFG, "<$cfgfile" or die "Can't open $cfgfile \n";
-
my $row = 0;
-
while (<CFG>)
-
{
-
chomp($_);
-
if ($_ =~ m/^\#/) { }
-
elsif ($_ =~ m/^ORACLE_SID/) { @tmp = split(/\^/,$_); $sidname = $tmp[1]; }
-
elsif ($_ =~ m/^ORACLE_HOME/) { @tmp = split(/\^/,$_); $orclhome = $tmp[1]; }
-
elsif ($_ =~ m/^TABNAME/) { @tabname = split(/\^/,$_); }
-
elsif ($_ =~ m/^XLS_FILE_NAME/) { @tmp = split(/\^/,$_); $xlsfile = "$tmp[1]"; }
-
elsif ($_ =~ m/^SQLFILE/) { @tmp = split(/\^/,$_); $sqlfile = "$pth/$tmp[1]" }
-
elsif ($_ =~ m/^SPOOLFILE/) { @tmp = split(/\^/,$_); $spool = "$pth/$tmp[1]" }
-
elsif ($_ =~ m/^BATFILE/) { @tmp = split(/\^/,$_); $batfile = "$pth/$tmp[1]" }
-
-
elsif ($_ =~ m/^TABLE/) { @tablename = split(/\^/,$_); }
-
elsif ($_ =~ m/^ORDER_CLAUSE/) { @fld_order = split(/\^/,$_); }
-
elsif ($_ =~ m/^BUILD_DICT/) { @build_dict = split(/\^/,$_); }
-
elsif ($_ =~ m/^EMAIL_TO/) { @tmp = split(/\^/,$_);
-
@recipients = split(/\:/, $tmp[1]); }
-
elsif ($_ =~ m/^WHERE_CLAUSE/) { @where = split(/\^/,$_); }
-
else {
-
($fldVisible[$row], $fldNam[$row], $fldHdrNam[$row],
-
$fldWdth[$row], $fldType[$row], $fldDesc[$row] ) = split(/\^/,$_);
-
$fldVisible[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldNam[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldHdrNam[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldWdth[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldType[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldDesc[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$row++;
-
}
-
}
-
close CFG;
-
-
$workbook = Spreadsheet::WriteExcel->new("$xlsfile");
-
$f = $workbook->addformat();
-
$f->set_text_wrap();
-
$c1=$workbook->addformat(color=>'Black',bg_color=>'Gray',font=>'Arial',size=>12,bold=>1,);
-
$ENV{ORACLE_SID} = "$sidname";
-
$ENV{ORACLE_HOME} = "$orclhome";
-
open SQL, ">$sqlfile" or die "Could not open temp sql file ($sqlfile). \nStopped";
-
if ($build_dict[1] =~ m/^Y/) { BuildDictionary($workbook, \@fldHdrNam, \@fldType, \@fldDesc, \@fldVisible); }
-
my $w = $workbook->addworksheet("$tabname[1]");
-
$col = 0;
-
for ($i=0; $i<=$#fldHdrNam; $i++) {
-
if ($fldVisible[$i] =~ m/Y/) {
-
$w->write(0,$col,$fldHdrNam[$i],$c1);
-
$w->set_column( $col, $col,$fldWdth[$i]);
-
$col++;
-
}
-
}
-
$w->freeze_panes(1, 0); # Freeze the header row
-
-
print SQL BuildQuery($spool, $daycnt, \@fldNam, $tablename[1], $fld_order[1], $where[1]);
-
close SQL;
-
open BAT, ">$batfile" or die "Could not open temp bat file ($batfile). \nStopped";
-
print BAT "$orclhome/bin/sqlplus / @", "$sqlfile\n";
-
close BAT;
-
chmod 0744, $batfile;
-
system($batfile);
-
open SPOOL, "<$spool" or die "Can't open $spool \n";
-
$row = 1;
-
while (<SPOOL>)
-
{
-
chomp($_);
-
@datarec = split(/\^/,$_);
-
$col = 0;
-
for ($i=0;$i<=$#datarec;$i++) {
-
$datarec[$i] =~ s/^\s*(.*?)\s*$/$1/;
-
if ($fldVisible[$i] =~ m/Y/) {
-
$w->write($row,$col,$datarec[$i],$f);
-
$col++;
-
}
-
}
-
$row++;
-
}
-
close SPOOL;
-
$workbook->close() or die "Error closing file: $!";
-
-
print "\nSending Mail.............\n";
-
for ($i=0;$i<=$#recipients;$i++) {
-
system("(uuencode $xlsfile $xlsfile) | mailx -s Audit_$sidname@`hostname` $recipients[$i]\;");
-
}
-
print "\nProcess Complete!\n";
-
exit(0);
-
################################################################
-
# End of Main
-
################################################################
-
#---------------------------------------------------------------
-
# FUNCTION BuildQuery
-
# ARGUMENTS
-
# RETURNS query string
-
#
-
# DOES
-
#---------------------------------------------------------------
-
sub BuildQuery
-
{
-
my $spoolfile = (@_) ? $_[0] : undef ;
-
my $daycnt = (@_) ? $_[1] : 7 ;
-
my @flds = (@_) ? @{$_[2]} : undef ;
-
my $tablename = (@_) ? $_[3] : undef ;
-
my $fldorder = (@_) ? $_[4] : undef ;
-
my $where = (@_) ? $_[5] : undef ;
-
my ($sql, $i) = undef;
-
$sql = "SET LINESIZE 19000 \n";
-
#SET FLUSH OFF
-
$sql .= "SET TERMOUT OFF \n";
-
#SET TRIMS ON DOCUMENT OFF
-
$sql .= "set pagesize 0 \n";
-
$sql .= "set heading off \n";
-
$sql .= "set feedback off \n";
-
$sql .= "SET ECHO OFF \n";
-
$sql .= "SET WRAP OFF \n";
-
$sql .= "set colsep ^ \n";
-
$sql .= "spool $spoolfile \n";
-
$sql .= "select ";
-
for ($i=0;$i<=$#flds;$i++) {
-
$sql .= "$flds[$i]";
-
$sql .= (($i==$#flds)) ? "" : "," ;
-
}
-
$sql .= " FROM $tablename \n";
-
$sql .= " WHERE $where \n";
-
$sql .= "order by $fldorder ; \n";
-
$sql .= "spool off \n";
-
$sql .= "exit \n";
-
return $sql;
-
}
-
#---------------------------------------------------------------
-
# FUNCTION BuildDictionary
-
# ARGUMENTS
-
# RETURNS
-
#
-
# DOES
-
#---------------------------------------------------------------
-
sub BuildDictionary
-
{
-
my $workbook = (@_) ? $_[0] : undef ;
-
my @hdrs = (@_) ? @{$_[1]} : undef ;
-
my @typ = (@_) ? @{$_[2]} : undef ;
-
my @desc = (@_) ? @{$_[3]} : undef ;
-
my @visible = (@_) ? @{$_[4]} : undef ;
-
my $w = $workbook->addworksheet("Dictionary");
-
my $f = $workbook->addformat(color=>'Black',bg_color=>'Gray',font=>'Arial',size=>12,bold=>1,);
-
my ($col, $row) = 0;
-
-
$w->set_column(0,0,20);
-
$w->set_column(1,1,20);
-
$w->set_column(2,2,60);
-
for ($col=0;$col<=$#hdrs;$col++) {
-
if ($fldVisible[$col] =~ m/Y/) {
-
$w->write( $row,0,$hdrs[$col],$f);
-
$w->write( $row,1,$typ[$col]);
-
$w->write( $row,2,$desc[$col]);
-
$row++;
-
}
-
}
-
}
-
#********************************************************************
-
-
#
-
Thanks for your reply,
Below is the code, please have a look, -
# more sqlplus2xls.pl
-
#!/usr/local/bin/perl
-
################################################################
-
# INCLUDED LIBRARY FILES
-
use lib '/home/oracle8/oradba/admin/utils/sqlplus2xls';
-
use strict;
-
use Spreadsheet::WriteExcel;
-
################################################################
-
# CONSTANTS AND GLOBAL VARIABLES
-
my $pth = "/home/oracle8/oradba/admin/utils/sqlplus2xls";
-
my ($orclhome, $sqlfile, $spool, $batfile, $xlsfile) = undef;
-
my ($i, $j, $k, $daycnt, $col) = 0;
-
my (@datarec, @recipients, @tmp) = undef;
-
my ($workbook, $f, $c1, $msg, $usg, $sidname, $miss_param,
-
$cfgfile, @tabname) = undef;
-
my (@fldVisible,@fldNam,@fldHdrNam,@fldWdth,@fldType,
-
@fldDesc, @tablename, @fld_order, @where, @build_dict) = undef;
-
################################################################
-
# FUNCTION DECLARATIONS & DEFINITIONS
-
# --------------------------------------------------------------
-
# BuildQuery()
-
# --------------------------------------------------------------
-
# BuildDictionary()
-
################################################################
-
-
################################################################
-
#---------------------------------------------------------------
-
# FUNCTION Main
-
# ARGUMENTS <cfg file>
-
# RETURNS sends excel file as an email attachment
-
# EXPECTS arguments indicating the config file
-
# DOES creates an excel file containing query information
-
# defined in config file
-
#
-
#---------------------------------------------------------------
-
$cfgfile = ((@ARGV) && ($ARGV[0])) ? $ARGV[0] : 'none' ;
-
$miss_param = ($cfgfile =~ m/none/) ? " <config_file>" : "" ;
-
-
if (length($miss_param) > 0) {
-
$msg = "\nERROR (Missing Parameter): $miss_param not specified!\n";
-
$usg = "\n\tUsage: perl $0 <config_file>\n";
-
print STDOUT "$msg$usg";
-
exit(0);
-
}
-
# Load Configuration File
-
$cfgfile = "$pth/$cfgfile";
-
open CFG, "<$cfgfile" or die "Can't open $cfgfile \n";
-
my $row = 0;
-
while (<CFG>)
-
{
-
chomp($_);
-
if ($_ =~ m/^\#/) { }
-
elsif ($_ =~ m/^ORACLE_SID/) { @tmp = split(/\^/,$_); $sidname = $tmp[1]; }
-
elsif ($_ =~ m/^ORACLE_HOME/) { @tmp = split(/\^/,$_); $orclhome = $tmp[1]; }
-
elsif ($_ =~ m/^TABNAME/) { @tabname = split(/\^/,$_); }
-
elsif ($_ =~ m/^XLS_FILE_NAME/) { @tmp = split(/\^/,$_); $xlsfile = "$tmp[1]"; }
-
elsif ($_ =~ m/^SQLFILE/) { @tmp = split(/\^/,$_); $sqlfile = "$pth/$tmp[1]" }
-
elsif ($_ =~ m/^SPOOLFILE/) { @tmp = split(/\^/,$_); $spool = "$pth/$tmp[1]" }
-
elsif ($_ =~ m/^BATFILE/) { @tmp = split(/\^/,$_); $batfile = "$pth/$tmp[1]" }
-
-
elsif ($_ =~ m/^TABLE/) { @tablename = split(/\^/,$_); }
-
elsif ($_ =~ m/^ORDER_CLAUSE/) { @fld_order = split(/\^/,$_); }
-
elsif ($_ =~ m/^BUILD_DICT/) { @build_dict = split(/\^/,$_); }
-
elsif ($_ =~ m/^EMAIL_TO/) { @tmp = split(/\^/,$_);
-
@recipients = split(/\:/, $tmp[1]); }
-
elsif ($_ =~ m/^WHERE_CLAUSE/) { @where = split(/\^/,$_); }
-
else {
-
($fldVisible[$row], $fldNam[$row], $fldHdrNam[$row],
-
$fldWdth[$row], $fldType[$row], $fldDesc[$row] ) = split(/\^/,$_);
-
$fldVisible[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldNam[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldHdrNam[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldWdth[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldType[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$fldDesc[$row] =~ s/^\s*(.*?)\s*$/$1/;
-
$row++;
-
}
-
}
-
close CFG;
-
-
$workbook = Spreadsheet::WriteExcel->new("$xlsfile");
-
$f = $workbook->addformat();
-
$f->set_text_wrap();
-
$c1=$workbook->addformat(color=>'Black',bg_color=>'Gray',font=>'Arial',size=>12,bold=>1,);
-
$ENV{ORACLE_SID} = "$sidname";
-
$ENV{ORACLE_HOME} = "$orclhome";
-
open SQL, ">$sqlfile" or die "Could not open temp sql file ($sqlfile). \nStopped";
-
if ($build_dict[1] =~ m/^Y/) { BuildDictionary($workbook, \@fldHdrNam, \@fldType, \@fldDesc, \@fldVisible); }
-
my $w = $workbook->addworksheet("$tabname[1]");
-
$col = 0;
-
for ($i=0; $i<=$#fldHdrNam; $i++) {
-
if ($fldVisible[$i] =~ m/Y/) {
-
$w->write(0,$col,$fldHdrNam[$i],$c1);
-
$w->set_column( $col, $col,$fldWdth[$i]);
-
$col++;
-
}
-
}
-
$w->freeze_panes(1, 0); # Freeze the header row
-
-
print SQL BuildQuery($spool, $daycnt, \@fldNam, $tablename[1], $fld_order[1], $where[1]);
-
close SQL;
-
open BAT, ">$batfile" or die "Could not open temp bat file ($batfile). \nStopped";
-
print BAT "$orclhome/bin/sqlplus / @", "$sqlfile\n";
-
close BAT;
-
chmod 0744, $batfile;
-
system($batfile);
-
open SPOOL, "<$spool" or die "Can't open $spool \n";
-
$row = 1;
-
while (<SPOOL>)
-
{
-
chomp($_);
-
@datarec = split(/\^/,$_);
-
$col = 0;
-
for ($i=0;$i<=$#datarec;$i++) {
-
$datarec[$i] =~ s/^\s*(.*?)\s*$/$1/;
-
if ($fldVisible[$i] =~ m/Y/) {
-
$w->write($row,$col,$datarec[$i],$f);
-
$col++;
-
}
-
}
-
$row++;
-
}
-
close SPOOL;
-
$workbook->close() or die "Error closing file: $!";
-
-
print "\nSending Mail.............\n";
-
for ($i=0;$i<=$#recipients;$i++) {
-
system("(uuencode $xlsfile $xlsfile) | mailx -s Audit_$sidname@`hostname` $recipients[$i]\;");
-
}
-
print "\nProcess Complete!\n";
-
exit(0);
-
################################################################
-
# End of Main
-
################################################################
-
#---------------------------------------------------------------
-
# FUNCTION BuildQuery
-
# ARGUMENTS
-
# RETURNS query string
-
#
-
# DOES
-
#---------------------------------------------------------------
-
sub BuildQuery
-
{
-
my $spoolfile = (@_) ? $_[0] : undef ;
-
my $daycnt = (@_) ? $_[1] : 7 ;
-
my @flds = (@_) ? @{$_[2]} : undef ;
-
my $tablename = (@_) ? $_[3] : undef ;
-
my $fldorder = (@_) ? $_[4] : undef ;
-
my $where = (@_) ? $_[5] : undef ;
-
my ($sql, $i) = undef;
-
$sql = "SET LINESIZE 19000 \n";
-
#SET FLUSH OFF
-
$sql .= "SET TERMOUT OFF \n";
-
#SET TRIMS ON DOCUMENT OFF
-
$sql .= "set pagesize 0 \n";
-
$sql .= "set heading off \n";
-
$sql .= "set feedback off \n";
-
$sql .= "SET ECHO OFF \n";
-
$sql .= "SET WRAP OFF \n";
-
$sql .= "set colsep ^ \n";
-
$sql .= "spool $spoolfile \n";
-
$sql .= "select ";
-
for ($i=0;$i<=$#flds;$i++) {
-
$sql .= "$flds[$i]";
-
$sql .= (($i==$#flds)) ? "" : "," ;
-
}
-
$sql .= " FROM $tablename \n";
-
$sql .= " WHERE $where \n";
-
$sql .= "order by $fldorder ; \n";
-
$sql .= "spool off \n";
-
$sql .= "exit \n";
-
return $sql;
-
}
-
#---------------------------------------------------------------
-
# FUNCTION BuildDictionary
-
# ARGUMENTS
-
# RETURNS
-
#
-
# DOES
-
#---------------------------------------------------------------
-
sub BuildDictionary
-
{
-
my $workbook = (@_) ? $_[0] : undef ;
-
my @hdrs = (@_) ? @{$_[1]} : undef ;
-
my @typ = (@_) ? @{$_[2]} : undef ;
-
my @desc = (@_) ? @{$_[3]} : undef ;
-
my @visible = (@_) ? @{$_[4]} : undef ;
-
my $w = $workbook->addworksheet("Dictionary");
-
my $f = $workbook->addformat(color=>'Black',bg_color=>'Gray',font=>'Arial',size=>12,bold=>1,);
-
my ($col, $row) = 0;
-
-
$w->set_column(0,0,20);
-
$w->set_column(1,1,20);
-
$w->set_column(2,2,60);
-
for ($col=0;$col<=$#hdrs;$col++) {
-
if ($fldVisible[$col] =~ m/Y/) {
-
$w->write( $row,0,$hdrs[$col],$f);
-
$w->write( $row,1,$typ[$col]);
-
$w->write( $row,2,$desc[$col]);
-
$row++;
-
}
-
}
-
}
-
#********************************************************************
-
-
#
-
First, please do not top post (place your reply ABOVE the quoted text you are replying to). If you do this,
?
about
talking
are
you
what
know
anyone
will
how
Second, in my post, I specifically asked that you place the proper code tags around your code. And example of the code tags is always provided for you in the "REPLY GUIDELINES" to the right of the Message window when replying. Please use them in the future for all code that you post here on TSDN.
Thank you!
Regards,
Jeff
Sorry for that, As this is the first time, I am using this site.
Vithya
First, please do not top post (place your reply ABOVE the quoted text you are replying to). If you do this,
?
about
talking
are
you
what
know
anyone
will
how
Second, in my post, I specifically asked that you place the proper code tags around your code. And example of the code tags is always provided for you in the "REPLY GUIDELINES" to the right of the Message window when replying. Please use them in the future for all code that you post here on TSDN.
Thank you!
Regards,
Jeff
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Dorthe Luebbert |
last post by:
Hi,
there is a new(er) version of John McNammara's Excel package for Perl:
http://homepage.eircom.net/~jmcnamara/perl/prerel/Spreadsheet-WriteExcel-0.49.7.tar.gz
The package writes Excel97...
|
by: Fabio |
last post by:
Hello,
there's a module called Spreadsheet::WriteExcel. It allows me to create
a new worksheet and edit its cells:
my $workbook = Spreadsheet::WriteExcel->new('my.xls');
my $worksheet =...
|
by: Jer |
last post by:
Using an access project front-end to an MSDE database, I'm trying to
import a spreadsheet using File->Get External Data->Import.
After I select the spreadsheet name, I tell it I want to import into...
|
by: tito |
last post by:
I am using Active Perl for running perl programs.I am finding difficulty in installing Spreadsheet::WriteExcel,Spreadsheet:ParseExcel to the machine for writing a program which will retrieve data...
|
by: rasmitasah25 |
last post by:
hi,
I am very new to perl.I have written a perl script which is writing data into an excel file.The problem is that it is creating one new excel file while executing but my need id to write into...
|
by: Sport Girl |
last post by:
Hi again my great online assistants, just would like to say that i'm testing the script under unix , and after researches on the internet, i have realised that to resolve 500 Internal Server Error,...
|
by: Perl Beginner |
last post by:
I am using Win32. I have created an excel spreadsheet, formatted the columns and rows, and would like to write to the cells…all of this using Spreadsheet::WriteExcel. My issue is, my script is very...
|
by: lavsaxena |
last post by:
Can we edit a worksheet of excel through spreadsheet::writeExcel.
Because when I am using
my $workbook = Spreadsheet::WriteExcel->new('D:\test_result.xls');
this statement is creating the...
|
by: somsub |
last post by:
Hi,
When I tried to open excel sheet created by below code with MSexcel it showing "Unable to read file " error .
use Spreadsheet::WriteExcel;
$workbook =...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |