龙巍PC后端
blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白
cnf
2025-11-06 0dd60562defce9f8494121f4f5969ae07f4c0963 
 WebApi/Gs.Toolbox/ExcelHelper.cs


@@ -226,8 +226,8 @@




        //sheet.SetAutoFilter(new CellRangeAddress(0, 0, 0, dtSource.Columns.Count - 1)); //首行筛选


        // if (fixW <= 0)


        sheet.CreateFreezePane(dtSource.Columns.Count,


            1 + aryHeader.Count); //首行冻结


        //sheet.CreateFreezePane(dtSource.Columns.Count,


        //    1 + aryHeader.Count); //首行冻结


        //填充内容


        var dataRow = sheet.CreateRow(roct + 1);


        for (var i = 0; i < dtSource.Rows.Count; i++)


@@ -279,23 +279,9 @@


                _ftidx++;


            }


        }




        //保存


        using (var ms = new MemoryStream())


        {


            using (var fs = new FileStream(strFileName, FileMode.Create,


                       FileAccess.Write))


            {


                workbook.Write(ms);


                ms.Flush();


                ms.Position = 0;


                var data = ms.ToArray();


                fs.Write(data, 0, data.Length);


                fs.Flush();


            }


        }


    }






    /// <summary>


    /// 


    /// </summary>