R for Excel Users: The XLView() Function
It’s time for another post about R.
I’ll admit, these days most of my work is done in R. But, I still love using Excel, and I really do enjoy teaching and blogging about it.
Fortunately, these two platforms work great together… they collide, in a good way. And XLView() is a great example.
Subscribe to my newsletter for your free ebook, “The Beginner’s Guide to Getting Hired with Excel.”
Let’s say you need to do some data analysis or manipulation in R but want to bring it back into Excel for visualization or distribution to colleagues.
In the past, I may have used write.csv() to export the file to a csv, then gone to Excel to open.
That’s still a solid option, but I really like this XLView() function from the DescTools() library. Get this function running with the below packages…
Continue reading...
About me: I am a PhD student in design & innovation at Case Western Reserve University, Weatherhead School of Management. I like helping people manage their data so they can think more creatively. Visit me at georgejmount.com.