in reply to Re^2: Parsing Data in xlsx file
in thread Parsing Data in xlsx file

Somehow your parsing code and your data don't seem to be related at all. For example your code checks if the data has 11 columns, but your data only has 5 columns. So no wonder it doesn't work. (Your data sample has 11 interesting rows, but I guess that's more of a coincidence.

I'd approach the problem like this: 

use strict;
use warnings;
use 5.010;

while (<DATA>) {
    # skip separator lines
    next if /^----/;

    my @columns = split /\s*\|\s*/;

    # remove leading space
    $columns[0] =~ s/^\s+//;

    # now do something with @columns
    # you'll want to do something else here, not just
    # printing to the console
    say join ',', @columns;
}

__DATA__
------|----------|--------|-------------------------|--------|
 S.No | TimeStamp| UE-Name| Test-Config             | UL/DL  |
------|----------|--------|-------------------------|--------|
 1    | 18:24:38 | -NA-   | Sanity_001_0001_10_00   | System |
------|----------|--------|-------------------------|--------|
 2    | 18:31:34 | ueh1   | Sanity_002_0002_00_11   | UL     |
------|----------|--------|-------------------------|--------|
 3    | 18:23:48 | ueh1   | Sanity_003_0003_06_09   | UL     |
------|----------|--------|-------------------------|--------|
 3    | 18:23:48 | ueh1   | Sanity_003_0003_06_09   | DL     |
------|----------|--------|-------------------------|--------|
 4    | 18:38:30 | ueh1   | Sanity_004_0004_24_00   | DL     |
------|----------|--------|-------------------------|--------|
 5    |  -NA-    | -NA-   | Sanity_001_0001_10_00   | System |
------|----------|--------|-------------------------|--------|
 6    | 18:31:34 | ueh2   | Sanity_002_0002_00_11   | UL     |
------|----------|--------|-------------------------|--------|
 7    | 18:23:49 | ueh2   | Sanity_003_0003_06_09   | UL     |
------|----------|--------|-------------------------|--------|
 7    | 18:23:48 | ueh2   | Sanity_003_0003_06_09   | DL     |
------|----------|--------|-------------------------|--------|
 8    | 18:38:30 | ueh2   | Sanity_004_0004_24_00   | DL     |
------|----------|--------|-------------------------|--------|

[download]
Perl 6 - the future is here, just unevenly distributed

Replies are listed 'Best First'.
Re^4: Parsing Data in xlsx file
by Rahul Gupta (Sexton) on Aug 02, 2012 at 10:29 UTC

    Sorry that's by mistake, i put only 5 columns here in actual data i have 11 columns.if it works for 5 columns then for sure it will work for 11 colums

    . so please help me .
[reply]
Re^4: Parsing Data in xlsx file
by Rahul Gupta (Sexton) on Aug 02, 2012 at 10:33 UTC

    Sorry, that's by mistake, I put only 5 columns here, in actual data i have 11 columns,i think if it works for 5 columns than for sure it will work for 11 columns also.

    please help me to resolve this problem.
[reply]
Re^4: Parsing Data in xlsx file
by Rahul Gupta (Sexton) on Aug 02, 2012 at 11:09 UTC
    hi, For more details this is my actual file. 
    ------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 S.No | TimeStamp| UE-Name| Test-Config             | UL/DL  | Status 
+| Jitter ms       | Throughput Mb/s | lost %          | Bandwidth Mb/
+s  | Duration Sec  | Fail-Reason |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 1    | 18:24:38 | -NA-   | Sanity_001_0001_10_00   | System | Passed 
+| -NA-            | -NA-            | -NA-            | -NA-         
+   | -NA-          | -NA-        |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 2    | 18:31:34 | ueh1   | Sanity_002_0002_00_11   | UL     | Passed 
+| 0.14 of 10.00   | 4.38 of 3.97    | 0.00 of 10.00   | 4.38         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 3    | 18:23:48 | ueh1   | Sanity_003_0003_06_09   | UL     | Passed 
+| 0.16 of 10.00   | 4.00 of 3.62    | 0.00 of 10.00   | 4.00         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 3    | 18:23:48 | ueh1   | Sanity_003_0003_06_09   | DL     | Passed 
+| 3.37 of 10.00   | 5.18 of 4.67    | 0.00 of 10.00   | 5.17         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 4    | 18:38:30 | ueh1   | Sanity_004_0004_24_00   | DL     | Passed 
+| 1.34 of 10.00   | 13.72 of 12.40  | 0.00 of 10.00   | 13.70        
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 5    |  -NA-    | -NA-   | Sanity_001_0001_10_00   | System |  -NA-  
+| -NA-            | -NA-            | -NA-            | -NA-         
+   | -NA-          | Micro-Step  |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 6    | 18:31:34 | ueh2   | Sanity_002_0002_00_11   | UL     | Passed 
+| 0.15 of 10.00   | 4.38 of 3.97    | 0.00 of 10.00   | 4.38         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 7    | 18:23:49 | ueh2   | Sanity_003_0003_06_09   | UL     | Passed 
+| 0.16 of 10.00   | 4.00 of 3.62    | 0.00 of 10.00   | 4.00         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 7    | 18:23:48 | ueh2   | Sanity_003_0003_06_09   | DL     | Passed 
+| 3.38 of 10.00   | 5.18 of 4.67    | 0.00 of 10.00   | 5.17         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 8    | 18:38:30 | ueh2   | Sanity_004_0004_24_00   | DL     | Passed 
+| 1.32 of 10.00   | 13.72 of 12.40  | 0.00 of 10.00   | 13.70        
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
# Total Test-Cases   = '4'
# Total Passed-Cases = '4'
# Total Failed-Cases = '0'
++++++ SUMMARY  ++++++
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 S.No | TimeStamp| UE-Name| Test-Config             | UL/DL  | Status 
+| Jitter ms       | Throughput Mb/s | lost %          | Bandwidth Mb/
+s  | Duration Sec  | Fail-Reason |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 1    | 18:24:38 | -NA-   | Sanity_001_0001_10_00   | System | Passed 
+| -NA-            | -NA-            | -NA-            | -NA-         
+   | -NA-          | -NA-        |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 2    | 18:31:34 | ueh1   | Sanity_002_0002_00_11   | UL     | Passed 
+| 0.14 of 10.00   | 4.38 of 3.97    | 0.00 of 10.00   | 4.38         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 3    | 18:23:48 | ueh1   | Sanity_003_0003_06_09   | UL     | Passed 
+| 0.16 of 10.00   | 4.00 of 3.62    | 0.00 of 10.00   | 4.00         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 3    | 18:23:48 | ueh1   | Sanity_003_0003_06_09   | DL     | Passed 
+| 3.37 of 10.00   | 5.18 of 4.67    | 0.00 of 10.00   | 5.17         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 4    | 18:38:30 | ueh1   | Sanity_004_0004_24_00   | DL     | Passed 
+| 1.34 of 10.00   | 13.72 of 12.40  | 0.00 of 10.00   | 13.70        
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 5    |  -NA-    | -NA-   | Sanity_001_0001_10_00   | System |  -NA-  
+| -NA-            | -NA-            | -NA-            | -NA-         
+   | -NA-          | Micro-Step  |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 6    | 18:31:34 | ueh2   | Sanity_002_0002_00_11   | UL     | Passed 
+| 0.15 of 10.00   | 4.38 of 3.97    | 0.00 of 10.00   | 4.38         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 7    | 18:23:49 | ueh2   | Sanity_003_0003_06_09   | UL     | Passed 
+| 0.16 of 10.00   | 4.00 of 3.62    | 0.00 of 10.00   | 4.00         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 7    | 18:23:48 | ueh2   | Sanity_003_0003_06_09   | DL     | Passed 
+| 3.38 of 10.00   | 5.18 of 4.67    | 0.00 of 10.00   | 5.17         
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
 8    | 18:38:30 | ueh2   | Sanity_004_0004_24_00   | DL     | Passed 
+| 1.32 of 10.00   | 13.72 of 12.40  | 0.00 of 10.00   | 13.70        
+   | 360           |  -NA-       |
------|----------|--------|-------------------------|--------|--------
+|-----------------|-----------------|-----------------|--------------
+---|---------------|-------------|
# Total Test-Cases   = '4'
# Total Passed-Cases = '4'
# Total Failed-Cases = '0'

    [download]

    same data is coming twice or sometimes thrice.

    Thanks
[reply]
[d/l]

In Section Seekers of Perl Wisdom