Aspose.Cells for PHP via Java is a scalable and feature‑rich Excel spreadsheet management and processing API that enables developers to work with spreadsheets inside PHP applications through the JavaBridge. It supports Excel file format conversion, chart creation and rendering, formula implementation, and granular worksheet styling. The API works without Microsoft Excel, allowing applications to manipulate, create, edit, convert, and render Excel files programmatically across a wide variety of spreadsheet, text, web, image, and fixed‑layout formats. Supported input formats include XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML, OTS, ODS, CSV, TSV, JSON, HTML, MHTML, Numbers, SXC, FODS, and EPUB. Output‑only formats include PDF, PDF/A, XPS, image formats (JPEG, PNG, BMP, SVG, TIFF, EMF, GIF), SQL, MARKDOWN, and XHTML. The API offers sophisticated spreadsheet manipulation, including support for Smart Markers, Pivot Tables, charts, conditional formatting, page setup, worksheet protection, data visibility control, and advanced formula calculation. With a dedicated rendering engine, Aspose.Cells for PHP via Java delivers high‑fidelity exports to PDF, images, and other fixed‑layout formats. Its flexible formatting system allows extensive visual styling, including fonts, colors, patterns, borders, and rich text formatting inside cells. The library is optimized for high performance and reliability, making it an excellent choice for enterprise PHP applications requiring robust spreadsheet processing.

Features

• CSV, Tab‑Delimited & HTML Support: Import and export CSV, tab‑delimited, and HTML files.
• ODS Format Support: Load and save OpenDocument Spreadsheet (ODS) files.
• Chart Management: Create, manipulate, and render charts.
• Formula Import: Import formulas from designer spreadsheets.
• Page Setup Configuration: Define page orientation, margins, scaling, and layout.
• Comments: Create and manipulate worksheet comments.
• Auto‑Filters & Page Breaks: Set and manage filters and page breaks.
• Complex Formulas: Set and calculate complex formulas through the API.
• Conditional Formatting: Create and manipulate conditional formatting rules.
• Security & Protection: Apply workbook, worksheet, and cell‑level protection.
• Named Ranges: Create and manipulate named ranges.
• Smart Markers: Populate worksheets with Smart Markers for reporting.
• Pivot Tables: Create, manipulate, and refresh Pivot Tables.
• SVG Export: Export worksheets to SVG format.
• Sparklines: Create and render sparklines.
• Excel Conversion: Convert Excel files to XPS, PDF, and HTML formats.
• Rendering Engine: Render spreadsheets, worksheets, and charts to PDF and images with high fidelity.
• Worksheet Display Control: Manage page breaks, orientation, scaling, paper size, headers, footers, and zoom level.
• Data Visibility: Control freeze panes and print areas for optimized viewing/printing.
• Formula Engine: Calculate built‑in, add‑in, array, and R1C1 formulas accurately.
• Formatting System: Apply cell styling, number formatting, rich text, and graphical objects.
• Chart & Graphics Handling: Create and manipulate all standard and custom chart types and insert drawing objects.

Benefits

• Excel‑Like Processing in PHP: Perform all major Excel tasks without Microsoft Excel installation.
• Comprehensive Format Compatibility: Supports a wide array of spreadsheet, web, text, and image formats.
• High‑Fidelity Rendering: Export spreadsheets and charts to PDF and images with excellent accuracy.
• Enterprise Scalability: Designed for large‑scale, high‑performance spreadsheet processing.
• Powerful Formula Engine: Accurately handles complex Excel formulas and functions.
• Advanced Reporting Features: Smart Markers, Pivot Tables, and charts enable automated reporting.
• Granular Control: Manage worksheet display, formatting, protection, and data visibility in detail.
• Enhanced Visual Output: Create spreadsheets with professional‑grade formatting, charts, and graphics.