Creating a workbook in R

Hi All,

I am working with the "OpenXLSX" package in R and was wondering, if I create a workbook with multiple tabs utilizing the R tool can I directly output that into the excel output tool or do I need to create separate outputs for each tab and then each table within each tab and organize it in a different way.

Thanks

Workflow

Output

Apps

R Tool

Accepted answers

roe_r

Of course I forgot to attach the workflow. Here is is.

Insert data into a specific excel range.yxzp

All comments

JoeS

I think you'd output it within the R code itself?

Or do you mean you have created different elements and want to then read them into Alteryx designer?

emorrill

The final output of my R script is a workbook in .xlsx format. It has multiple tabs and and multiple tables within each tab. I would like to just utilize that script and have the output from the R function be the .xlsx file but I was not sure how that would be possible using alteryx where exporting an XLSX file requires you to select the sheet you wish to output to.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703