import mobile number from excel sheet in textboxex using php

Question

hello My excel sheet contains only mobile no and i want to import it. All mobile numbers are imported with the help of phpexcel file But problem is that import with its rows and columns also. like A B C 1 9422711166 2 7620620580 . so i dont want A B C 1 2 only i want mobile no. so what am i do...? Help me.... its very urgent... Thank you...

Sarath Babu · Answer

Pls chk attached

Sarath Babu · Answer

you can use rangeToArray(); but you don't need to use a loop at all: $highestRow = $sheet->getHighestRow(); $highestColumn = $sheet->getHighestColumn(); $sheetData = $sheet->rangeToArray( 'A2:' . $highestColumn . $highestRow NULLTRUEFALSE ); Alternatively use toArray() and then just unset the first element from the returned array For reference i am attaching files please check

priya mishra · Answer

Thanks for replying but my phpexel file does not phpexcel-iofactory factory function pls send me your phpexcel file