Hi i am a beginner in Perl i have a pdb file containing the X,Y,and Z coordinates of atoms example given below. the data extends upto 1000 atoms and its coordinates. I need a perl program to export these data into excel worksheet into distinct columns and ROws.
ATOM 1 N GLY A 2 1.888 -8.251 -2.511 1.00 36.63 N ATOM 2 CA GLY A 2 2.571 -8.428 -1.248 1.00 33.02 C ATOM 3 C GLY A 2 2.586 -7.069 -0.589 1.00 30.43 C ATOM 4 O GLY A 2 2.833 -6.107 -1.311 1.00 33.27 O ATOM 5 N GLY A 3 2.302 -6.984 0.693 1.00 24.67 N ATOM 6 CA GLY A 3 2.176 -5.723 1.348 1.00 18.88 C ATOM 7 C GLY A 3 0.700 -5.426 1.526 1.00 16.58 C ATOM 8 O GLY A 3 -0.187 -6.142 1.010 1.00 12.47 O ATOM 9 N LEU A 4 0.494 -4.400 2.328 1.00 15.00 N ATOM 10 CA LEU A 4 -0.835 -3.926 2.630 1.00 12.93 C ATOM 11 C LEU A 4 -0.868 -2.457 2.294 1.00 11.77 C ATOM 12 O LEU A 4 0.007 -1.688 2.694 1.00 12.22 O ATOM 13 CB LEU A 4 -1.151 -4.122 4.110 1.00 13.01 C ATOM 14 CG LEU A 4 -2.536 -3.681 4.562 1.00 12.36 C ATOM 15 CD1 LEU A 4 -3.577 -4.568 3.912 1.00 13.37 C ATOM 16 CD2 LEU A 4 -2.644 -3.766 6.052 1.00 12.77 C ATOM 17 N GLN A 5 -1.864 -2.055 1.522 1.00 10.93 N ATOM 18 CA GLN A 5 -2.101 -0.667 1.209 1.00 11.87 C ATOM 19 C GLN A 5 -3.075 -0.147 2.264 1.00 12.25 C ATOM 20 O GLN A 5 -4.200 -0.648 2.394 1.00 11.71 O ATOM 21 CB GLN A 5 -2.697 -0.574 -0.199 1.00 12.69 C ATOM 22 CG GLN A 5 -2.977 0.839 -0.692 1.00 18.30 C ATOM 23 CD GLN A 5 -1.725 1.720 -0.785 1.00 23.25 C ATOM 24 OE1 GLN A 5 -1.726 2.887 -0.412 1.00 29.61 O ATOM 25 NE2 GLN A 5 -0.612 1.212 -1.270 1.00 25.58 N ATOM 26 N VAL A 6 -2.637 0.814 3.049 1.00 10.73 N ATOM 27 CA VAL A 6 -3.466 1.409 4.078 1.00 10.95 C ATOM 28 C VAL A 6 -3.829 2.773 3.519 1.00 11.49 C ATOM 29 O VAL A 6 -3.054 3.742 3.589 1.00 9.28 O ATOM 30 CB VAL A 6 -2.688 1.567 5.433 1.00 13.22 C ATOM 31 CG1 VAL A 6 -3.664 2.085 6.488 1.00 13.44 C ATOM 32 CG2 VAL A 6 -2.109 0.228 5.926 1.00 11.70 C ATOM 33 N LYS A 7 -5.047 2.846 2.984 1.00 10.74 N ATOM 34 CA LYS A 7 -5.515 4.029 2.280 1.00 11.66 C ATOM 35 C LYS A 7 -5.445 5.308 3.081 1.00 11.12 C ATOM 36 O LYS A 7 -5.045 6.377 2.623 1.00 13.12 O ATOM 37 CB LYS A 7 -6.965 3.858 1.829 1.00 15.50 C ATOM 38 CG LYS A 7 -7.335 4.947 0.832 1.00 19.57 C ATOM 39 CD LYS A 7 -8.820 5.172 0.874 1.00 30.36 C ATOM 40 CE LYS A 7 -9.206 6.372 0.017 1.00 34.59 C ATOM 41 NZ LYS A 7 -10.630 6.633 0.157 1.00 39.48 N ATOM 42 N ASN A 8 -5.791 5.168 4.347 1.00 12.07 N ATOM 43 CA ASN A 8 -5.912 6.310 5.227 1.00 12.81 C ATOM 44 C ASN A 8 -4.602 6.946 5.628 1.00 12.09 C ATOM 45 O ASN A 8 -4.583 8.068 6.119 1.00 14.21 O ATOM 46 CB ASN A 8 -6.621 5.928 6.515 1.00 14.50 C ATOM 47 CG ASN A 8 -8.000 5.398 6.243 1.00 11.94 C ATOM 48 OD1 ASN A 8 -8.128 4.266 5.782 1.00 12.17 O ATOM 49 ND2 ASN A 8 -9.008 6.195 6.513 1.00 14.60 N ATOM 50 N PHE A 9 -3.511 6.229 5.464 1.00 10.86 N ATOM 51 CA PHE A 9 -2.264 6.756 5.951 1.00 12.74 C ATOM 52 C PHE A 9 -1.522 7.551 4.909 1.00 13.14 C ATOM 53 O PHE A 9 -0.921 7.001 4.018 1.00 15.38 O ATOM 54 CB PHE A 9 -1.417 5.568 6.457 1.00 14.18 C ATOM 55 CG PHE A 9 -1.761 5.002 7.835 1.00 13.51 C ATOM 56 CD1 PHE A 9 -2.871 5.453 8.570 1.00 12.16 C ATOM 57 CD2 PHE A 9 -0.921 4.025 8.380 1.00 13.88 C ATOM 58 CE1 PHE A 9 -3.107 4.934 9.847 1.00 13.66 C
