User Profile
Collapse
-
Can you please explain me what do you meant by your comment given to my questions.If my questions are not relevant or foolish can you please tell me in a simple sentence.Thank you.... -
Windows Mobile Application
Can we develop Windows Mobile Application using Perl Script?
Is there any way to interact with a Windows Application using Perl?
Can we test a Windows Mobile GUI using Perl?
Can anyone answer me for the above questions.Actua lly i would like to know any interface is there between Perl and a windows mobile Application.
Thank You -
Getting input from STDIN
I have used use Spreadsheet::Wr iteExcel::FromD B::Query package to retrieve the values from database to Excel sheet using the following program.
Code:use Spreadsheet::WriteExcel::FromDB::Query; my $dbh=DBI->connect("DBI:mysql:tito:localhost","",""); $query=q{SELECT Engg_ID from mastertable where Project_ID='8'}; $ss->write_xls('spreadsheet112.xls');
-
Retrieving a date field from an Excel spreadsheet
In my program i am trying to retrieve 'date' field from an excel sheet .This data is inserted into a My SQL Database.The default format for 'date ' field for Excel sheet is in the form of dd-mm-yyyy,but for the MySQL format is YYYY-mm-DD.
While running the program the 'date' is not updated in the SQL giving the error
date format is invalid. So can anyone explain me how to automate,which function i should use in Perl program... -
How to install Spreadsheet::ParseExcel
I would like to write a program which will retrieve the data from the EXCEL file and write into an SQL Server using Perl script.Spreadsh eet::WriteExcel programs are working fine.But while executing Spreadsheet::Pa rseExcel i am getting the error like
Can't locate Spreadsheet/ParseExcel.pm in @INC (@INC contains: D:/Perl/lib D:/Pe
rl/site/lib .) at parse.pl line 5.
I used the following program.Can anyone tell me... -
Code which will convert the Excel sheet document to a Pie diagram or a chart
Hi All,
I am trying to write a code which will convert the Excel sheet document to Pie Diagarm using Perl Script.I have already searched in CPAN which gives the details of Spreadsheet::Wr iteExcel::Chart but not in greater details.
Can anyone explain me how to do the same.
Thanks -
How to Configure Apache Web Sever for CGI Programming
I have already installed Active Perl and Apache Websever (HTTP Server 2.2.4) in Wndows XP.Both these are working individually means Apache is started successfully,Ac tive Perl is also working successfully.
Now i would like to configure Apache Server for running Perl Program or CGI using PERL.
Can anyone explain me how to configure the Apache Server for executing .pl or .cgi extension programs.
Thanks -
Thanks Kevin for your immediate response.I was able to install Spreadsheet::Wr iteExcel,Spread sheet::ParseExc el in my machine by your instructions.
If the time allows can you just explain or give a sample program which will retrieve data from an Excel sheet using Spreadsheet::Pa rseExcel interface.
Thank uLeave a comment:
-
Installing Spreadsheet::WriteExcel,Spreadsheet:ParseExcel
I am using Active Perl for running perl programs.I am finding difficulty in installing Spreadsheet::Wr iteExcel,Spread sheet:ParseExce l to the machine for writing a program which will retrieve data from an Excel Sheet.
Can anyone explain me the steps to install Spreadsheet::Wr iteExcel,Spread sheet:ParseExce l in Windows machine.
No activity results to display
Show More
Leave a comment: