Add An Export Module to Shiny-app for Highcharts Figure

[This article was first published on Category: R | Huidong Tian's Blog, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Highcharts is the best JavaScript chart library, I feel. By default, there is an export button which can let you save the interactive figure to PNG, JPEG, PDF and SVG format, and one important point is, you can use it in your shiny app through R package rCharts. However, there are some limits in such a way, the default exporting engine is based http, so if your shiny-app’s portal is https, then you can’t use the exporting feature (It seems Highcharts has also a https based export engine). I have spent a lot of time to configure a Highcharts export server, it works internally, but not outside. I can’t figure out the problem, but I found another solution.

The figures created by Highcharts are actually SVG element in HTML, we can easily extract that element using JavaScript, and fill it into a textInput of Shiny, when textInput received the svg element, its value changed, so it triggered Shiny server to response, then we can let Shiny-server to save the SVG element onto our server. We can convert that SVG file into the format we want, and download it use downloadHandler.

The most difficult parts to R users which not familiar with JavaScript and Linux are:

1. Extract the SVG element and fill it to textInput.

ruby // Export module function figExport() { // Select chart and get svg data; var chart = $(".shiny-html-output.rChart.highcharts.shiny-bound-output").highcharts() var svg = chart.getSVG(); var svg = svg.replace(/<g class="highcharts-button".*?g>/, "") var svg = svg.replace(/<g class="highcharts-tooltip".*?g>/, "") // Empty target object and fill with new svg data; var target = $("#svg"); target.val(""); target.val(svg); target.trigger("change"); $("#Export").attr("style", "height: 105px;") $(".ePanel").attr("style", "visibility: visible;"); $(".wPanel:has(#export)").mouseleave(function(){ $(".ePanel").attr("style", "visibility: hidden;"); $("#Export").attr("style", "height: 30px;") }); }

We can bind this function to a button: when clicking the button, browser will extract the SVG element, fill it into an textInput and tell Shiny-server that the textInput got a new value. After receiving that textInput’s value has changed, Shiny-server will save its value to a SVG file.

“` ruby p <- reactiveValues() observe({ p$tempSVG <- paste(tempfile(), “svg”, sep =”.”) p$tempPDF <- paste(tempfile(), “pdf”, sep =”.”) p$tempPNG <- paste(tempfile(), “png”, sep =”.”) if (!is.null(input$svg)) { if (nchar(input$svg)>0) { writeLines(input$svg, p$tempSVG) } } })

“`

2. Convert SVG file to other formats under Linux.

There are several programs can convert svg file to other formats, I choose inkscape (sudo apt-get install inkscape), after installing it on your server, we can call it through R using system function:

“` ruby # Export figure as PDF; output$uiFigPDF <- renderUI({ downloadLink(outputId = “figPDF”, label = E2N(“Export figure as PDF”)) }) output$figPDF <- downloadHandler( filename = function() { paste(‘Highcharts-‘, Sys.Date(), ‘.pdf’, sep=’’) }, content = function(file) { system(paste(“inkscape -f”, p$tempSVG, “-A”, p$tempPDF)) file.copy(p$tempPDF, file) } )

“`

That’s it!

We can also add an option to change the dimension of the figure:

“` ruby

output$uiDim <- renderUI({ textInput(inputId = “dim”, label = E2N(“Figure dimensions (W x H):”), value = “1000 x 1200”) })

Inside of ‘renderChart’ in server.r

if (!is.null(input$dim)) { H$exporting(sourceWidth = as.numeric(strsplit(input$dim, “ *x *”)[[1]][1]), sourceHeight= as.numeric(strsplit(input$dim, “ *x *”)[[1]][2]), enabled = FALSE) }

“`

And to export the figure data is even simple:

“` ruby # Export figure data; output$uiFigDat <- renderUI({ downloadLink(outputId = “figDat”, label = E2N(“Export figure data”)) }) output$figDat <- downloadHandler( filename = function() { paste(‘Highcharts data-‘, Sys.Date(), ‘.csv’, sep=’’) }, content = function(file) { write.table(p$data, file, row.names = FALSE, quote = FALSE, sep = “;”, na = “”, dec = ifelse(input$lang == “no”, “,”, “.”)) } )

“`

where p$data was assign before. Here is a demo, and you can find the source code on my gist.

To leave a comment for the author, please follow the link and comment on their blog: Category: R | Huidong Tian's Blog.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)