Hello I am trying to import an Excel file but I am loosing the headers, My
headers are in the first to rows of the EXCEL file. In the following R
output, the NA are supposed to be the second item in the Header. Is there
any way to Import more than one row as headers?. Thank you

Felipe Parra

> Data<-odbcConnectExcel('Curva LIBOR.xlsx',readOnly=T,)
> AbioRep<-sqlFetch(Data,'LIBOR-SWAP')
> head(AbioRep)
        Date US0001W Index US0002W Index US0001M Index US0002M Index US0003M
Index US0004M Index US0005M Index US0006M Index US0007M Index US0008M Index
1 2005-01-04       2.32938       2.33563        2.4000
2.49000          2.57        2.6400        2.7100        2.7900
2.85000       2.91000
2 2005-01-05       2.32875       2.33875        2.4000
2.50625          2.59        2.6625        2.7425        2.8275
2.89063       2.95125
3 2005-01-06       2.33000       2.34125        2.4200
2.52000          2.61        2.6800        2.7600        2.8400
2.90813       2.97000
4 2005-01-07       2.32875       2.34000        2.4300
2.52000          2.61        2.6800        2.7600        2.8350
2.89625       2.95125
5 2005-01-10       2.32875       2.34063        2.4400
2.53000          2.62        2.6900        2.7700        2.8500
2.91125       2.97000
6 2005-01-11       2.33000       2.34000        2.4425
2.53013          2.63        2.7000        2.7800        2.8600
2.92750       2.98625
  US0009M Index US0010M Index US0011M Index US0012M Index        F16 USSA1
Curncy USSA2 Curncy USSA3 Curncy
1        2.9675       3.01750       3.06375       3.11000
<NA>           NA           NA           NA
2        3.0150       3.07375       3.13000       3.18063 2005-01-03
3.4345       3.4345        3.660
3        3.0300       3.08875       3.14000       3.19000 2005-01-04
3.5355       3.5355        3.757
4        3.0100       3.06000       3.11000       3.16000 2005-01-05
3.5395       3.5395        3.761
5        3.0300       3.08938       3.14000       3.19125 2005-01-06
3.5050       3.5050        3.725
6        3.0500       3.10625       3.15625       3.21000 2005-01-07
3.5450       3.5450        3.760

	[[alternative HTML version deleted]]

