Spire.XLS for .NET Program Guide Content

Spire.XLS is a professional Excel .NET API that can be used to create, read, write, convert and print Excel files in any type of .NET ( C#, VB.NET, ASP.NET, .NET Core, .NET 5.0, .NET 6.0, MonoAndroid and Xamarin.iOS) application. Spire.XLS for .NET offers object model Excel API for speeding up Excel programming in .NET platform - create new Excel documents from template, edit existing Excel documents and convert Excel files.

This Professional .NET Excel API is a standalone Excel .NET managed assembly and does not depend on Microsoft Office Excel. Spire.XLS for .NET offers support both for the old Excel 97-2003 format (.xls) and for the new Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format. It features fast and reliably compared with developing your own spreadsheet manipulation solution or using Microsoft Automation.

Request free customized demo just for you.

Conversion C#/VB.NET: Convert Excel to PDF C#/VB.NET: Convert Excel to HTML Export Excel to XML and Import XML to Excel C#/VB.NET: Convert Excel to Images Convert Specific Worksheet Cells to Image C#/VB.NET: Convert Excel to CSV and CSV to Excel C#/VB.NET: Convert CSV to DataTable Convert Excel to Text in C#, VB.NET C#/VB.NET: Convert XLS to XLSX and Vice versa Embed image in HTML when converting Excel to HTML in C# C#/VB.NET: Convert Excel to XPS Convert XLS to XLSM and Maintain Macro in C#, VB.NET Convert Selected Range of Cells to PDF in C#, VB.NET Convert Excel worksheet to EMF image in C# Show formula and its result separately when converting Convert Excel to OpenDocument Spreadsheet (.ods) format C#/VB.NET: Convert Excel to SVG C#/VB.NET: Convert CSV to PDF Convert Excel Sheet to a High-Resolution Image in C#, VB.NET C#/VB.NET: Convert Charts in Excel to Images Save Excel chart sheet to SVG in C# Convert HTML to Excel in C#/VB.NET Convert Shapes and SmartArt in Excel to Image in C#, VB.NET C#/VB.NET: Convert Excel Data to Word Tables with Formatting	Data Import/Export Import Data from Excel to Datatable Export Datatable to Excel from Database
Security C#/VB.NET: Protect or Unprotect Excel Documents C#/VB.NET: Lock Specific Cells in Excel Detect if an Excel Workbook is Password Protected Remove or Reset Password of Encrypted Workbook Hide Formulas When Protecting a Worksheet in C# C#/VB.NET: Add or Delete Digital Signature in Excel	Document Operation Save Excel Document with C#, VB.NET Load/Save Excel VBA in C#, VB.NET Create Excel File in C#, VB.NET C#/VB.NET: Merge Excel Files into One C#/VB.NET: Add Document Properties in Excel Dynamically create/save excel file to stream in .NET Get information of pagination in Excel document Set Excel View Mode in C#, VB.NET Insert HTML-Formatted RichText into Excel Cell in C# Set Excel page margins before printing a worksheet in C# Merge several Excel worksheets into a single Excel worksheet Split One Excel Worksheet to Several Excel Documents by a Custom Range of Rows Get Excel Properties and Custom Properties in C# Add Custom Properties to Excel Document in C#, VB.NET Determine if an Excel File Contains VBA Macros in C#, VB.NET C#/VB.NET hide and unhide window for Excel Workbook C#/VB.NET: Split Excel Sheets into Separate Files C#/VB.NET: Accept or Reject Tracked Changes in Excel
Worksheet C#/VB.NET: Copy Worksheets in Excel C#/VB.NET: Rename Excel Sheets and Set Tab Colors C#/VB.NET: Add Worksheets to Excel Move Worksheet in C#, VB.NET Get the page count of excel file in C# C#/VB.NET: Hide or Show Worksheets in Excel Only convert visible or hidden worksheet to image in C# C#/VB.NET: Hide or Show Gridlines in Excel Set the Zoom Factor on Excel worksheet in C# Remove worksheet in C# Remove page breaks in a worksheet Split Excel Worksheet into Multiple Panes in C# Get a list of the worksheet names in an Excel workbook C#/VB.NET: Insert Page Breaks in Excel C# Activate a Worksheet Apply a Style to an Entire Excel Worksheet in C# Remove Duplicate Rows in Excel in C#, VB.NET C#/VB.NET: Copy Cell Ranges Between Different Workbooks C#/VB.NET: Rearrange Columns in Excel	Chart C#/VB.NET: Create a Pie Chart in Excel C#/VB.NET: Create a Column Chart in Excel Generate Excel Charts in C#, VB.NET C#/VB.NET: Create Bar Chart in Excel C#/VB.NET: Create a Line Chart in Excel Create Excel Radar Chart in C#, VB.NET Resize and Move Excel Charts in C#, VB.NET Save Excel Charts as Images in C#, VB.NET Insert Sparkline in Excel in C#, VB.NET Fill Chart Elements with Pictures in C#, VB.NET Add a trendline in a chart Create a Combination Chart in Excel in C#, VB.NET Create Excel Scatter Chart in C# Add a picture to the chart and assign a hyperlink to the picture Add error bars to a chart in C# Add a data table to the chart in C# Set the background color for Excel Chart in C# Set and format data labels for Excel charts in C# Format axis for Excel chart in C# Create Gauge Chart in Excel in C# Set customized data marker for charts in C# Set the Background Color of Legend in an Excel Chart Show the leader line on Excel chart in C# Hide Gridlines in Excel Chart in C#, VB.NET Adjust the Spaces between Bars in Excel Chart in C#, VB.NET Set the border color and styles for Excel Chart Explode a pie chart sections in C# Set the font for legend and datalable in Excel Chart Custom data labels using values from cells in C# Use Discontinuous Data Range to Create Chart in Excel Add Oval shape to Excel Chart in C# Change the color of data series in an Excel chart Add Data Callout Labels to Charts in Excel in C# Extract the trendline equation from an Excel chart Set font for the text on Chart title and Chart Axis in C# Create a Doughnut Chart in Excel in C# Remove chart from Excel worksheet in C#, VB.NET How to explode a doughnut chart in C# How to set the rotation for the 3D chart on Excel in C# Create Multi-Level Category Chart in Excel in C#, VB.NET Delete Legend and Specific Legend Entries from Excel Chart in C# Apply Soft Edges effect to Excel Chart in C# Create Chart without Using Worksheet Data Range in C# Create Pivot Chart in Excel in C# Create Bubble Chart in Excel in C#/VB.NET
Cells C#/VB.NET: Set Background Color and Pattern for Excel Cells C#/VB.NET: Add or Remove Cell Borders in Excel Insert Interior in Excel with C#, VB.NET Set Excel Background Color in C#, VB.NET C#/VB.NET: Merge or Unmerge Cells in Excel Insert Excel Row or Rows in C#, VB.NET C#/VB.NET: Freeze Rows and Columns in Excel C#/VB.NET: Create a Drop-Down List in Excel C#/VB.NET Hide or Show Rows and Columns in Excel C#/VB.NET: Delete Rows and Columns from Excel Unfreeze Excel Panes with C#, VB.NET Copy Formatting from One Cell or Range to Another Set Excel Row Height and Column Width in C#, VB.NET Set Number Format in Excel using Spire.XLS in C#, VB.NET Duplicate a Row in Excel in C#, VB.NET C#/VB.NET: AutoFit Column Width and Row Height in Excel Detect merged cells in a worksheet Get the intersection of two ranges in Excel Hide the content on Cell by setting the number format Remove the value and format from Excel Cell range Hide or Show Row Column Headers in Excel with C# C#/VB.NET: Delete Blank Rows and Columns in Excel Read Rich Text from an Excel Cell in C#, VB.NET Shrink Text to Fit in a Cell in Excel in C# Get Cell Type in Excel in C#	Data C#/VB.NET: Apply Fonts to Excel Cells C#/VB.NET: Group or Ungroup Rows and Columns in Excel Edit Excel Data in C#, VB.NET C#/VB.NET: Wrap or Unwrap Text in Excel Cells C#/VB.NET: Sort Data in Excel Find and Replace Data in Excel C#/VB.NET: Find and Highlight Data in Excel Align Excel Text in C# Unhide the Excel Row and Column in C# Update excel data via GridViewTable Add table with filter in Excel Remove auto filters in Excel Formatting text in Excel in C# Retrieve data from one excel worksheet and extract to a new excel file in C# Clone Excel Font Style in C# Split Excel Data into Multiple Columns in C#, VB.NET C#/VB.NET: Apply or Remove Data Validation in Excel Apply Subscript and Superscript in Excel file Expand and Collapse Groups in Excel with C# Create Nested Group in Excel in C#, VB.NET Add a Total Row to Table in Excel in C# Add Autofilter to Excel in C#, VB.NET Filter cells by cell color in Excel in C# C#/VB.NET: Write Data to Excel Worksheets
Image C#/VB.NET: Insert Images into Excel Insert Excel Background Image in C#, VB.NET Set the offset of image when the fill way of chart is picture fill Align a Picture within a Cell in C#, VB.NET Extract Image from Excel Worksheet in C#, VB.NET Reset the size and position for the image on Excel worksheet Delete Images from Excel Worksheet in C# C#/VB.NET: Replace a Picture in Excel	Link C#/VB.NET: Add Hyperlinks to Excel Remove Excel Hyperlinks in C#, VB.NET Add Excel Hyperlinks in C#, VB.NET (Links to a File) Modify Hyperlinks in Excel in C#, VB.NET Retrieve Hyperlinks from an Excel Sheet in C#, VB.NET
Comment C#/VB.NET: Add or Format Comments in Excel C#/VB.NET: Edit or Delete Comments in Excel Add Comment with Author in Excel Set position and alignment for Excel comments in C# Set Picture Fill for Excel Comment in C#, VB.NET Hide or Show Excel Comments in C#	Formula Add Excel Formulas in C#, VB.NET C#/VB.NET: Read Excel Formulas Calculate Formulas in XLS Document in C# Create and Apply Excel Named Range in C# Remove Formulas from Cells but Keep Values in Excel in C#
Header and Footer C#/VB.NET: Add Headers and Footers to Excel Change the font and size for Excel header and footer in C# C#/VB.NET: Add a Watermark to Excel Set Different Header or Footer for Odd and Even Pages in Excel Add different header & footer for the first page	Print C#/VB.NET: Print Excel Documents
Objects Insert OLE Object in Excel in C#, VB.NET Insert Controls to Worksheet in C#, VB.NET Adding Picture to Excel Textbox in C#, VB.NET Insert Textbox with Contents in Excel in C#, VB.NET Remove borderline of textbox in Excel chart in C#, VB.NET Set the font and background for TextBox in Excel Chart Extract Text from a Textbox on Excel worksheet in C# Insert Shapes to Excel Worksheet in C# Set the shadow style for the shape on Excel worksheet in C# Extract text and image from Excel shape in C# Delete shapes in an Excel Worksheet in C# Hide or Unhide Shape in Excel in C# Set the internal margin of excel textbox in C# Add arrow line to Excel worksheet in C# C#/VB.NET Add lines to Excel worksheets through two points C#/VB.NET: Group or Ungroup Shapes in Excel	Conditional Formatting Set the traffic lights icons in C# by Spire.XLS Format cells with borders in conditional formatting Apply Conditional Formatting to a Data Range in C# C#/VB.NET: Alternate Row Colors in Excel Using Conditional Formatting Create a formula to apply conditional formatting in Excel in C# Remove conditional format from Excel in C# Conditionally Format Dates in Excel with C# Highlight Duplicate and Unique Values in Excel Using C# Highlight Top and Bottom Ranked Values in Excel Using C# C#/VB.NET: Highlight Values Above or Below Average in Excel C#/VB.NET: Add Data Bars in Excel
Pivot Table Add report filter to Excel Pivot table in C# Set Data fields format on Excel PivotTable in C# Expand/Collapse the rows in an existing Pivot Table in C# C#/VB.NET: Create a Pivot Table in Excel Refresh PivotTable in Excel in C#	Smart Marker Marker Designer

Spire.XLS for .NET Program Guide Content

Conversion

Data Import/Export

Security

Document Operation

Worksheet

Chart

Cells

Data

Image

Link

Comment

Formula

Header and Footer

Print

Objects

Conditional Formatting

Pivot Table

Smart Marker