Screenshot Preview

Aspose.Cells for .NET - Resumen

de Aspose - Tipo de producto: Componente / ASP.NET WebForms / .NET WinForms

Para su comodidad, hemos incluido enlaces a Google Translate para traducir la información del producto que todavía tenemos que traducir. Por favor, tenga en cuenta que traducciones automáticas no siempre son totalmente exactas.

 Con la tecnología de

Resumen

 *

Aspose.Cells for .NET by Aspose

URLs: aspose-cells-net, aspose cells net, asposecellsnet, aspose

Create and manage Excel Spreadsheets without requiring Microsoft Excel. Aspose.Cells delivers real Excel spreadsheets in a desktop or web server environment without Microsoft Excel installed on either server or user's computer. Aspose.Cells supports spreadsheet generation and other basic file formatting features. Aspose.Cells also supports a number of advanced features. These advanced features make Aspose.Cells much more convenient for developers to manipulate contents, format cells and protect files.

Aspose.Cells was developed using Managed C# and it can be used with any .NET language like C#, VB.NET and J# etc. Aspose.Cells can be used with any kind of application either as an ASP.NET Web Application or a Windows Application. Aspose.Cells provides fully featured demos and working examples written in both C# and VB.NET for developers to have a better understanding of Aspose.Cells.

Besides supporting common features like creating or reading native Excel files, Aspose.Cells also supports many advanced features such as saving and opening Excel files to and from streams, sending output to a client browser, importing and exporting data from a DataTable, DataView or Array, importing images and charts, creating images and charts through API, importing formulae from a designer spreadsheet and configuring page setup through API. Aspose.Cells also supports Addins, VBA and macros.

Moreover, there are also a number of advanced features such as the support of CSV format, adding the copy of an existing worksheet (with full contents, images and charts etc.) to a file, setting gradient background for charts through API, creating comments, auto-filters and page breaks through API, setting complex formulae, supporting conditional formatting, supporting protection options introduced in Microsoft Excel XP, manipulating named ranges, locating APIs, supporting custom chart API and formula calculation engine etc.

Document Features

Open Plain or Encrypted Excel files from different sources

Save Excel files in different formats

Convert Excel file to PDF document

Modify the Document Properties of Excel files

Worksheet Features - Display Options

Hide or Unhide a Worksheet

Display or Hide Tabs, Scroll Bars, Gridlines & Row/Column Headers

Preview Page Breaks

Set Zoom Level for the Worksheet

Make selected data remain visible while scrolling using Freeze Panes

Worksheet Protection

Protect Contents, Objects and Scenarios of a Worksheet

Page Setup Options

Set Page Orientation, Scaling, Paper Size, Print Quality etc.

Set Page Margins like Top, Left, Right, Bottom etc.

Set Headers and Footers

Set Print Area, Print Title etc.

Page Breaks

Insert Horizontal and Vertical Page Breaks at a specified cell

Rows & Columns Features

Adjust Row Height according to your desire

Adjust Column Width as required

Auto size the width and height of cells according to their contents

Insert or Delete Rows and Columns

Hide or Unhide Rows and Columns

Group or Ungroup Rows and Columns

Data Management Features

Access any Cell in the worksheet

Add data to desired Cells at runtime

Import data into Worksheets from different data sources

Retrieve data from cells according to their data types

Export cells data to DataTable

Find or Search specific data in cells

Set Formulae with Built-in or Add-in Functions

Set Array and R1C1 reference style Formula

Add different kinds of Hyperlinks

Create or Access Named Ranges

Apply Data Validation and Auto-Filtering

Formatting Features

Apply different Styles on the Cells

Apply Number Format Settings for the Cells

Format Cell as a Date

Set Text Alignment

Merge multiple Cells into single one

Apply different kinds of Font Settings for the Cells

Apply different Colors to Cells, Fonts, Gridlines, Graphic Objects etc.

Set Rich Text in a Single Cell

Apply different Border Settings on Cells

Apply different Background Patterns on Cells

Apply Format Settings on a Worksheet, Row or Column etc.

Apply Conditional Formatting on Cells

Charting & Graphics Features

Supports all standard Chart Types like Column, Bar, Line, Pie, Scatter etc.

Create Different kinds of Charts easily

Customize Charts by setting their different properties

Set Data for the Charts dynamically

Add Custom Charts to Worksheets using API

Add Pictures to Worksheets at runtime

Create and Add Comments to cells

Advance Features

Supports Designer Spreadsheets and Smart Markers

Supports Formula Calculations using robust Formula Calculation Engine

