Excel usage with Perl

miloanuragse has asked for the wisdom of the Perl Monks concerning the following question:

I am using ActiveState 5.8.8 Build819, which is latest available on ActiveState.

I have created a Graphics interface using Tk and try to use excel sheet in the program. I am getting the filename and row and column to process using the interface...

i used $Sheet->Cells($row,$coltag)->{'Value'} to access a cell but it is showing error. It is working fine if Tk is not used. Error displayed is-

Tk::Error: Can't use an undefined value as a HASH reference at Generat
+e_traceabi
lity_matrix1.pl line 66.
 Tk callback for .button1
 Tk::__ANON__ at C:/Perl/lib/Tk.pm line 252
 Tk::Button::butUp at C:/Perl/lib/Tk/Button.pm line 111
 <ButtonRelease-1>
 (command bound to event)
[download]

If I change $coltag variable with actual value then it works fine.

I feel that latest version do not allow both arguments in Cells() to be variable.

If this is the reason, Please suggest some alternative

Comment on Excel usage with Perl Download Code

Replies are listed 'Best First'.
Re: Excel usage with Perl by chromatic (Archbishop) on Nov 16, 2006 at 06:39 UTC
I feel that latest version do not allow both arguments in Cells() to be variable. I find that very difficult to believe. Unless it does some really scary XS magic to check arguments, that should be immaterial. We can only speculate, however, unless we see the relevant code. I suspect the value you get from the interface is not what you think it is.	[reply]
Re: Excel usage with Perl by reneeb (Chaplain) on Nov 16, 2006 at 07:35 UTC
You should tell us which module you are using. It's hard to tell you anything without details...	[reply]