Ability to send data visuals to their own tabs within excel

[Anonymous]

Hello,

Please bear with me as I provide a simple example, and the eventual solution I am trying to obtain.

1. I have pulled in some data via SQL.

2. I have created two seperate visuals (tables) where I have placed a filter on the 2 visuals to display only certain data within the visual

    Example: 

    Visual One: Filter where "columnA" = "Yes"

    Visual Two: Filter when "columB"  = "Yes"

3. I have been playing with R code and the openxlxs library to try to get the data from Visual One to export to a specific tab in excel, and the data from Visual Two to export to a different specific tab in excel.

It is possible, using R code and openxlsx to perform this function? I can supply any generic screenshots if needed.

[V-lianl-msft]

Hi @Anonymous ,

Please refer to this blog:

https://thebipower.fr/index.php/2019/02/09/export-data-to-excel/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.