Spire.XLS 12.1 支持為單元格設置 Html 字符串！

Spire.XLS 12.1已發布。該版本支持為單元格設置Html字符串、為現有數據透視表添加條件格式，還支持向IsPasswordProtected()添加文件流、獲取 IPrstGeomShape 的鏈接單元名稱，并且還支持計算單個工作表或單元格范圍。此外還增強了Excel到PDF，Excel到HTML，Excel到ODF以及HTML到Excel的轉換功能，并且修復了圖表保存到圖片后內容不正確等已知問題。

支持為單元格設置 Html 字符串

Workbook workbook = new Workbook();
workbook.LoadFromFile(@"input.xlsx");
Worksheet sheet = workbook.Worksheets[0];
sheet.Range["A1"].HtmlString = "<div>xxxx<br>yyyy</div>";

支持為現有數據透視表添加條件格式

Workbook workbook = new Workbook();
workbook.LoadFromFile(@"input.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
PivotTable table = worksheet.PivotTables[0] as PivotTable;
PivotConditionalFormatCollection pcfs = table.PivotConditionalFormats;
PivotConditionalFormat pc = pcfs.AddPivotConditionalFormat();
IConditionalFormat cf = pc.AddCondition();
cf.FormatType = ConditionalFormatType.ContainsBlanks;
cf.FillPattern = ExcelPatternType.Solid;
cf.BackColor = Color.Red;

支持向 IsPasswordProtected() 添加文件流

bool havepwd = Workbook.IsPasswordProtected(File.OpenRead(inputFile));
var docBytes = File.ReadAllBytes(inputFile);
MemoryStream ms = new MemoryStream(docBytes);
bool havepwd = Workbook.IsPasswordProtected(ms);

支持獲取 IPrstGeomShape 的鏈接單元名稱

Workbook book = new Workbook();
book.LoadFromFile("input.xlsx");
Worksheet sheet = book.Worksheets["sheet1"];
PrstGeomShapeCollection prstGeomShapeCollection = sheet.PrstGeomShapes;
IPrstGeomShape shape = prstGeomShapeCollection["a"];
shape.LinkedCell.RangeAddressLocal;

支持計算單個工作表或單元格范圍

Workbook workbook = new Workbook();
workbook.LoadFromFile("input.xlsx");
workbook.Worksheets[0].CalculateAllValue();
workbook.Worksheets[0].Range["A1：C3"].CalculateAllValue();