c# 导出excel 为什么数据不能编辑 必须要设置excel的 取消工作表保护才可以，代码里面怎么改呢？

Question

strb.Append(" ");             strb.Append(" ");             strb.Append("  ");             strb.Append("  ");             //设置工作组名             strb.Append("    " + FileName.Split(':')[0].Trim() + "");             strb.Append("    ");             strb.Append("    285 ");             strb.Append("    ");             strb.Append("    ");             strb.Append("      ");             strb.Append("      3 ");             strb.Append("      1 ");             strb.Append("      ");             strb.Append("    ");             strb.Append("    False ");             strb.Append("    False ");             strb.Append("    False ");             strb.Append("    ");             strb.Append("  ");             strb.Append("  6750 ");             strb.Append("  10620 ");             strb.Append("  480 ");             strb.Append("  75 ");             strb.Append("  False ");             strb.Append("  False ");             strb.Append(" ");             strb.Append(" ");             strb.Append("");

Answer 1

可以使用npoi来操作excel，利器。是不是你的xml格式才导致这样的问题啊

Answer 2

导出的excel格式不正确