I've worked quite a bit with OLE and excell though not through perl, and the best I've been able to come up with for this problem is to iterate down the rows, checking for an empty value in a column that you know will be filled, and thus building a totalrows scalar. RE: RE: RE: Re: OLE - Getting all rows from Excel There is a good overview of the Excel Object model in the online help. I actually only use Objectviewer in the Visual Basic Editor. RE: RE: Re: OLE - Getting all rows from Excel "create a worksheet and insert X rows" examples. Where did you find that? I can't seem toįind any good Excel OLE references for Perl beyond the simple RE: Re: OLE - Getting all rows from Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |