How to Automate Excel with R

Your company lives on them - Excel Workbooks. They take you FOR-EV-ER to make. Why not automate? Learn how In this 7-minute video: automate #Excel with #R using #openxlsx & #tidyquant. Here are the links to get set up 👇

Once you take these actions, you'll be set up to receive R-Tips with Code every week. 👍

THE R-TRACK PROGRAM
==============================
Learning R is tough, takes a long time, is advanced, is...

What am I say?! Learning R for business can be fast & easy. Here's how.

I have a complete system designed to teach you R, Data Science, Advanced Machine Learning, Web App Development, Time Series, & more - all for business. It's insanely powerful. Over 6+ months, learn everything needed to become an R Rockstar for Your Organization.

[hansmeiser]

There might be several applications for this in business communications. I prefer to use SQlite3 (free) and a corresponding odbc-driver (free) to keep data dynamically between R and Excel (incl. Excel-Charts). This then is a real 'killer team'. Bigger companies will use non-free enterprise level db-communications. Keep tidy on Matt, you are one of best tutors out there!

[MsSoapify]

Ia there a way to automate this so that the script would run automatically with or without you needing to run it? I've tried using the cron library for R but was unsuccessful.

[abediaz]

Just got some reps in with this but with crypto data. It's pretty cool!

[ahmedJaber]

hi mate, thank u for this. i am getting this error arning message:

package ‘openxlsx’ was built under R version 4.1.1
the other package requires java and somehow it worked once and won't work again

any ideas??

[victormandela]

Thanks for this. Does this also apply for google sheets?

[bbinder]

Thanks Mat. I notice when I run this code that stock_data_table shows 2019-12-30 as the last date:

it should be 2019-12-31
if I change the date range to :tq_get(from = "2010-01-01", to = "2020-01-01") it works as expected
is this a bug
I have similar problem when using quantmod and I think it may have to do with the 4 hr time difference between the EST and GMT

[lucidlessons]

hey mate do you have a slack channel ?