Reading Dates from Excel-file

From: bruno (bskorepa_at_yahoo.com)
Date: 11/29/03


Date: 29 Nov 2003 03:30:30 -0800

I have a script that reads an excel file.
Since I upgraded to activeperl 5.8 the date-fields are read as:

Win32::OLE::Variant=SCALAR(0x20d341c)

before I got real date-values (although I do not remember what
perl-version I had before).
Platform: win2000

thanks for any hints,
Bruno



Relevant Pages

  • RE: AD-Users to contacts
    ... I've written a script that takes in input the data from a "well formatted" ... excel file that show the result of each creation. ... - Uppercase letters will be substituted whit lowercase letters ... users in formation from the old directory, the first part of the job). ...
    (microsoft.public.windows.server.scripting)
  • Re: AD-Users to contacts
    ... Hi SubnetJO! ... > I've written a script that takes in input the data from a "well formatted" ... > excel file that show the result of each creation. ... after you ave filled the input file with data (dumping ...
    (microsoft.public.windows.server.scripting)
  • Warning: Persistent ASP 0240 Bug in ActivePerl 5.8
    ... Running the following ASP web page on any version of ActivePerl 5.8.x under ... Script Engine Exception ... VBScript version of the same code does not result in this error message. ...
    (comp.lang.perl.misc)
  • help in scripting excel2k3
    ... I had this script that would open an Excel File, loop through it then close the file. ... It worked when I had ExcelXP installed on my machine, but now I can't get the script to work with Excel2k3. ... WScript.Echo "No input file provided. ... Set objExcel = WScript.CreateObject ...
    (microsoft.public.scripting.vbscript)
  • Re: Multiple append in text files
    ... I have a script making an inventory in excel from hardwareinfo in about ... At every logon there is one hardware file and one software file created ... Or can i get the info from the excel file software.xls into ...
    (microsoft.public.scripting.vbscript)