Spire.XLS for WPF is a professional Excel component which enables developers/programmers to fast generate, read, write and modify Excel document for WPF. Spire.XLS for WPF doesn't need Microsoft Office Excel Automation. It allows user to operate Excel document directly such as save to stream, save as web response, copy, lock/unlock worksheet, set up workbook properties, etc. As a professional WPF Excel component, it owns the ability of inserting content into Excel document and formatting cells. Spire.XLS for WPF supports Excel 97-2003, Excel 2007 and Excel 2010. New Version fixed bugs of reading and writing pivot and some bugs of Formatting,Cacluating engine, formula, alignment,etc.
1) Support powerful sorting features: sort data in both horizontal and vertical directions which allows developers to sort data from top to bottom or left to right.
2)Improved charts data preservation and pivot table for Excel 2003/2007/2010.
3)Enable to Load PageBreaks and WorksheeOptions.ShowPageBreakZoom in Excel 2003 XML file4)Enable to Write PageBreaks and ShowPageBreakZoom into Excel 2003 XML file
5)Added ZoomScaleNormal, ZoomScalePageBreakView and ZoomScalePageLayoutView in Worksheet
6)Support loading/writing ZoomScaleNormal and ZoomScalePageBreakView in Excel 2003 and Excel 2003 XML file
7)Support loading/writing ZoomScaleNormal, ZoomScalePageBreakView and ZoomScalePageLayoutView in Excel 2007/2010
8)Enable to load and write viewMode in Excel 2003
1)Access violation exception during calling method LoadFromFile, caused by allocating not enough buffer.
2)When one row has one cell which has multiple lines of text, AutoFitRow opreation caused an exception.
1) Directly Operate Excel Document
2) Import/Export data from/to Excel
3) Format Cells
4) Insert Content to Excel Document
6) Marker Designer