search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
363 stars 79 forks source link

XML scheme is not complete #506

Open jliebert007 opened 4 years ago

jliebert007 commented 4 years ago

Expected Behavior

create .xlsx file that can be uploaded to Power BI

Actual Behavior

When I try to upload to Power BI, I get an error: "The input couldn't be recognized as a valid Excel document."

Steps to Reproduce the Problem

df <- (data.frame(matrix(rnorm(20), nrow=10))) style <- createStyle(border = "TopBottomLeftRight", fgFill = "yellow", textDecoration = "bold") write.xlsx(df, "df.xlsx", sheetName = "df", rowNames = FALSE, colnames = TRUE, borders = "all", keepNA = FALSE, colWidths = "auto", headerStyle = style)

df.xlsx

sessionInfo()

R version 3.6.2 (2019-12-12) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 10 x64 (build 18362)

Matrix products: default

locale: [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252 LC_MONETARY=English_United States.1252 [4] LC_NUMERIC=C LC_TIME=English_United States.1252

attached base packages: [1] stats graphics grDevices utils datasets methods base

other attached packages: [1] openxlsx_4.1.4.9000

loaded via a namespace (and not attached): [1] compiler_3.6.2 tools_3.6.2 Rcpp_1.0.3 stringi_1.4.5 zip_2.0.4

ycphs commented 4 years ago

Hi,

That is the old repository for this R Package.

Please use the new one:

https://github.com/ycphs/openxlsx

jliebert007 commented 4 years ago

I submitted the issue to the new repository. Thank you.

From: Philipp Schauberger notifications@github.com Sent: Friday, July 17, 2020 3:20 AM To: awalker89/openxlsx openxlsx@noreply.github.com Cc: Liebert Jonah JLiebert@schools.nyc.gov; Author author@noreply.github.com Subject: Re: [awalker89/openxlsx] XML scheme is not complete (#506)

Hi,

That is the old repository for this R Package.

Please use the new one:

https://github.com/ycphs/openxlsxhttps://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fycphs%2Fopenxlsx&data=02%7C01%7CJLiebert%40schools.nyc.gov%7Cee7de800b4724f2adf5a08d82a21e948%7C18492cb7ef45456185710c42e5f7ac07%7C0%7C1%7C637305672424177784&sdata=DDFkHpn7dH4e5DxBynZplK0JhWxM53ChwwzWbHT2H2M%3D&reserved=0

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fawalker89%2Fopenxlsx%2Fissues%2F506%23issuecomment-659917244&data=02%7C01%7CJLiebert%40schools.nyc.gov%7Cee7de800b4724f2adf5a08d82a21e948%7C18492cb7ef45456185710c42e5f7ac07%7C0%7C1%7C637305672424177784&sdata=HryYw%2FGmTnQfAmGj8DAz6LuWHy3%2F82KTiUYixwZ9XPI%3D&reserved=0, or unsubscribehttps://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAOL3Y4QDE4AQ67H2GRVV7BDR373UPANCNFSM4KLMVJNA&data=02%7C01%7CJLiebert%40schools.nyc.gov%7Cee7de800b4724f2adf5a08d82a21e948%7C18492cb7ef45456185710c42e5f7ac07%7C0%7C1%7C637305672424187776&sdata=wQf7jFtMeVG%2BIP%2BRBgjPxQGZHOSi4XZ38BKJAhiPpas%3D&reserved=0.