converting from Row, Column to Cell Name, and back, in Excel

2006-01-04 Thread Glen Plantz 
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

2006-01-04 Thread Lynn. Rickards 

  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

2006-01-04 Thread beefreak 

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