![]() |
#1
|
|||
|
|||
![]()
I'm trying to convert a folder of xml that was created by unzipping an excel file back into an excel .xlsx. But I get the error
>The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt The actual file I want to recreate is a fairly large macro-enbled .xlsm spreadsheet created with Excel 2016. I am using the xml format to archive in a git repository in order to provide version control. However, restoring a version from the archive requires that I can reverse the process. However, a minimal example with a simple spreadsheet also reproduces this issue. **A minimal reproducible example to generate this error:** 1. Create a new blank spreadsheet in Excel 2. Enter "test" in cell A1 3. Save as `test.xlsx` 4. Rename file to `test.zip` 5. Unzip `test.zip` as a folder named `test` 6. Compress `test` into `test_new.zip` 7. Rename `test_new.zip` as `test_new.xlsx` 8. Open `test_new.xlsx` with Excel I am using Excel 2016. For zipping/unzipping I've tried 7zip, WinZip and Peazip, all with the same result. What am I doing wrong, and how can I turn unzipped excel workbooks back into their original form? Last edited by dww; 10-19-2016 at 04:17 PM. |
Tags |
xml zip |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create microsoft Excel 2007 and 2010 File in .xlsx format | ipacesetters | Excel | 1 | 12-16-2019 05:13 PM |
![]() |
tonytonytony | Excel | 3 | 03-10-2016 04:18 PM |
Excel connot open file (filename) xlsx | dengeorge6 | Excel | 0 | 12-12-2014 01:36 AM |
XLSX file won't open when clicked | MikeyChris | Excel | 9 | 09-20-2013 07:55 AM |
![]() |
teddysika | Excel | 1 | 11-22-2012 06:06 AM |