Supports accessing Aspose.Cells from COM Clients

Change Source Data of a Pivot Table at runtime

Platforms Supported

Window Forms Support

Web Forms Support

What's new in Aspose.Cells for .NET V8.2.0?

Fixed bug where the data validator list does not return expected values.

Added Unsupported excel 2013 function - Days.

What's new in Aspose.Cells for .NET V8.1.2?

FileFormatUtil.DetectFileFormat uses all system's available memory while detecting a corrupted spreadsheet.

What's new in Aspose.Cells for .NET V8.1.1?

The following bugs were fixed:

SheetRender fails when UpdateSelectedValue is used.

Curved Connector shape does not appear when rendering XLSX to PDF.

PivotTable Sub-Totals have incorrect cell merging.

GetPivotData function computes erronated value.

Aspose.Cells Embeds Incorrect Fonts in the PDF.

X-axis labels are cut off.

Bullet points do not render correctly if they are within a text box.

Legend lines are thiner than in Excel.

Bullet list under the Cycle heading is not properly converted to PDF.

Opening and saving the file causes Custom Views error.

What's new in Aspose.Cells for .NET V8.1.0?

Added pivot table option called "For empty cells show"

Fixed performance issue while formatting pivot table rows

What's new in Aspose.Cells for .NET V8.0.1?

Set TIFF Pixel format for rendered images.

What's new in Aspose.Cells for .NET V8.0.0?

Optimize memory usage when building workbooks with large data sets.

Export data without hidden rows and columns.

Fixed PrintTitleRow problem using Turkish regional settings.

What's new in Aspose.Cells for .NET V7.7.2?

Support for opening password protected 2013 excel files.

What's new in Aspose.Cells for .NET V7.7.1?

Calculate Min and Max values in conditional formatting.

Read large MS Excel files in light cells mode.

Render Data Bars with negative values during sheet to image export.

Render transparent cells during sheet to image export.

Support for BitAnd functions.

What's new in Aspose.Cells for .NET V7.7.0?

Support for EnsureAllColumnsInOnePage option when rendering to PDF.

Support for double underline rendering images and PDF.

Detect file format and check if it is encrypted.

Unhide a column without giving columnwidth.

What's new in Aspose.Cells for .NET V7.6.1?

Set colors in Excel using ColorScale conditional formatting.

Fixed bug where password protected files raise FIPS validation error.

Fixed bug where Aspose.Cells locks template files and won't open with OOXML

What's new in Aspose.Cells for .NET V7.6.0?

Select a different paper source.

Add collection objects to Lambda/Linq.

PowerPoint file formats are now detected correctly.

Insert OLE linked documents.

What's new in Aspose.Cells for .NET V7.5.2?

Custom data sorting support.

What's new in Aspose.Cells for .NET V7.5.0?

Insert a picture based on a cell reference.

Shading Style Fill Effect for cells fixed.

Open CSV files that contain cell values longer than 32K.

What's new in Aspose.Cells for .NET V7.4.2?

Copy macros in XSLM files.

What's new in Aspose.Cells for .NET V7.3.3?

Copy Sparklines using Workbook.Copy().

Includes DataBar missing fields.

Read conditional formatting rules with cross-sheet formulas.

Cells.MinDataColumn and Cells.MinDataRow properties.

Cell background colors with conditional formatting.

Pivot Table data filters supported.

Advanced data validation.

Support reading and writing MHT files.

Support for XML maps.

What's new in Aspose.Cells for .NET V7.2?

Cells.ImportDataView only imports 65535 rows fixed

Could not update ComboBox in XLSM file fixed

What's new in Aspose.Cells for .NET V7.0?

Import formulae with values from an Excel file

Import Excel files from a stream without calculating all formulae

Export to XPS files

Create write-protected XLSX files

Load data asynchronously

Supports IE9 without using compatibility mode

Set background image for a cell's Button control

What's new in Aspose.Cells for .NET V5.3.2?

Supports Arabic text rendering in PDF conversion

Supports calculating array constants in formulas

Supports multiple non-sequential cell operations

Supports calculating array constants in formulas

Supports MS Excel 2010 encryption

Disable/hide printing

Process dialog box

Supports changing paper source while printing

Supports setting grouped row state to 'Expanded' or 'Collapsed' on the client side

What's new in Aspose.Cells for .NET V5.3?

Chart-to-Image feature has been enhanced

Excel-to-PDF feature has been enhanced

R/W ODS files feature has been enhanced

Auto-fit rows feature has been enhanced

All features of the control now work in in FireFox.

