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).
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^4: Excel Text parsing problem
by reaper9187 (Scribe) on Nov 08, 2012 at 09:47 UTC | |
by grizzley (Chaplain) on Nov 08, 2012 at 10:39 UTC |