Hi,
I have test2.xls file it has some data.
I want to open that file,read the data from the same file, get the content of the cell in to in scalar variable and display the same(content) at the command prompt.
Please help me with sample code if anybody knows.its argent for me.
Regards
Bhuvan
Bsr
Last Activity: May 8 '07, 06:52 AM
Joined: Mar 27 '07
Location:
-
How to get cell content in to one scalar variable
-
Hi,
I do not have cgi-bin folder.How to set that folder.Please help me .
Regards,
Bhuvan -
Hi Miller,
Thanks for reply.
I tried ,but i was not able to get.
My Question:
I have test2.xls file it has some data.
I want to open that file,read the data from the same file, get the content of the cell in to in scalar variable and display the same(content) at the command prompt.
Please help me with sample code if anybody knows.its argent for me....Leave a comment:
-
How to get the cell data in to the varaible from existed Excel file.
Hi,
Please tell the solutions for the following queries.
1. How to read the data from Excel file.
2. How to get the cell data in to the varaible from existed Excel file.
Its very argent for me. Please do the needful
Bhuvan -
Hi,
1.Server is local server with Windows.
2.In which folder i need to store this .cgi fileLeave a comment:
-
Hi Kevin,
Thanks
I had written perl code,saved as .cgi file and ran that file in Web Browser(IE). But its not going to be run,even it's not showing any error.
Kindly help me.It's urgent for me.
Regards,
Bhuvan.Leave a comment:
-
How to run the cgi program and what are the pre requests for the same.
Hi All,
I would like to know how to run the cgi program,so what are the pre requests for the same. Please furnish the steps right from the begining.
Here is sample perl cgi code.
...Code:#!/usr/local/bin/perl # hello.pl -- my first perl script! print "Content-type: text/html\n\n"; print <<"EOF"; <HTML> <HEAD>
-
Hi All,
Please help on following things.
1.What is Tomcat and Apache?
2.How do v intsll Tomcat and Apache?
3.How do v startup and shutdown these two?
4.What is the difference between Application Server and Web Server?
BhuvanLeave a comment:
-
Hi,
Thanks Kevin.
Please clarify for the following questions in given code.
1. What is the use of scan()
2. Why do we need sub function
3. what is meaning of qq~ in the print command.
code:
$cookie_jar->scan(sub {
my ( $version, $key, $val, $path, $domain, $port, $path_spec, $secure, $expires, $discard) = @_;
print qq~$version,...Leave a comment:
-
What is the difference between "GET", "HEAD", "PUT" or "POST" methods
What is the difference between for the following methods.
"GET", "HEAD", "PUT" or "POST".
Ex:my $req =HTTP::Request->new(GET =>$url1);
Bhuvan. -
Hi KevinADC,
Thanks a lot.I got it. But i have doubts as given below.
1. What is this meaning of $ua->agent('Mozil la/5.0')
2. Why we need use "use Data::Dumper" package?
3. Can we get only cookie ID and Expire date?
Please explain the contents of Cookie information in Result.
...Code:Result: $VAR1 = \bless( { 'COOKIES' => { '.google.co.in' =>Leave a comment:
-
Hi Miller,
Please find the sample perl code for to get the cookie information for google site.
...Code:use LWP::UserAgent; use HTTP::Cookies::Microsoft; use HTTP::Request; # construct objects my $ua = LWP::UserAgent->new; my $cookie_jar = HTTP::Cookies::Microsoft->new; my $request =HTTP::Request->new(POST => 'http://www.google.co.in'); my $response = $ua->request($request);
Leave a comment:
-
Hi,
I tried with many examples , But unable to get that cookies information.
Please send the sample code for cookie information for google site.
Cheers
BhuvanLeave a comment:
-
Hi,
1.where will i get "make" file??
You download that file and save to your loacal repository system.
2.How do Run that Makefile.pl?
1.Navigate to that folder which is having this Makefile.pl
2.Give the command "Perl Makefile.pl"
3.what shud be the sequence of installing DBI and DBDs??
First you should install DBI after that install DBD-ODBC...Leave a comment:
-
Hi,
Install "Class-DBI-MSSQL" and try it your code.
Please find my sample perl code for retrieve the data from table
...Code:#!/usr/bin/perl -w use DBI; use warnings; use strict; $ENV{NLS_LANG} = 'AMERICAN_AMERICA.UTF8'; my $dbh = DBI->connect ("dbi:Oracle:Enter host name","user name","password") or die "Cant connectLeave a comment:
-
Cookie Information
Hi,
I need perl code for getting cookie information.if anybody knows this ,kindly let me know. I am looking forward for this. -
Hi,
What is your database name? (Ex:Oracle or SQlServer2005)
If Database is Oracle ,you should install DBD-Oracle after installation DBI.
Could you please send me your perl code which has written by you.
Cheers
BhuvanLeave a comment:
-
Hi,
I do not have correct answer for that one. But what i am suggesting you first uninstall the Active Perl,restart the your system and again install that Active Perl.Then you install DBI and DBD-Oracle modules.
Let us know if you have any issues.
Cheers
BhuvanLeave a comment:
-
Hi,
After installation Perl, you go for command prompt and give "ppm" at the prompt.then it displays the prompt as ppm>
Example:1. c:\perl> this is command prompt
2. c:\perl>ppm
3. ppm>install DBI (wait some time)
4. ppm>install DBD-Oracle
5. ppm>exit (come out from ppm)
Kindly let me know if you have any issues
...Leave a comment:
-
Msvcr71.dll
Hi,
What is the abbreviation for MSVCR71.DLL file in Perl,what is the need of this one,When do we install this dll file.Please do the needful on this.
Cheers
Bhuvan
No activity results to display
Leave a comment: