Dear list
As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.
I produce a multi-col table of data in R and at the moment I reconfigure the
table in Excel so that I can copy/paste it into a report in Word.
I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.
>From the R code the table looks like this - up to 80 rows or more and 5 col
lab_id A B ZBW ZWI
4er66 3.60 3.30 3.26 6.49
4gcyi 2.96 2.91 0.47 1.10
5d3hh 3.08 3.11 1.34 -0.88
5d3wt 1.79 1.85 -5.60 -1.56
5ycya # # N/A N/A
Middle rows removed to save space
t5ee2 2.43 2.45 -2.23 -0.46
t9455 3.00 2.97 0.74 0.67
ta4ww 2.46 2.47 -2.09 -0.41
tatc4 2.65 2.64 -1.09 0.10
u3dd5 2.62 2.69 -1.04 -1.68
u6d33 2.72 2.72 -0.71 -0.30
v3s8f 3.06 3.09 1.21 -0.68
v44h6 2.72 2.73 -0.66 -0.29
wa5hh # # N/A N/A
Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this
lab_id A B ZBW ZWI lab_id A B ZBW
ZWI
4er66 3.60 3.30 3.26 6.49 h2o42 3.00 2.95 0.69
0.89
4gcyi 2.96 2.91 0.47 1.10 h5s22 3.86 3.79 5.30
1.44
5d3hh 3.08 3.11 1.34 -0.88 h7ss2 2.48 2.00 -3.32
10.35
5d3wt 1.79 1.85 -5.60 -1.56 i8s4b 2.90 2.86 0.16
0.64
5ycya # # N/A N/A ky3sn 2.94 2.93 0.47
0.21
Middle rows removed to save space
d33ww 2.93 3.00 0.62 -1.66 tatc4 2.65 2.64 -1.09
0.10
dml25 2.78 2.78 -0.39 -0.12 u3dd5 2.62 2.69 -1.04
-1.68
e33ws 2.95 3.02 0.73 -1.69 u6d33 2.72 2.72 -0.71
-0.30
f3c4g 2.72 2.74 -0.66 -0.65 v3s8f 3.06 3.09 1.21
-0.68
f3s5t 2.83 2.90 0.09 -1.73 v44h6 2.72 2.73 -0.66
-0.29
f44ee 2.79 2.77 -0.39 0.20 wa5hh # # N/A
N/A
g2a44 2.76 2.77 -0.45 -0.28
My question is there way a that Lyx/Latex can do this without my manual
intervention.
I hope that the post is clear enough, but if there are any questions please
shout
Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.
