This simple tutorial will show you how to download data into an excel spreadsheet, creating a web query. Download data into excel select ”data” tab select ”from web” input the desidered web URL click ”go” button **select **data you want to download click ”import” button Refresh downloaded data select ”data” tab select “connections” select your connection click “refresh” button
2014
as part of the** excel functions in R,** I have developed this custom function, reproducing the excel right() function in th R language. Feel free to copy and use it. [code language=“r”] right = function (string, char){ substr(string,nchar(string)-(char-1),nchar(string))} [/code] you can find other function in the Excel functions in R post.
I have started my ”data-journey” from Excel, getting excited by formulas like VLookup(), right() and left(). then datasets got bigger, and I discovered that little spreadsheets were not enough, and look for something bigger and stronger, eventually coming to R. But as you know, ones never forget the first love. So, for fun and for practice, I have written down some of excel functions in R. I hope you will enjoy.