> From: Glen Plantz <[EMAIL PROTECTED]> > > Hi Folks, > > > Could someone tell me how to convert from the "Row, Column" ( 1,1) > reference to a Cell to using the "Cell Name" ( A1) ? > > > I know this is an FAQ, but I can't seem to find an answer. > > > Thanks for the help. > > > Glen Plantz > --------------------
>From the docs - eg http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.15/lib/Spreadsheet/WriteExcel.pm#Cell_notation Probably the answers you are looking for are in the examples that come with the package from CPAN (missing from the AS ppm) A couple of lines from convertA1.pl: print "Cell B7 is equivalent to ("; print join " ", cell_to_rowcol('B7'); print ") in row column notation.\n"; but...apparently superceded by subs in Spreadsheet::WriteExcel::Utility. See the doc: C:\Perl\html\site\lib\Spreadsheet\WriteExcel\Utility.pm HTH - Lynn. _______________________________________________ Perl-Win32-Users mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
