Releases: aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells Vs NPOI HWPF and XWPF v1.3
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 Worksheets
Existing Examples
Working With Worksheets
- Add Image in Worksheet
- Create New Worksheet
- Copy Worksheet
- Headers and Footers
- ReOrder WorkSheets
- Zoom Factor
Working with Formatting Features
Working with Workbooks
Working with Data
Sitefinity Dynamic Forms Builder with Data Export to Excel, CSV, Text and OpenDocument Spreadsheet using Aspose.Cells
Aspose.Cells Dynamic Forms for Sitefinity Module allows users to Generate Dynamic Questionnaire and Surveys, save user input into Excel Spreadsheet and Export the results into Excel, Text, CSV and OpenDocument Spreadsheet using Aspose.Cells. This module demonstrates the powerful spreadsheet building feature provided by Aspose.Cells for .NET.
Module Features
This initial version of the module is enriched with the following features to make the Forms Building and Export process simple and easy to use
- Save Form Field Settings in Excel
- Save Form’s User Input Data in to Excel
- Allow to Add new and Update existing Form Fields
- Allow to Add TextBox, Multiline TextBox, RadioButtons, CheckBox and DropDownList, DropDownList Items type Fields
- Allow to Add/Update Label for each Fields
- Allow to Show/Hide Form Fields
- Auto Fit Columns to contents length and apply Header Column formatting as Bold Text
- Export Data to Microsoft Excel Documents (.xls, .xlsx and .xlsb)
- Export Data to Tab delimited text document (*.txt)
- Export Data to CSV (Comma delimited) (*.csv)
- Export Data to OpenDocument Spreadsheet (*.ods)
- Option to select desired output format before exporting.
- Exported document is automatically sent to browser for downloading.
Download, Installation and Usage
Please check the links below to find instructions on downloading, installing, configuring and using the module.
Explore Aspose.Cells for .NET API Examples using Visual Studio Plugin
Explore Aspose.Cells for .NET API Examples using Visual Studio Plugin
Aspose.Cells for .NET Examples Visual Studio plugin is a great tool for quickly downloading and exploring Aspose.Cells for .NET API examples. We are pleased to announce a new release which supports exploring examples of Aspose.Cells for .NET. This plugin saves a lot of time and efforts by providing a very simple option for seamlessly selecting, downloading and opening the latest example projects without having to leave the Visual Studio environment.
Plugin Features
This version provides the following features:
- Supports Visual Studio 2010 and Visual Studio 2012 and Visual Studio 2013.
- Easy to launch from File > Aspose menu in Visual Studio
- Saves time and reduces the learning curve.
- Enables you to select and open the latest Aspose.Cells for .NET API examples hosted on Github.com.
- Allow you to open C# or VB.NET examples project
- A selected project is automatically opened in Visual Studio with all required references set to give you a ready to run and explore environment.
- Automatically downloads the latest API libraries from NuGet and examples from GitHub.
Aspose.Cells for .NET
Aspose.Cells for .NET provides the most flexible group of components that enable .NET applications to create, modify, convert, render and print Excel® spreadsheets without requiring Microsoft Excel® to be installed on the server.
Aspose.Cells for .NET supports all the major Microsoft Excel and other file formats including XLS, XLSX, XLSM, XLTX/XLTM, HTML, CSV, ODS, Tab Delimited, SpreadsheetML and PDF, etc.
For more details about Aspose.Cells for .NET API
Download, Installation and Usage
Please check the links below to find instructions on downloading, installing, configuring and using these development templates.
Generate Dynamic Questionnaire and Surveys, save user input into Excel Spreadsheet and Export the results into Excel Text CSV and OpenDocument Spreadsheet using Aspose.Cells Forms for DNN
Aspose.Cells Dynamic Forms for DNN Module allows users to Generate Dynamic Questionnaire and Surveys, save user input into Excel Spreadsheet and Export the results into Excel, Text, CSV and OpenDocument Spreadsheet using Aspose.Cells. This module demonstrates the powerful spreadsheet building feature provided by Aspose.Cells for .NET.
Module Features
This initial version of the module is enriched with the following features to make the Forms Building and Export process simple and easy to use
- Save Form Field Settings in Excel
- Save Form’s User Input Data in to Excel
- Allow to Add new and Update existing Form Fields
- Allow to Add TextBox, Multiline TextBox, RadioButtons, CheckBox and DropDownList, DropDownList Items type Fields
- Allow to Add/Update Label for each Fields
- Allow to Show/Hide Form Fields
- Auto Fit Columns to contents length and apply Header Column formatting as Bold Text
- Export Data to Microsoft Excel Documents (.xls, .xlsx and .xlsb)
- Export Data to Tab delimited text document (*.txt)
- Export Data to CSV (Comma delimited) (*.csv)
- Export Data to OpenDocument Spreadsheet (*.ods)
- Option to select desired output format before exporting.
- Exported document is automatically sent to browser for downloading.
Download, Installation and Usage
Please check the links below to find instructions on downloading, installing, configuring and using the module.
Umbraco Export Data to Excel Text CSV and OpenDocument Spreadsheet using Aspose.Cells
Umbraco Export Data from database table or custom query to Excel Text CSV and OpenDocument Spreadsheet using Aspose.Cells
Aspose .NET Umbraco Data Exporter to Excel Module allows users to export data directly from local or remote database tables, views and by custom query into Microsoft Excel or OpenOffice Spreadsheet. This module demonstrates the powerful spreadsheet building feature provided by Aspose.Cells. This initial version of the module is enriched with the following cool features to make the Export process simple and easy to use
- Allow to connect Local MS SQL Server Database
- Allow to connect Remote MS SQL Server Database
- Populate all Tables from connected database
- Populate all Views from connected database
- Allow to write Custom Query
- Allow to use as Data Source (Table, Views, Custom Query)
- Auto Fit Columns to contents length.
- Allow to skip string more than 32k in excel cells (LoadOptions)
- Apply Header Column formating as Bold Text
- Export Data to Microsoft Excel Documents (.xls, .xlsx and .xlsb)
- Export Data to Tab delimited text document (*.txt)
- Export Data to CSV (Comma delimited) (*.csv)
- Export Data to OpenDocument Spreadsheet (*.ods)
- Option to select desired output format before exporting
- Exported document is automatically sent to browser for downloading
Download, Installation and Usage
Please check the links below to find instructions on downloading, installing, configuring and using the module.
Aspose.Cells Vs NPOI HWPF and XWPF v1.2
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 Worksheets
- Add Image in Worksheet
- Create New Worksheet
- Copy Worksheet
- Headers and Footers
- ReOrder WorkSheets
- Zoom Factor
Existing Examples
Working with Formatting Features
- Working with Borders
- Working with Colors
- Working with Fonts
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
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
- Set External Links in Formulas
- Setting Formula Calculation Mode of Workbook
- Setting Shared Formula
Existing Examples
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 .NET Export Users to Excel for SiteFinity
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.Cells .NET for SiteFinity confluence wiki link.
Aspose .NET DNN Export Data to Excel Text CSV and OpenDocument Spreadsheet using Aspose.Cells V1.0
Aspose .NET DNN Data Exporter to Excel Module allows users to export data directly from local or remote database tables, views and by custom query into Microsoft Excel or OpenOffice Spreadsheet. This module demonstrates the powerful spreadsheet building feature provided by Aspose.Cells. This initial version of the module is enriched with the following cool features to make the Export process simple and easy to use
- Allow to connect Local MS SQL Server Database
- Allow to connect Remote MS SQL Server Database
- Populate all Tables from connected database
- Populate all Views from connected database
- Allow to write Custom Query
- Allow to use as Data Source (Table, Views, Custom Query)
- Auto Fit Columns to contents length
- Allow to skip string more than 32k in excel cells (LoadOptions)
- Apply Header Column formating as Bold Text
- Export Data to Microsoft Excel Documents (.xls, .xlsx and .xlsb)
- Export Data to Tab delimited text document (*.txt)
- Export Data to CSV (Comma delimited) (*.csv)
- Export Data to OpenDocument Spreadsheet (*.ods)
- Option to select desired output format before exporting
- Exported document is automatically sent to browser for downloading
Download, Installation and Usage
Please check the links below to find instructions on downloading, installing, configuring and using the module.
Missing Features of VSTO in Aspose.Cells v 1.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
- Save Workbook to Text or CSV Format
- Encrypting Excel Files
- Display or Hide Tabs
- Display or Hide Scroll Bars
- Display or Hide Gridline
- Display or Hide Row Column Headers
- Advanced Protection Settings since Excel XP
- Tracing Precedents and Dependents
- Adding Hyperlinks to Link Data
Exisiting Examples
Smart Markers
- Smart Markers feature
- Grouping Data
- Using Anonymous Types or Custom Objects
- Image Markers
- Using Nested Objects
Converting Worksheet
Import and Export Worksheet
Conversion
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.