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

悬赏园豆：100 [已解决问题] 解决于 2013-04-18 15:11

strb.Append(" <xml>");
             strb.Append(" <x:ExcelWorkbook>");
             strb.Append(" <x:ExcelWorksheets>");
             strb.Append(" <x:ExcelWorksheet>");
             //设置工作组名

             strb.Append("    <x:Name>" + FileName.Split(':')[0].Trim() + "</x:Name>");
             strb.Append("    <x:WorksheetOptions>");
             strb.Append("    <x:DefaultRowHeight>285 </x:DefaultRowHeight>");
             strb.Append("    <x:Selected/>");
             strb.Append("    <x:Panes>");
             strb.Append("      <x:Pane>");
             strb.Append("      <x:Number>3 </x:Number>");
             strb.Append("      <x:ActiveCol>1 </x:ActiveCol>");
             strb.Append("      </x:Pane>");
             strb.Append("    </x:Panes>");
             strb.Append("    <x:ProtectContents>False </x:ProtectContents>");
             strb.Append("    <x:ProtectObjects>False </x:ProtectObjects>");
             strb.Append("    <x:ProtectScenarios>False </x:ProtectScenarios>");
             strb.Append("    </x:WorksheetOptions>");
             strb.Append(" </x:ExcelWorksheet>");
             strb.Append(" <x:WindowHeight>6750 </x:WindowHeight>");
             strb.Append(" <x:WindowWidth>10620 </x:WindowWidth>");
             strb.Append(" <x:WindowTopX>480 </x:WindowTopX>");
             strb.Append(" <x:WindowTopY>75 </x:WindowTopY>");
             strb.Append(" <x:ProtectStructure>False </x:ProtectStructure>");
             strb.Append(" <x:ProtectWindows>False </x:ProtectWindows>");
             strb.Append(" </x:ExcelWorkbook>");
             strb.Append(" </xml>");
             strb.Append("");