Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Excel usage with Perl

by miloanuragse (Initiate)
on Nov 16, 2006 at 05:20 UTC ( [id://584372]=perlquestion: print w/replies, xml ) Need Help??

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)

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

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.

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...

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://584372]
Approved by chargrill
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (6)
As of 2024-04-16 06:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found