Suggestion Box in Perl

2008-05-14 Thread Stephan Gross
Can anyone point me to a source for a form/Perl script for a web-based anonymous suggestion box? Thanks! Steve Gross Tel: 212-284-6558 Director of Information Technology

Flush print() buffer?

2008-01-08 Thread Stephan Gross
I've been playing with an MP3 tag program. I copied a script that reads the values in a tag and prints them out. The problem is that one of the tag values is a picture and presumably the value is some kind of binary value. Once I encounter this problem, the print() function no longer works -

Sort an Excel spreadsheet

2006-11-13 Thread Stephan Gross
I'm using Win32:OLE to manipulate an Excel spreadsheet. I want to sort the sheet on the "F" column. My code is $range1 = "A1:H" . $numrows;$sheet-Range($range1)-Sort({ Key1 = "F1", Order1 = xlDescending, }); But it doesn't work. Does anyone have any ideas or an example of working code?

Reading Excel spreadsheet into variables

2006-08-28 Thread Stephan Gross
I'm reading in an Excel spreadsheet using Win32::OLE. I want to read in the entire spreadsheet. I found a piece of code that does that: $everything = $sheet-UsedRange()-{Value}; for (@$everything) { for (@$_) { print defined($_) ? $_| : undef|; } print \n; } However,