I have file, when u can check here: http://www.nbp.pl/kursy/Archiwum/archiwum_tab_a_1999.xls
I want to get first row of this file into list. When I do this:
dane <- read.xls("http://www.nbp.pl/kursy/Archiwum/archiwum_tab_a_1999.xls")
names(dane)
I recieved list but some weird values like X1, X2. I want list of this elements: Nr / No. Data / Date 1 USD 1 EUR 1 AUD etc.
EDIT:
result of dput(dane):
http://pastebin.com/5YZwMx6a
EDIT 2:
result of names(dane):
[1] "X" "X.1"
[3] "W.A.L.U.T.A.....C.U.R.R.E.N.C.Y" "X.2"
[5] "X.3" "X.4"
[7] "X.5" "X.6"
[9] "X.7" "X.8"
[11] "X.9" "X.10"
[13] "X.11" "X.12"
[15] "X.13" "X.14"
[17] "X.15" "X.16"
[19] "X.17" "X.18"
[21] "X.19" "X.20"
[23] "X.21" "X.22"
The problem is that you have your first row as a bunch of merged cells. You should try with an edited version that deletes the first row.
It wasn't clear to me that read.xls would honor a request to skip lines but it does, so this succeeds: