Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Perl, Excel, and AutoShapes
6 views
Skip to first unread message
Idgarad
Nov 28, 2006, 4:19:47 PM11/28/06
to
I am very interested in taking some mainframe output (already in ASCII
fyi) and parsing it into Excel. I would like to annotate the status of
a job with an up arrow or down arrow (the excel file is formatted like
a calendar) indicating the state of a job. I can build the excel file
without any problem via the spreadsheet::writeexcel module without any
trouble. Unfortunatly I have not found a module that can help with
getting the Autoshape placed in the excel document. Has anyone found a
perl-based solution to getting an autoshape into an excel document? I
have found several VB solutions that can be used internally in an excel
document but I ran into another brick wall, the spreadsheet::writeexcel
doesn't have the facilities to add VB modules to the document. Has
anyone tackled this problem before?
fyi) and parsing it into Excel. I would like to annotate the status of
a job with an up arrow or down arrow (the excel file is formatted like
a calendar) indicating the state of a job. I can build the excel file
without any problem via the spreadsheet::writeexcel module without any
trouble. Unfortunatly I have not found a module that can help with
getting the Autoshape placed in the excel document. Has anyone found a
perl-based solution to getting an autoshape into an excel document? I
have found several VB solutions that can be used internally in an excel
document but I ran into another brick wall, the spreadsheet::writeexcel
doesn't have the facilities to add VB modules to the document. Has
anyone tackled this problem before?
0 new messages