converting from Row, Column to Cell Name, and back, in Excel
Title: Message 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 ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: converting from Row, Column to Cell Name, and back, in Excel
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 Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
Re: converting from Row, Column to Cell Name, and back, in Excel
Glen Plantz wrote: 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 ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs i had wrote one simple function to conwert number to letter. I think you can it also make. I had make one hash from a to z and with this i conwert the number. ___ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs