Please provide me Perl scriptwhich reads the data from xcel sheet and renames the dsx file.Process followed to rename is:make a list of old and new file names in xcel sheet.compare the old file name in the xcel sheet with dsx name.If both are equal then assign the new name to the dsx which is mentioned in the xcel sheet.Kindly please help me in this.Expecting a reply soon..

gansi

 Profile Answers by gansi Questions by gansi

• Sep 30th, 2009

use Win32::OLE;use Win32::OLE::Enum;use Win32::OLE qw(in with);use Win32::OLE::Const 'Microsoft Excel';use Win32::OLE::Variant;use Spreadsheet::ParseExcel;use Spreadsheet::WriteExcel;use Sprea...

Answer Question  Select Best Answer