search

nacnudus / tidyxl

Read untidy Excel files in R https://nacnudus.github.io/tidyxl/
https://nacnudus.github.io/tidyxl/
Other
246 stars 20 forks source link

R Studio crashes reading file #71

Closed kuri-pablo closed 3 years ago

kuri-pablo commented 3 years ago

I keep crashing R Studio when trying to read the attached xlsx file. Any thoughts or workarounds? Thanks. reporteinstitucion dsh_637564984151768951.xlsx

nacnudus commented 3 years ago

Thank you for taking the trouble to report this. I can reproduce the crash, but I don't know why it does yet.

I opened it in LibreOffice Calc, saved a new copy of it, and that copy opens in tidyxl. Perhaps that would work for you (or use Excel, or Google Sheets, or whatever other spreadsheet software is available to you).

kuri-pablo commented 3 years ago

Thanks. I did open the file in Sheets and then exported it to Excel. It worked.

The problem with the approach is the amount of files to open and save. If you find a solution I would appreciate your input.

nacnudus commented 3 years ago

I will keep trying to find the cause of the error.

If you can use libreoffice from the command line, then it's possible to process the files as a batch. See for example https://www.libreofficehelp.com/batch-convert-writer-documents-pdf-libreoffice/.

kuri-pablo commented 3 years ago

Excellent, I'll try your recomendation.

nacnudus commented 3 years ago

I think this is now fixed. Please reopen this issue if not.

e-mcbride commented 3 years ago

Hi @nacnudus I am still encountering this issue using tidyxl to import an .xlsx file downloaded from SurveyMonkey. I have tidyxl version 1.0.7 installed. Your fix did work though: once I opened the file in Excel and saved a new copy, it imported successfully.

nacnudus commented 3 years ago

@e-mcbride sorry that you're having this problem, thank you for reporting it. Are you able to install the latest version 1.0.7.9000 from GitHub by doing, for example, remotes::install_github("nacnudus/tidyxl")? If that fixes the problem, then I will publish this version to CRAN.

e-mcbride commented 3 years ago

@nacnudus unfortunately that didn't work :/ Let me know if there is anything else I can do to test this!

nacnudus commented 3 years ago

@e-mcbride Please can you provide an example file that causes the error?

e-mcbride commented 3 years ago

@nacnudus Thank you so much for looking into it! Here you go: https://ucsb.box.com/s/3h6dg2hsmgx08laseag2ml88v1oqfg0t

Please let me know if the link expires before you get a chance to download it! I can make a new one.

nacnudus commented 3 years ago

@e-mcbride Thanks for providing the file. The cause is different from the one in this issue, so I have created a new issue #73 to track it. Sorry it has taken me so long to address this.