点击查看帮助文档

        /// <summary>
        /// datatable 写入现有的EXCEL 
        /// </summary>
        /// <param name="dt_source">需要写入的数据源</param>
        /// <param name="filepath">excel 文件路径</param>
        /// <param name="sheetname">哪个页面 写</param>
        /// <param name="startrow">从第几行开始写 </param>
        public static void DtToExcel(DataTable dt_source, string filepath, string sheetname, int startrow)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(filepath);
            Worksheet sheet = workbook.Worksheets[sheetname];
            //从第一行第一列开始插入数据，true代表数据包含列名,false代表不包含列名，第二个bool代表是否保留原数据类型，false代表不会改变excel中的原数据类型
            sheet.InsertDataTable(dt_source, false, startrow, 1,false);
            //保存文件
            workbook.SaveToFile(filepath);
        }

字符替换excel

        void tihuanexcel(string fname, string tihuanqian, string tihuanhou)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(fname);
            Worksheet sheet = workbook.Worksheets[0];
            Spire.Xls.CellRange[] ranges = sheet.FindAllString(tihuanqian, false, false);
            foreach (Spire.Xls.CellRange range in ranges)
            {
                    Regex t1 = new Regex(tihuanqian);
                    range.Value = t1.Replace(range.Value, tihuanhou);
            }
            workbook.SaveToFile(fname);
        }