Here it is described how Excel tables are imported into RStudio. This is done by selecting
Import Dataset in the File menu, and then scrolling to the Excel sheet you want to import. When this is done, the code in RStudio looks like this:
To create what looks like DataTables, an R package called DT is needed. To achieve the table we are looking for, write the following code in RStudio in direct connection to the previous code:
To then export this table, select
Export followed by
Save as Web Page in the menu just above the window where the table is visible.
P.S. There are also ways of making these tables downloadable. However, I don’t see a need for that at the moment.