Skip to content

Instantly share code, notes, and snippets.

View holgerman's full-sized avatar

Holger holgerman

  • Universität Leipzig / IMISE - GenStat
View GitHub Profile
---
title: "Research pipeline"
output:
flexdashboard::flex_dashboard:
orientation: rows
theme: yeti
---
```{r include=FALSE}
library(tidyverse)
@holgerman
holgerman / remove_password_excel.R
Created May 7, 2018 15:56 — forked from markheckmann/remove_password_excel.R
Remove sheet's password protection in Excel
# remove sheet protection in Excel
# Sample file: https://www.dropbox.com/s/4ul0kowrscyr8cz/excel_protected.xlsx?dl=0
library(stringr)
library(zip)
# file with protected sheets
file <- "data/excel_protected.xlsx"
# file name and path after removing protection
library(shiny)
library(ggplot2)
shinyServer(function(input, output) {
dataset <- reactive({
diamonds[sample(nrow(diamonds), input$sampleSize),]
})
output$plot <- renderPlot({