我正在尝试根据表列的数量取消合并并重新合并更短或更长的范围
我使用了下面的代码,但它似乎不起作用
tableSheet.Cells["C1:J1"].Merge = false;
任何帮助将不胜感激。
您运行的是 EPP 4.0.1 吗?如果是这样,则这是一个已知问题:
https://epplus.codeplex.com/workitem/15134 https://epplus.codeplex.com/workitem/15134
有人发布了替换设置器Merge
属性(尽管 getter 看起来仍然不正确)。当我将其替换设置器粘贴到 ExcelRangeBase.cs 并重新编译时,此测试方法开始为我工作:
[TestMethod]
public void Merge_Unmerge_Cells_Test()
{
var existingFile = new FileInfo(@"c:\temp\temp.xlsx");
if (existingFile.Exists)
existingFile.Delete();
using (var package = new ExcelPackage(existingFile))
{
var workbook = package.Workbook;
var worksheet = workbook.Worksheets.Add("newsheet");
worksheet.Select("A1:C3");
worksheet.SelectedRange.Merge = true;
worksheet.SelectedRange.Value = "Merged Value";
worksheet.SelectedRange.Merge = false;
package.Save();
}
}
如果您运行的是版本 3,它应该可以正常工作,因此可以粘贴其余的代码。
更新:来自 codeplex 链接的代码。寻找public bool Merge
并更换套件。
set
{
IsRangeValid("merging");
//SetMerge(value, FirstAddress);
if (!value)
{
if (_worksheet.MergedCells.Contains(FirstAddress))
{
_worksheet.MergedCells.Remove(FirstAddress);
}
else
{
throw (new ArgumentException("Range is not merged"));
}
if (Addresses != null)
{
foreach (var address in Addresses)
{
if (_worksheet.MergedCells.Contains(address.Address))
{
_worksheet.MergedCells.Remove(address.Address);
}
else
{
throw (new ArgumentException("Range is not merged"));
}
}
}
}
else
{
_worksheet.MergedCells.Add(new ExcelAddressBase(FirstAddress), true);
if (Addresses != null)
{
foreach (var address in Addresses)
{
_worksheet.MergedCells.Add(address, true);
//SetMerge(value, address._address);
}
}
}
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)