rm_invalid: Remove Invalid Excel Sheet Characters
In faouser1/FAO: Official FAO Package

Description Usage Arguments Details Value Examples

View source: R/rm_invalid.R

rm_invalid Removes invalid excel sheet special characters.

1	rm_invalid(x)

`x`	A string or vector of strings.

rm_invalid is useful if you are writing sheets to excel. Excel will not allow certain special characters in sheet names. Invalid characters include colons, square brackets, asterisks, question marks, vertical bars, new lines and tabs.

x with invalid characters removed.

rm_invalid(c("excel sheet* example[]: a fake string", "another test::"))

library(xlsx)
string <- "Table* [5]?"
df <- data.frame(foo = 1:3, bar = 1:3)
sName <- rm_invalid(string)
write.xlsx(df, "foo.xlsx", string) #Will throw error
write.xlsx(df, "foo.xlsx", sName)  #No error