Provides support for converting a list collection to a DataTable object.

Supports SMALL function/formula.

Imports auto-filters in Excel files.

The performance of client scripts for IE is enhanced.

Supports whether to extend maximum row/column automatically when calculating formulas.

What's new in Aspose.Cells for .NET V5.2?

Supports signing and validating Digital Signatures in XLSX files.

Supports reading and writing Pivot Tables in XLS and XLSX files.

Calculates Pivot Table data in cells

What's new in Aspose.Cells for .NET V5.1.2?

Now supports setting visibilility of context menu items

Provides support for text rotation (90 and -90 degrees)

Supports firing CellDataChanged event when a formula is evaluated

What's new in Aspose.Cells for .NET V5.1?

Includes Smart Tags support for XLSX files.

Converts Sparklines to images.

Provides support for image Smart Markers.

Supports Cell’s gradient fills and theme of XLS file.

Renders Cell’s pattern fills in the generated PDF file.

Adds support for Pdf/A-1b compliance.

Improves performance and quality of the generated PDF files.

46 enhancement and fixes.

What's new in Aspose.Cells for .NET V5.0?

Now includes MS Excel 2007 XLSB file format support

Provides Copy and Paste Special feature

Supports sorting smart markers

37 enhancement and fixes

What's new in Aspose.Cells for .NET V4.8.2?

What's changed in Aspose.Cells:

Set IDataReader as a date source of Smart Markers

R/W ListObject (Table) of MS Excel2007 Xlsx files

Update data from external referenced links

Copy Data Validation in copying rows operation

The Formula Calculation Engine is enhanced

Copy ListObject (Table) in copying worksheet or workbook

Export richly formatted text to the html string value

65 fixes and other enhancements

What’s changed in Aspose.Cells.GridWeb:

Add ADDRESS, ROW, ROWS, COLUMN, COLUMNS, OFFSET and INDIRECT functions

Include hyperlink click event of binding column at client side

Support CustomCommandButton click event and double click row event at client side

3 fixes and other enhancements

What's new in Aspose.Cells for .NET V4.8.1?

What's changed in Aspose.Cells:

External workbook references from Excel 2007 xlsx file are supported.

Supports Summary Below Data for Subtotals.

Allows more than 3 data sorter keys.

Provides support for Excel 2007 Themes and Colors.

Formula Calculation Engine is enhanced.

Includes Area3D chart in the supported chart list for Chart -to- Image feature.

Named Range comments can be accessed.

Sets picture as a background fill format of the chart.

What's changed in Aspose.Cells.GridWeb:

Provides support for importing or exporting xlsx files.

Adds some valuable overloaded methods: AutoFitColumns, AutoFitColumn, AutoFitRows, AutoFitRow.

Formula Calculation Engine is enhanced.

Supports MEDIAN, ISERR and ISNUMBER formulas/functions.

Memory usage for styles is optimized.

Calculation dependence tree for formulas in Ajax mode is supported.

Handles events at client side before submitting.

All operators, behaviors and operations work in Ajax mode.

Supports setting style to a specified range of cells.

What's changed in Aspose.Cells.GridDesktop:

Implements match mode in custom row filter.

Formula Calculation Engine is enhanced.

Supports MEDIAN, ISERR and ISNUMBER formulas/functions.

Allows maximum 1048576 rows and 1024 columns.

Provides support to sum up selected cells' values.

Blanks, NonBlanks and AutoRowFilter options are included in auto-filters.

Memory usage is optimized.

Includes Find/Replace feature.

Enhances Undo/Redo feature for the change in the operations: apply styles, insertion/deletion and resizing rows/columns.

Provides support to customize behaviors when validation is failed.

Supports copying/pasting when hosted within IE.

What's new in Aspose.Cells for .NET V4.8?

Merged Aspose.Grid suite into Aspose.Cells

Optimized the performance of Formula recalculations

Improved the performance of inserting/deleting Rows/Columns

Enhanced the performance of Auto-fit Rows/Columns feature

Added WordArt shapes to XLS file

You can now read gradient fill effects for the charts

Now create spreadsheets with First Page or Even/Odd Header/Footer attributes for Page Setup

Support for multiple Print Areas in Worksheet-to-Image feature added

Added Formula Calculation support for some new MS Excel built-in functions

You can now set the background image for a Chart type Worksheet

Now provides support for setting Image Options in Chart-to-Image and Worksheet-to-Image features

101 fixes and other enhancements

What's new in Aspose.Cells for .NET V4.7.1?

Direct exporting of Excel files to PDF streams

Now can apply Subtotals to worksheet tables

Improved performance of encrypting and decrypting Excel 2007 files

55 fixes and enhancements

What's New Aspose.Cells for .Net V4.6x?

Supports to export PivotTable to Excel 2007 file.

Supports to add pivot calculated item to pivot table in 97-2003 xls file.

Supports Page setup Header(s) and Footer(s) in Worksheet2Image.

Supports to R/W xltm , xlmx file.

What's New Aspose.Cells for .Net V4.5x?

Convert Worksheets to images

Support to convert Excel files to HTML file format

Support to sort the data from left to right

What's New Aspose.Cells for .Net V4.4x?

Now allows to delete defined names from template files

Support to create an encrypted Excel file from scratch

Now can write formula calculation results back to a file

Chart2image conversion enhancement

Xls2pdf feature enhancement

Support to set vertical text in text box

Create and manage Excel Spreadsheets without requiring Microsoft Excel.

Aspose.Cells for .NET Upgrade Policy

Several Aspose.Cells for .NET upgrade paths are available:

Upgrade from a lower pricing plan to a higher pricing plan of Aspose.Cells for .NET

For instance, you purchased a Aspose.Cells for .NET Developer Enterprise Subscription and now you need to buy Aspose.Cells for .NET Developer OEM Subscription, you might qualify for a discount on your Aspose.Cells for .NET Developer OEM Subscription License.

Upgrade from Aspose.Cells for .NET to Aspose.Total for .NET

If you have purchased a Aspose.Cells for .NET License and now you need to buy Aspose.Total License, you might be able to obtain a discount on your Aspose.Total License purchase.

Aspose.Cells for .NET Competitive Upgrade

If you are currently using a component that directly competes with Aspose.Cells for .NET, you might qualify to buy Aspose.Cells for .NET at a discounted price.

Upgrade to Aspose.Cells for .NET from Aspose.Grid.Desktop

Please, note that Aspose.Grid.Desktop has been renamed and become a part of Aspose.Cells for .NET now, if you need to upgrade your existing Aspose.Grid.Desktop License to an Aspose.Cells for .NET Subscription License, please contact us for pricing and availability.

If you need to buy another Aspose product

You might qualify for a discount if you bought another Aspose product recently and need to buy Aspose.Cells for .NET now. (I.e. You bought Aspose.Words Developer Enterprise Subscription and now need to buy Aspose.Cells Developer Subscription).

Please note that upgrading your Aspose.Cells for .NET license will not change the expiration date of your subscription.

Should you require any assistance feel free to contact us for pricing and availability.

Aspose.Cells for .NET Renewal Policy

Renewals for Aspose.Cells for .NET Subscription are available. With your Aspose.Cells for .NET Subscription Renewal, you will receive 1 Year of updates and hot fixes for your Aspose.Cells for .NET subscription.

Aspose.Cells for .NET Subscription has two types of Renewals, Pre Expiry and Post Expiry:

Aspose.Cells for .NET Pre Expiry Subscription Renewals: If you renew your Aspose.Cells for .NET Subscription before your subscription expiry date. The cost is approximately 50% of the current product full price.

Aspose.Cells for .NET Post Expiry Subscription Renewals: If you renew your Aspose.Cells for .NET Subscription after the subscription expiry date. The cost will be approximately 60% of the current full price.

Feel free to contact us if you have any questions about renewing your Aspose.Cells for .NET Subscription License.

Pricing: Aspose.Cells for .NET V8.2.2 1 Developer with Deployment to 1 Physical Location - Small Business Subscription License - Includes Maintenance and Support (1 Year) , Aspose.Cells for .NET V8.2.2 1 Developer with Deployment to Unlimited Physical Locations - OEM Subscription License - Includes Maintenance and Support (1 Year), Aspose.Cells for .NET V8.2.2 Site Small Business Subscription License - up to 10 Developer with Deployment and up to 10 Physical Locations - Includes Maintenance and Support (1 Year), Aspose.Cells for .NET V8.2.2 Site OEM Subscription License - up to 10 Developer with Deployment to Unlimited Physical Locations - Includes Maintenance and Support (1 Year), Aspose.Cells for .NET V8.2.2 - Subscription Renewals Pre Expiry 1 Developer Small Business Subscription Renewal - Includes Maintenance (1 year), Aspose.Cells for .NET V8.2.2 - Subscription Renewals Pre Expiry 1 Developer OEM Subscription Renewal - Includes Maintenance (1 year), Aspose.Cells for .NET V8.2.2 - Subscription Renewals Pre Expiry 1 Site Small Business Subscription Renewal - Includes Maintenance (1 year), Aspose.Cells for .NET V8.2.2 - Subscription Renewals Pre Expiry 1 Site OEM Subscription Renewal - Includes Maintenance (1 year), Aspose.Cells for .NET V8.2.2 - Subscription Renewals Post Expiry 1 Developer Small Business Subscription Renewal - Includes Maintenance (1 year), Aspose.Cells for .NET V8.2.2 - Subscription Renewals Post Expiry 1 Developer OEM Subscription Renewal - Includes Maintenance (1 year), Aspose.Cells for .NET V8.2.2 - Subscription Renewals Post Expiry 1 Site Small Business Subscription Renewal - Includes Maintenance (1 year), Aspose.Cells for .NET V8.2.2 - Subscription Renewals Post Expiry 1 Site OEM Subscription Renewal - Includes Maintenance (1 year), Aspose Priority Support Developer Small Business 1 Year Priority Support License, Aspose Priority Support Developer OEM 1 Year Priority Support License, Aspose Enterprise Support Site Small Business 1 Year Enterprise Support License, Aspose Enterprise Support Site OEM 1 Year Enterprise Support License

Evals & Downloads: Read the Aspose.Cells help file, Read the Aspose License Agreement - Requires Acrobat Reader, Download the Aspose.Cells V8.2.2 evaluation on to your computer - Output Displays Evaluation Label

Operating System for Deployment: Windows 8.1, Windows 8, Windows 7, Windows Vista, Windows XP, Windows 2000

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: ASP.NET WebForms, .NET WinForms

Compatible Containers: Microsoft Visual Studio 2013, Microsoft Visual Studio 2012, Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Basic 2013, Microsoft Visual Basic 2012, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual C++ 2013, Microsoft Visual C++ 2012, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C# 2013, Microsoft Visual C# 2012, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Office 2013, Microsoft Office 2010, Microsoft Office 2007, Microsoft Office 2003, Microsoft Office XP, Microsoft Office 2000, Microsoft Office 97, .NET Framework 4.5.1, .NET Framework 4.5, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0, .NET Framework 1.1

Keywords: aspose.cells for net, aspose.cells net, aspose.cells, aspose cell, aspose cells for net , aspose cells net, aspose.cell for net, aspose.cell net, aspose cell for net, aspose cell net, aspose excel, aspose.cells documentation, aspose.cells distributor, aspose.cell distributor, aspose.cells reseller, aspose.cell reseller, aspose.cells site license, aspose.cell site license, aspose.cells developer license, aspose.cells oem license, aspose.cells renewal, aspose.cell renewal, aspose.cells subscription, aspose.cells upgrade, aspose.cells for net distributor, aspose cells net distributor, aspose.cells for net reseller, aspose cells net reseller, aspose.cells for net developer, aspose cells net developer, aspose.cells for net license, aspose cells net license, aspose.cells for net site, aspose cells net site, aspose.cells for net subscription, aspose cells net subscription, aspose.cells for net oem, aspose cells net oem, aspose.cells for net renewal, aspose.cells for net upgrade

Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl

Part numbers: PC-516645-749811 516645-749811 PC-516645-749814 516645-749814 PC-516645-749817 516645-749817 PC-516645-749820 516645-749820 PC-516645-749799 516645-749799 PC-516645-749802 516645-749802 PC-516645-749805 516645-749805 PC-516645-749808 516645-749808 PC-516645-749823 516645-749823 PC-516645-749826 516645-749826 PC-516645-749829 516645-749829 PC-516645-749832 516645-749832 PC-516645-749835 516645-749835 PC-516645-749837 516645-749837 PC-516645-749839 516645-749839 PC-516645-749841 516645-749841

Mfr. Part No: APDNCEDE APDNCEDO APDNCESE APDNCESO

Búsqueda de productos

Escriba palabras de búsqueda:

La Tienda de Software para Profesionales de IT‎

Como distribuidores oficiales, ComponentSource ofrece cómodas compras centralizadas de más de 250 editores de software especializados en desarrollo de aplicaciones y operaciones.

Más Información | Sobre Nosotros

Galería de capturas de pantalla

Haga clic para obtener una vista previa completa

Captura de pantalla Aspose.Cells - .NET - V8.2.2 Captura de pantalla Aspose.Cells - .NET - V8.2.2 Captura de pantalla Aspose.Cells - .NET - V8.2.2 Captura de pantalla Aspose.Cells - .NET - V8.2.2
Award Award Award