This code will help quickly transfer data from a remote server, instead of using SFTP/FTP client, like WinSCP.
read.xlsx () in “xlsx” package is a simple function that reads a sheet in .xlsx file. In Windows, however, you need to do some set-up before using this function if you get this error: When you get this error, put this one line before loading “xlsx” package. Now, you can enjoy read.xslx ()!
Originally posted on statMethods blog:
Working with a business audience, I am frequently called upon to send analytic results to clients in the form of Excel Workbooks. The xlsx package facilitates exporting tables and datasets Excel, but I wanted a very simple function that would let me easily export an arbitrary number of R objects to an Excel Workbook…
How would you convert the timezone of a time object which class is POSIXct?
The easiest, self-explanatory, way is to use Github GIST. Go to Github GIST. If you want to save your snippets and pastes in Github, you need to open an account (free) in Github GIST. A simple instruction for embedding Github Gist can be found at http://en.support.wordpress.com/gist/ Note: When you paste the Gist’s url on a line by itself…