Spire.XLS 操作Excel

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52

using Spire.Xls; using System.Linq;   namespace WrapperPrint.Tools {     /// <summary>     /// 因为npoi应不会真正删除行，只会清除数据,导致打印出来空标签     /// 所以增加此帮助类删除数据。     /// nuget引入FreeSpire.XLS组件     /// </summary>     public class SpireEexcelHelper     {         private Workbook workbook;         private Worksheet sheet;         public string FileName { get; set; }           public SpireEexcelHelper(string fileName)         {             this.workbook = new Workbook();             workbook.LoadFromFile(fileName);             this.sheet = workbook.Worksheets[0];             FileName = fileName;         }         /// <summary>         /// 删除指定行         /// </summary>         /// <param name="startIndex">开始行</param>         /// <param name="endIndex">结束行</param>         public void DeleteRows(int startIndex, int endIndex)         {             for (int i = startIndex; i <= endIndex; i++)             {                 sheet.DeleteRow(i + 1);//索引从0开始             }         }         public void DeleteRows(int startIndex)         {             int endIndex = GetRowCount();             sheet.DeleteRow(startIndex + 1, endIndex);         }         public int GetRowCount()         {             return sheet.Rows.Count();         }         public void Save()         {             //要保存成老版本的             workbook.SaveToFile(FileName, ExcelVersion.Version97to2003);             workbook.Dispose();         }     } }