Re^3: Excel Text parsing problem

[grizzley]

in reply to Re^2: Excel Text parsing problem
in thread Excel Text parsing problem

Well...

I've replaced worksheet(1) with worksheet(0) (because had data in first worksheet) and replaced $txt->insert with print 'end: ', "$row:$col----$worksheet->{Cells}[$row][$col]->{Val}\n"; statement and got proper results:

c:\d\test>bla.pl Book1.xls
Row, Col        = (7, 0)
Value      = LWSHI1C

end: 7:0----LWSHI1C
Row, Col        = (7, 1)
Value      = 900

end: 7:1----900
Row, Col        = (7, 3)
Value      = 2

end: 7:3----2
Row, Col        = (7, 5)
Value      = 3

end: 7:5----3

c:\d\test>

What I can advice in that situation is: please make the same corrections in your script and run it in console to make sure you have data in worksheet(1).

[reaper9187]

no i think you didnt understand the problem .. When i use the print command , it only displays the text in the command prompt window ( i have absolutely no problem in doing that evn now)... What i'm looking for is a way to print this text on a text area in a GUI window using perl Tk... I have defined the main widnow , text areas, alignment etc.. i have to display this text on the main GUI window..I use the $txt ->insert command to print it in the text area... but somehow it prints only some of the values(rather than all) ...

[grizzley]

But it's only string! There is no magic in adding text in Tk, so there is no way Tk is doing something wrong (especially that it prints beginning, i.e. "row:col----". Something is wrong with string and the problem is tracking why the string is empty.