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]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.