Missing Features of OpenXML SDK Excel v 1.1

Aspose.Cells for .NET is a .NET API to work with Microsoft Excel and OpenOffice presentations, while OpenXML SDK is a .NET SDK from Microsoft to work with OpenXML presentations (MS Excel 2007 and above). This release provides source code examples of the Aspose.Cells for .NET features which are not available in OpenXML SDK. In order to use these source code examples, you will need to reference Aspose.Cells for .NET in your project. You can download Aspose.Cells for .NET from here

What's New

• Encrypting Excel Files
• Save Workbook to Text or CSV Format
• Managing Charts and Shapes
  • Add WordArt Watermark to Chart
  • Add WordArt Watermark to Worksheet
  • Locking WordArt Watermark
  • Copy Shapes between Worksheets
• Set External Links in Formulas
• Setting Formula Calculation Mode of Workbook
• Setting Shared Formula

Existing Examples

Convert between Excel formats

• Convert between Excel formats

High-level programming with a workbook object model

• Find and Replace in Spreadsheet
• Assemble Spreadsheets

Copy fragments and worksheets between Workbooks

• Copy Worksheets within a Workbook
• Copy Worksheets between Workbooks
• Move Worksheets within Workbook

Generate reports, populate documents with data

• Import Export data from document
• Insert or Delete Rows or Columns

Smart Markers feature

• Grouping Data
• Using Anonymous Types or Custom Objects
• Image Markers
• Using Nested Objects

Rendering and Printing in Aspose.Cells

• Convert charts to images
• Specify image resolution, quality, compression and other options
• Print spreadsheets

Calculate or Recalculate formulas dynamically

• Calculate or Recalculate formulas dynamically

Feedback and Suggestions

• Examples are also available at Aspose Docs.
• Raise your queries and suggest more examples via Aspose Forums or via this social coding site.