Simple Ways to Manage Your Excel Worksheet Data Within .NET Applications
.NET Excel API | Process Spreadsheet Formats via .NET Core
Advanced Excel Spreadsheet API FeaturesSend output to a client browserImport/export data to & from DataTable, DataView or ArrayAdd & manipulate charts & PivotTable through the product APIImport formulas from a designer spreadsheetTruncate long sheet name & replace invalid characters at run-timeApply text alignment to partial text inside the TextBoxPaste rows & columns with advanced paste optionsSupport for CSV (comma-separated values) & TSV (tab-separated values)Create & manipulate commentsSet auto-filters & page breaksSpecify conditional formatting rulesCreate & manipulate named rangesCreate & render sparklinesExport worksheets to SVG formatRead & write large spreadsheets in light-weight modeRe-sample images in Excel-to-PDF conversionModify VBA code or Macros in the template filePopulate spreadsheets via Smart MarkersConvert Spreadsheets to PDF, XPS & HTML FormatsAspose.Cells for .NET is capable of converting spreadsheets to PDF, XPS & HTML formats while maintaining the highest visual fidelity. The conversion process is simple yet reliable, thus making API a perfect choice for the organizations which require to exchange documents in any of the industry-standard formats.Save spreadsheet in different formats - C#// load file to be converted

var workbook = new Aspose.Cells.Workbook(dir + "template.xlsx");



// save in different formats

workbook.Save(dir + "output.pdf", Aspose.Cells.SaveFormat.Pdf);

workbook.Save(dir + "output.xps", Aspose.Cells.SaveFormat.XPS);

workbook.Save(dir + "output.html", Aspose.Cells.SaveFormat.Html);Visualize Data with Formatting, Charts & GraphicsAspose.Cells for .NET gives you complete freedom and flexibility to furnish your spreadsheets with all kinds of visual effects. The API allows you to apply different fonts with attributes, cell styles (alignment, indentation, rotation, borders, shading and coloring, protection, text wrapping and shrinking) and all types of number formats.Similarly, charts and graphics are visually appealing and can give your spreadsheet a professional look. Aspose.Cells for .NET provides a comprehensive set of APIs for creating and manipulating all of the standard and custom chart types. Moreover, you may add different types of drawing objects, such as comments, pictures, OLE objects, shapes and controls to the cellsEfficient, Robust & Reliable Formula Calculation EngineAspose.Cells for .NET has a powerful Formula Calculation Engine that supports almost all of the standard and advanced Microsoft Excel formulas and functions. You can read, set and calculate the results of the built-in, add-in, array & R1C1 reference style formulas.Summarize Data with Pivot Tables, Charts & Smart MarkersA Pivot Table can help you quickly summarize the flat data and to get the desired information according to your needs. .NET Excel library allows you to dynamically create Pivot Tables and Pivot Charts. You can dynamically change the source data of a Pivot Table and refresh it. Moreover, library offers Smart Markers which is a great feature to populate worksheets based on some data sources and to create visually effective reports.Render Excel Worksheets & Charts as ImagesAspose.Cells for .NET has its own rendering engine specially designed for rendering & printing with highest of fidelity to the Microsoft Excel. It offers distinctive features such as rendering Excel worksheets & charts to images & printing worksheets to any connected physical printer. The process is flexible thus allowing you to choose a number of options, such as controlling the resultant image dimensions when rendering worksheets & charts to images.Convert worksheet to image - C#// load spreadsheet file

var workbook = new Aspose.Cells.Workbook(dir + "template.xls");

// access the first worksheet from the collection

var worksheet = workbook.Worksheets[0];

// define parameters for resultant image

var options = new Aspose.Cells.Rendering.ImageOrPrintOptions()

{

    OnePagePerSheet = true,

    ImageType = Aspose.Cells.Drawing.ImageType.Jpeg

};

// convert worksheet to image in JPEG format

var renderer = new Aspose.Cells.Rendering.SheetRender(worksheet, options);

renderer.ToImage(0, dir + "output.jpeg");Chart Creation & ManipulationAspose.Cells for .NET comes with complete support for charting. You can easily add standard or customized charts using the product API and dynamically set the data in order to refresh the charts. API also allows you to convert charts to a number of image formats.Graphical Interfaces for Web & Desktop ApplicationsAspose.Cells for .NET provides GUI controls for web & desktop applications. End-user can use these controls to open, save & edit Excel files, import & export data, manage formatting & formulas and convert between several supported spreadsheet formats, right from your application's front-end.Microsoft Office Automation – Not NeededAspose.Cells for .NET is built using managed code that never needs Microsoft Office or Microsoft Excel to be installed on the machine to work with Excel document formats. It is a perfect Microsoft Office automation alternative in terms of supported features, security, stability, scalability, speed and price.