dotnetcore / dotnetcore/Magicodes.IE

使用Magicodes.EPPlus导出Excel时,数据导出为空问题

Open
#220 0 comments 0 reactions 0 assignees View on GitHub
area-excel Magicodes.EPPlus
Dominant language
C#
Stars
2.2k
Forks
495
PR merge metrics
No merged PRs in 30d

Description

在对ExcelRange 为Excel 单元格赋值遇到一个奇怪的问题
如:sheet.Cells["AA5"].Value="asdf";
一直赋不上,赋完后,sheet.Cells["AA5"].Value 还是返回空
![image](https://user-images.githubusercontent.com/41372670/103147555-9aed3900-4791-11eb-973a-b0f1bea92f7a.png)

在导出excel之后,我查了xl\sharedStrings.xml里面是有字符串的,
xl\worksheets\sheet1.xml也有对应的值
只是excel打开之后,单元格没有加载出来

后面换了直接使用EPPlus,导出则没有此问题

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.