Spire.XLS for Swift
Powerful Excel Development Component for Swift
- Overview
- Features
Spire.XLS for Swift is a powerful Excel development component designed for Swift developers. It provides comprehensive functionality to create, read, write, and convert Excel files in Swift applications. With Spire.XLS for Swift, you can streamline Excel-related tasks effortlessly.
Whether you need to generate Excel documents from templates, modify existing files, or convert file formats, this professional Swift Excel API offers an intuitive object model for accelerated development.
Unlike other solutions, Spire.XLS for Swift is a standalone Swift assembly that doesn't rely on Microsoft Office Excel. It supports various formats, including the legacy Excel 97-2003 format (.xls) and newer formats like Excel 2007, 2010, 2013, 2016, and 2019 (.xlsx, .xlsb, .xlsm), along with Open Office (.ods) format.
Experience the swift performance and reliability of Spire.XLS for Swift, eliminating the need for custom spreadsheet solutions or Microsoft Automation. Unlock the power of Excel in your Swift applications with this comprehensive and trusted Swift Excel component.
-
Convert
-
Validate
-
Formula
-
Format
-
Chart
-
Pivot Table
-
Group
-
Merge
-
Highlight
Convert Excel to PDF
Whenever you need to share an important Excel report with a partner, it's best to convert the file to PDF to ensure it looks the same as it does on your device.
Apply Data Validation
Data validation in Excel controls what kind of data can be entered into a certain cell, which ensures that all data entries are accurate and consistent.
Insert Formulas and Functions
Formula is an expression that calculates values in a cell or in a range of cells, while function is a predefined formula already available in Excel. Both formulas and functions are very useful when you need to calculate numbers or solve math problems in Excel.
Apply Conditional Formatting
Conditional formatting is a helpful feature that allows applying special formats to cells meeting specific criteria. It is often used to emphasize or differentiate data stored in worksheets.
Create a Chart
Chart is a fantastic tool to visually group and analyze data. It provides the reader with the structure of the data set and displays the data in a graphical representation, making it easier for most users to see the data.
Create a Pivot Table
Pivot table is a kind of interactive table that allow users to quickly categorize, calculate, summarize and analyze large amounts of data in a concise tabular format.
Group Rows or Columns
For worksheets with large amounts of data, grouping rows or columns that contain similar information can make the worksheet more compact and understandable.
Merge Excel Files
Merging Excel files with associated content can help us work with worksheet data more easily and also make it easier to share and read the contents of our workbooks.
Find and Highlight
You can find all cells containing a specific value and highlight them with the same background color to make the value outstanding and more easily to be found out.
SWIFT
Standalone Swift API
100% independent Swift Excel class library which doesn't require Microsoft Office to be installed on system.
VERSION
- Excel 97-2003
- Excel 2007
- Excel 2010
- Excel 2013
- Excel 2016
- Excel 2019
- OpenOffice
OPERATION
Powerful Toolset, Multichannel Support
-
Manage Comments
-
Work with Pivot Table
-
Work with Excel Charts
-
Images and Shapes
-
Find Replace Highlight
-
Manage Hyperlinks
-
Header and Footer
-
Text and Image Watermark
-
Conditional Formatting
-
Excel Formula
-
Set Auto-filters
& Page Breaks -
Merge Split Cells
and files -
Protect, Encrypt, Decrypt
CONVERSION
Convert File Documents with High Quality
-
TEXT
-
XPS
-
SVG
-
PDF
-
XML
-
Image
XLsx,XLSM,XLSB,ODS
-
CSV
-
HTML
-
PNG
-
BMP
-
JPEG
-
EMF
-
TIFF
-
Chart
MAIN FUNCTION
100% Autonomous Swift API,
No Microsoft Office Automation
Efficient Excel File Conversion with Superior Quality
Spire.XLS for Swift provides powerful support for converting Excel files to various formats, including PDF, HTML, CSV, Text, Image, XML, SVG, UOS, OFD, PostScript, and XPS. Likewise, it seamlessly converts popular file formats to Excel.Create Excel Reports with a Comprehensive Workbook Designer
With Spire.XLS for Swift, developers can effortlessly generate Excel workbooks from scratch or load existing workbooks from folders or file streams. The API allows for convenient saving of workbooks to files, file streams, or web responses. Additionally, Spire.XLS for Swift offers advanced security features such as Excel encryption/decryption, digital signatures, change tracking, cell hiding/unhiding, and worksheet locking/unlocking.Flexible Worksheet Operations
Developers can easily perform operations on worksheets using Spire.XLS for Swift, including creation, addition, deletion, renaming, editing, and movement of worksheets. The API facilitates copying, transposing, and consolidating contents across multiple worksheets. Advanced options for customizing worksheet display, such as page breaks, zoom settings, freeze panes, and headers/footers, are also available.Effortless Cell Manipulation
and Excel Calculation Engine
Charts, Data, and Other Elements
Spire.XLS for Swift offers a wide array of chart types, including Pie Chart, Bar Chart, Column Chart, Line Chart, and Radar Chart, empowering developers to visualize data effectively. The API seamlessly facilitates data transportation between databases and Excel in Swift. Features such as hyperlinks and templates are also fully supported by Spire.XLS for Swift.GET STARTED
Free Trials for All Progress Solutions
Spire.XLS for Swift enables developers/programmers to build applications for Swift platforms. Full support for 64-bit system.
File Format Supports
Spire.XLS for Swift supports lots of file formats.- Spire.XLS for Swift 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.
- Save as HTML is available.
- Load and save documents in the tab delimited file format.
- Comprehensive support of the CSV format to interact with a variety of applications.
- Easily extract text by saving in plain text format.
Conversion
Spire.XLS for Swift has powerful conversion ability and it enables converting Excel files to most common and popular formats.- Excel to HTML/XML/CSV
- XML/CSV to Excel
- Excel to Image
- Excel to Text
- Excel to PDF
- Excel to XPS
- Excel to SVG
Contents Features
Spire.XLS for Swift offers a wide range of features and the main features are listed as below:- Create and Edit Excel
- Find and Replace Data
- Save Excel to file/Stream or as web response
- Create charts
- Read and write hyperlinks
- Create auto filters
- Implement Data Sorting
- Implement Data Validations
- Merge/Unmerge Cells and files
- Group/UnGroup Rows and Columns
- Insert/Delete or Hide Rows, Columns and Sheets
- Calculate Complex Excel Formula
- Freeze/Unfreeze Panes
- Insert Hyperlinks to link data
- Protect/Unprotect Worksheets
- Create Pivot Tables
- Encrypt/Decrypt Files
- Load/Save Excel VBA
- Merge data into Excel with MarkerDesigner
Formatting Features
Spire.XLS for Swift provides detailed programmatic access to formatting properties of all spreadsheet elements.- Apply all character formatting in the cells including fonts, colors, effects, fill and shading.
- Apply all the Number Format Settings (supported in MS Excel) for the cells.
- Set all types of Text Alignment settings.
- Apply different kinds of Font Settings for the cells.
- Apply different Colors to Cells, Fonts, Gridlines, Graphic objects etc.
- Apply different Rich Text formatting in a single cell.
- Apply different Border Settings on cells.
- Apply different Background Patterns on cells.
- Apply gradient Background Patterns on cells.
- Apply Format Settings on a Worksheet, Row, Column or a range of cells etc.
Page Setup Features
Spire.XLS for Swift enables developers/programmers to set PageSetup options.- Adjust your page orientation, scaling, paper size.
- Specify your margins and page centering.
- Create or edit your header and/or footer with image.
- Managing Page Breaks.
Feature Details
Support | Excel97~2003 | Excel2007 | Excel2010 | Excel2013 | Excel2016 | ||
Operation | Create New Workbook | Edit Existing Workbook | |||||
Save to file | Save to stream | Save as web response | |||||
Workbook Properties Setup | |||||||
Worksheet Copy | Cells Data Copy | Cells Styles Copy | Cells Merge | ||||
Lock Worksheet | Unlock Worksheet | ||||||
Data Table Import | Data Table Export | ||||||
Freezepane | Group | ||||||
Filter | Data Validation | ||||||
Marker Designer | Template | Auto Populate | Style Copy | Variables | |||
Format Cells | Number Format | Text Alignment | Font | ||||
Cell Border | Cell Fill | Cell Protection | Interior | ||||
Content | Formula (all 531 entries supported) | Chart (all 74 types supported) | |||||
Image | Pivot Table | RichText | |||||
Hyperlink | Comments | VBA | |||||
Convert | XML | Image | CSV | Text |