Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re^4: Extract column of excel

by MynameisAchint (Novice)
on Jun 05, 2013 at 05:17 UTC ( #1037123=note: print w/replies, xml ) Need Help??


in reply to Re^3: Extract column of excel
in thread Extract column of excel

Hey thank you for replying , now the problem I am having is that when code gets a blank cell it does not copy it to the array , it copies the next entry in column but I desire that even blank cells be copied as blank entry in array

Replies are listed 'Best First'.
Re^5: Extract column of excel
by hdb (Monsignor) on Jun 05, 2013 at 05:27 UTC

    Good morning. If you do not post some sample data, it is difficult to provide meaningful suggestions. The description of your problem is inconsistent with the code you have posted.

    split does not skip any empty field, apart from trailing ones. And I cannot see any way that it would use the next entry in column, ie from the next line.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1037123]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (6)
As of 2018-09-20 02:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Eventually, "covfefe" will come to mean:













    Results (170 votes). Check out past polls.

    Notices?
    • (Sep 10, 2018 at 22:53 UTC) Welcome new users!