Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by marlboroguy58
-
trying to write dates from perl to Excel
thank u brigmar,stevexff i was able to do something similar to the above, was able to write dates into excel.- marlboroguy58
- Post #5
- Forum: Perl
-
trying to write dates from perl to Excel
hi stevexff, i use.... use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32::OLE->new('Excel.Application', 'Quit'); # open Excel file my $Book = $Excel->Workbooks->Open($BookName); my $Sheet =...- marlboroguy58
- Post #3
- Forum: Perl
-
trying to write dates from perl to Excel
hi, i have written a script that interacts with MS Excel. it extracts data from a database and populates an excel sheet. there are some date fields in the database, but when the script writes the value in the sheet it writes it as a string. i tried formating the cells for date but it doesn't...- marlboroguy58
- Thread
- Replies: 4
- Forum: Perl
