[unisog] Anyone got a script that will detect bad excel files?

Russell Fulton r.fulton at auckland.ac.nz
Thu Jun 22 20:00:38 GMT 2006


there are a couple of perl modules that claim to parse excel files.  If
I get time I'll I'll look at them and see if they do anything sensible
with the hyperlinks.

R

Michael Holstein wrote:
>> Anyone know of any useful docs?
> 
> This looks promising .. (but it's VB code) :
> 
> http://sniptools.com/tipstricks/deleting-all-hyperlinks-from-a-microsoft-office-document
> 
> This VB snippit will deactivate all hyperlinks in an excel document :
> 
> --snip--
> sub RemoveHyperLinksGLobally()
>      Dim i As Integer
>      For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
>            ActiveSheet.Hyperlinks(i).Delete
>      Next i
> End Sub
> --snip--
> 
> I've been searching CPAN, but the Spreadsheet::ParseExcel modules don't 
> handle Hyperlinks yet...
> 
> Cheers,
> 
> Michael Holstein CISSP GCIA
> Cleveland State University
> _______________________________________________
> unisog mailing list
> unisog at lists.sans.org
> http://www.dshield.org/mailman/listinfo/unisog


More information about the unisog mailing list