Error with Excel's Spreadsheet Compare: Cannot open files generated by write.xlsx() in R.

Wataru Kitagawa 0 Reputation points
2024-11-22T01:52:18.1+00:00

Using Office Professional Plus 2021, Excel's Spreadsheet Compare tool fails to open files when I attempt to compare two xlsx files. An error message below appears:
'Error opening workbook. Specified part does not exist in the package.'

This happens whenever I try to compare files generated by using a function write.xlsx() in a R package openxlsx. The files look perfectly fine when I open in Excel.

Could anyone possibly pinpoint the cause of this issue?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,732 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.