Vino, First learn how to use Excel with Perl. The below might be useful, please check them out.
http://support.microsoft.com/kb/214797 http://www.ibm.com/developerworks/linux/library/l-pexcel/ Emeka On Thu, Aug 4, 2011 at 10:03 AM, VinoRex.E <vino...@gmail.com> wrote: > 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 > -- *Satajanus Nig. Ltd *