Here's a thought: You can convert the Excel spreadsheet to a .csv file and
then use DBD::CSV to sort the fields. You should be able to do this using
Win32::OLE as long as you run it on a system with Excel installed. The
macro code fro saving the file to a .csv is:
ActiveWorkbook.SaveAs Filename:="C:\My Documents\Book1.csv", FileFormat:
=xlCSV, CreateBackup:=False
I believe the documentation on Win32::OLE can get you started, and I know
that there is information out there on how to convert a VB script to a Perl
script using Win32::OLE. You'll need to change the '.'s to '->'s, etc.
-----Original Message-----
From: Connie Chan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 12:25 AM
To: [EMAIL PROTECTED]
Subject: Sort table with dynamic order of fields
In Excel, there is an interesting function which can sort a table
by fields with any order and hierarchy order.
Is there any module can do this for whatever array of array,
hash of array... etc. ?
But what I am looking for is not for and related to any database.
So some of DBI functions maybe no help ( I guest ).
Rgds,
Connie
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
