Tag Archives: CPAN

Linux

Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)

Leave a comment

By scriptscript

File Type: gif
Hi folks,

I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).

P.S. Hyperlink is behind the data and not visible in excel sheet directly.

Now using perl script I need to copy the hyperlinks in seperate excel sheet.

I have browsed CPAN modules but havnt found the module that suits my requirement.

Could you please help me on this ?

…read more
Source: FULL ARTICLE at The UNIX and Linux Forums

Linux

Unable to get full message text from Windows Event Logs

Leave a comment

By kar_333

Hi all,

. I am developing a log monitoring solution in perl for Windows I am using the CPAN module Win32 ::EventLog (0.076) version for getting the events from windows. The problem which I am facing now is all the Windows 2008 machines are upgraded with Service pack2 from then I couldn’t able to get the message text even if I set the value 1 to $Win32::EventLog::GetMessageText = 1; for both Windows 2008 sp2 and Windows 2012. I agree this not a bug in the module instead Windows 2008 Sp2 and 2012 event log design might have changed in such a way kindly let me know is there any possibility to modify anything in the .pm file to get the Windows 2008 sp2 message moreover the module cannot pull only the message from the service control manager which has an event ID 7036.

…read more
Source: FULL ARTICLE at The UNIX and Linux Forums

Linux

Grabbing data from a secured website

Leave a comment

By freddie50

Hello there,
I am a beginner in Perl, and I have a challenging project:
I have to create a program that checks regularly on an online bank account for new operations, it should then feed a database keeping track of all the money going in and out.
Of course the login details of this online banking access are known.

Could you please share your thoughts with us here on how to do that?
Which libraries or CPAN modules should I look at?
I guess this program will vary very much depending on how the online bank account is built, but what are the main rules when you want to automatically grab data from a website protected with personal access codes?

Many thanks for your help and keep up the great work!

…read more
Source: FULL ARTICLE at The UNIX and Linux Forums