Releases: aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells Vs NPOI HWPF and XWPF v1.1
We are pleased to announce another release of Aspose.Cells for NPOI (HWPF and XWPF) which shows how different tasks can be performed using Aspose.Cells .NET APIs in comparison with NPOI.
This release have following examples:
- Working with Borders
- Working with Colors
- Working with Fonts
Existing Examples
Working with Workbooks
- Create New Workbook
- Add Data in Cells
- Set Print Area
Working with Data
- Getting Cell Contents
- New Line in Cells
- Insert Hyperlinks in Worksheet
Aspose .NET Export Users and Roles to Excel for DNN
The release of this module supports the following features.
- Export users to Microsoft Excel Documents (.xls, .xlsx and .xlsb)
- Export users to Tab delimited text document (*.txt)
- Export users to CSV (Comma delimited) (*.csv)
- Export users to OpenDocument Spreadsheet (*.ods)
- Option to select desired output format before exporting.
- Option to export all or selected users to selected output document format.
- Exported document is automatically sent to browser for downloading.
For most complete documentation of the project, check Aspose .NET for DNN confluence wiki link:
http://www.aspose.com/docs/display/cellsnet/8.+Aspose.Cells+.NET+for+DNN
Aspose .NET Import Users from Excel for DNN Module
Aspose .NET Import Users from Excel File to DNN Module allows developers to Import bulk users from Excel file into DNN. Module makes the process seamless for developers and automatically filters out existing users in DNN, which saves users from manually filtering. This module demonstrates the powerful spreadsheet features provided by Aspose.Cells. This initial version of the module is enriched with the following cool features to make the Import process simple and easy to use.
- Allows you to upload Excel file and automatically filters out existing users.
- Automatically skips the existing users to avoid any confusion.
- Generate dynamic passwords for the newly created users.
- Assigns "Registered Users" and "Subscribers" Security roles to newly created users.
For most complete documentation of the project, check Aspose .NET for DNN confluence wiki link:
http://www.aspose.com/docs/display/cellsnet/8.+Aspose.Cells+.NET+for+DNN
Aspose Export GridView To Excel Control 1.0
Export GridView To Excel Control is an ASP.NET server control which allows exporting contents of GridView into Microsoft Excel or OpenOffice Spreadsheets using [Aspose.Cells|http://www.aspose.com/.net/excel-component.aspx]. It adds Export to Excel button on top of the GridView control. Clicking the button dynamically exports the content of the GridView control to a Microsoft Excel or OpenOffice Spreadsheet and then automatically downloads the exported file to the disk location selected by the user in just couple of seconds.
This initial version of the control provides the following features:
- Get an offline copy of your favorite online GridView content for editing, sharing and printing.
- Inherited from default ASP.NET GridView control and hence have all its features and properties.
- Export GridView to Xlsx, Xlsb, Xls, Txt, Csv, Ods.
- Works with all .NET versions starting from .NET 2.0.
- Ability to customize/localize Export button text.
- Apply look and feel of your own theme on Export button using css.
- Option to add custom heading on top of the exported document
- Option to save each exported document on server at configurable disk path
- Option to export current page or all pages when paging is enabled
Missing Features of OpenXML SDK Cells v 1.0
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
Convert between Excel formats
High-level programming with a workbook object model
Copy fragments and worksheets between Workbooks
Generate reports, populate documents with data
Smart Markers feature
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
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.
Aspose.Cells Vs VSTO Excel v1.1
Aspose.Cells for .NET is a .NET API to work with Microsoft Excel, while VSTO, or Visual Studio Tools for Office, or Microsoft Visual Studio Tools is part of Microsoft's Visual Studio .NET tools suite and supports the Microsoft .NET Framework. It is used by developers to write code connecting Microsoft Office Word, Excel and Outlook applications. 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
- Create and Save New Workbooks
- Open Text Files as Workbooks
- Copy Worksheets
- Delete Worksheets from Workbooks
- Sort Data in Worksheets
- Apply Styles to Ranges in Workbooks
- Display String in Worksheet Cell
Existing Examples
- Adding New Worksheets to Workbook and Activating a Sheet
- Protecting and Unprotecting Workbooks
- Inserting and Removing Cell Comments in a Worksheet
- Merge or UnMerge Cells in a Worksheet
- Add Borders to Cells in a Worksheet
- Add Hyperlinks to Cells
- Hide and Unhide Worksheets in a Workbook
- Set Background Picture of a Worksheet
- Rotating Cell Text
- Wrapping Cell Text
- Get Text of Specific Cell
- List All Worksheets in a Workbook
- Protect and unProtect Worksheets
- Creating a Named Range
- Create a Pie Chart
- Auto Filter Data
- Use Formulas Functions to Process Data
- Find Specific Word Occurrence
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.
Aspose.Cells Vs OpenXML Cells v1.0
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). 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
- Calculate the sum of a range of cell
- Create a spreadsheet document
- Delete text from a cell
- Get a column heading
- Get worksheet information
- Insert a chart
- Insert a new worksheet
- Insert text into a cell
- Merge two adjacent cells
- Retrieve the values of cells
Feedback and Suggestions
- Examples are also available at Aspose Docs.
- Raise your queries and suggest more examples via [Aspose Forums](http://www.aspose.com/community/forums/default.aspx] or via this social coding site.
Aspose.Cells Features Missing in NPOI - v 1.0
Project Aspose.Cells for NPOI (HSSF and XSSF) shows how different tasks can be performed using Aspose.Cells .NET APIs in comparison with NPOI. The project also covers the features that are only available in Aspose.Cells APIs but not in NPOI for dealing with Microsoft office or OpenOffice Spreadsheets.
This project is helpful for developers who want to compare NPOI with Aspose.Cells OR migrate from NPOI to Aspose.Cells.
Examples for code with missing features in NPOI (HSSF and XSSF) in comparison with Aspose.Cells:
Data Handling Features
- Find Value in Cells
- Calculate Sub Totals
- Formula Calculation Engine
Working with Worksheets
- Set Worksheet Tab Color
- Save Each Worksheet to Different PDF
Working with Charts
- Create Charts
- Convert Chart to Images
Miscellaneous Examples
- Set Print Titles
- Printing Workbooks
- Convert Spreadsheet to PDF
Aspose .NET Update Export Tool for Microsoft Dynamic CRM v1.0
Sometimes it is harder to create/Update data in records directly in CRM. We are providing this tool that can save the efforts in term of time and cost. Simply, export the data from any entity and any field on your desktop in excel, and you can easily handle or update the data in excel. Once data is updated, import it back to CRM from excel.
Features in this Release
This provide functionality to automatically Update,Export and Import data from/to CRM.
Below are the major features:
- Establish the connection to desired CRM.
- Allow user to select desired Entity and Fields.
- Getting the record from CRM display in grid.
- Export the record to Aspose.Cells Spreadsheet.
- Get the record from Aspose.Cells Spreadsheet display in grid.
- Export the record from grid to CRM.
Other Releases
Microsoft Dynamics CRM 2015
- Aspose .NET BarCodeGenerator for Dynamics CRM 2015
- Aspose .NET Quote Generator for Dynamics CRM 2015
- Aspose .NET AutoMerge For Dynamics CRM 2015
- Aspose .NET AutoMerge v2 for Dynamics CRM 2015
- Aspose .NET ImageAttach for Dynamics CRM 2015
- Aspose .NET Duplicate Detection for CRM 2015
Microsoft Dynamics CRM 2013
- Aspose .NET Quote Generator for Dynamics CRM 2013
- Aspose .NET AutoMerge v2 for Dynamics CRM 2013
- Aspose .NET ImageAttach for Dynamics CRM 2013
- Aspose .NET Duplicate Detection for CRM 2013
Microsoft Dynamics CRM 2011
Feedback and Suggestions
- Add-on are also available at Aspose Docs.
- Raise your queries and suggest more examples via Aspose Forums or via this social coding site.
Aspose.Cells vs NPOI.HSSF and XSSF 1.0
Project Aspose.Cells for NPOI (HSSF and XSSF) shows how different tasks can be performed using Aspose.Cells .NET APIs in comparison with NPOI. This project is helpful for developers who want to compare NPOI with Aspose.Cells OR migrate from NPOI to Aspose.Cells.
This initial release of the project have the following comparison examples
- Create New Workbook
- Add Data in Cells
- Set Print Area
- Getting Cell Contents
- New Line in Cells
- Insert Hyperlinks in Worksheet