View Code? Open in Web Editor
NEW
Fix the Excel 2010+ comments in xlsx/xlsm file can't open at Excel 2007
License: Other
excel-comments-fixer's Introduction
- 🔭 Now Status:▇▇Who▇▇I▇▇▇am▇?
- 🌱 What I learning:Python,Html,CSS,PHP
- 👯 ———————://
- 💬 Wechat:▇▇▇▇▇▇▇▇
- 📫 Alma Mater:▇▇▇▇▇▇▇▇▇
excel-comments-fixer's People
Contributors
Watchers
excel-comments-fixer's Issues
[批注修复的逻辑本身很简单,来自ExcelHome论坛s6492大佬提供的手动修改方法((https://club.excelhome.net/thread-1039441-2-1.html)),程序本身只是通过C#代码和SharpZip复现了这一手动操作。]
具体方法如下:
1.将excel2007以上版本保存的xlsx文件后缀名修改为zip
2.用压缩软件打开zip文件,找到xl目录下有comments前缀的xml文件
3.用任意十六进制编辑器打开,找到shapeid=0,批量替换为空值,保存
4.将文件后缀名zip改回xlsx即可
也可搜索安装office2007的补丁根治这个问题:office2007sp3-kb2526086-fullfile-zh-cnab.zip
之后会公开早期写的不成熟的源代码:flushed: