Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Modifying existing xlsx file #463

Open
ghd-crediwire opened this issue Jan 16, 2023 · 2 comments
Open

Modifying existing xlsx file #463

ghd-crediwire opened this issue Jan 16, 2023 · 2 comments

Comments

@ghd-crediwire
Copy link

ghd-crediwire commented Jan 16, 2023

Hi
Thank you for your great work!
Is it possible to read and modify an existing excel file? It looks like you can either only read or write an excel file not both.
Can you advice on how to extend the library to achieve modifying an existing excel file?

@fmjwn
Copy link

fmjwn commented Mar 13, 2023

根据模板导出文件的话,这个功能很有用。

@yangweijie
Copy link

根据模板导出文件的话,这个功能很有用。

确实有用,客户给了一个模板 有合并单元格 和设置表头 全黄色背景 部分列黄色背景,
我手动设置了行样式 和列样式 总是无法复现客户的模板。如果有直接读取后追加数据就很方便了。
phpoffice/spreadsheet 直接内存溢出,源文件才14kb。

template_export_20231212.xlsx
最后没办法,先导出一个纯excel 再手动粘贴原文件里临时解决了。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants