New release version of Spire.XLS 7.4

We are glad to announce a new release version of Spire.XLS 7.4. By the efforts of our develop team, we have added two new features to this version. Our develop team also focus on fixing bugs in this version. Details are as followed:

New Features:

Add a new feature to get the page count of excel file and the row and column number of page break.

Workbook wb = new Workbook();
wb.LoadFromFile(@"..\..\test.xlsx");
List> pageInfoList = wb.GetSplitPageInfo();
//Get the sheet count
int sheetCount=pageInfoList.Count;
//The page count of the first sheet
int pageCount = pageInfoList[0].Count;

Add a new feature to show totals in a pivot table as percentage of totals.

pt.DataFields[0].ShowDataAs = PivotFieldFormatType.PercentageOfTotal;

Bug Solutions:

  • Fix the format is missing issue when filling data into cell range.
  • Fix the sheet still can be edited when set the property SheetProtectionType.Objects
  • Fix some content is missing issue in converted Image from Excel.

Welcome to experience Spire.XLS 7.4 with downloading here:

http://www.e-iceblue.com/Download/download-excel-for-net-now.html