aspose/cells-sdk-php 问题修复 & 功能扩展

解决BUG、新增功能、兼容多环境部署,快速响应你的开发需求

邮箱:yvsm@zunyunkeji.com | QQ:316430983 | 微信:yvsm316

aspose/cells-sdk-php

Composer 安装命令:

composer require aspose/cells-sdk-php

包简介

Effortlessly handle Excel and other spreadsheet documents with features like opening, generating, editing, splitting, merging, comparing, and converting. Seamlessly integrate Cloud API into your solutions to efficiently manipulate documents. Convert Excel or other spreadsheets to CSV, PDF, JSON, XML

README 文档

README

Product Page Documentation API Ref Examples Blog Support Packagist PHP Version Support Packagist Downloads License PHP GitHub commits since latest release (by date)

Aspose.Cells Cloud SDK for PHP is a cloud-native REST API that enables PHP developers to create, read, edit, convert, and repair spreadsheet files—including Excel (XLS, XLSX, XLSB, XLSM), OpenDocument Spreadsheet (ODS), CSV, TSV, JSON, HTML, PDF, and more—without requiring Microsoft Excel or Office to be installed.

Built on the Aspose.Cells Cloud Web API, this MIT-licensed SDK supports advanced spreadsheet operations such as:

  • Cell formatting, formulas, and data validation
  • Pivot tables, charts, hyperlinks, and comments
  • Conditional formatting and smart markers
  • Worksheet merging, splitting, and protection
  • Batch processing and background removal

It seamlessly integrates with AWS, Microsoft Azure, and Google Cloud, ensuring high availability, scalability, and data integrity. Ideal for serverless apps, microservices, and cloud automation workflows.

Quick Start Guide

To begin with Aspose.Cells Cloud, here's what you need to do:

  1. Sign up for an account at Aspose for Cloud to obtain your application details.

  2. Install the Aspose.Cells Cloud PHP Package from Packagist.

    To install Aspose.Cells Cloud via Composer, follow these steps:

    • Add Aspose.Cells Cloud as a dependency to your composer.json file:
    {
      "require": {
        "aspose/cells-cloud": "^26.6.0"
      }
    }
    • Run Composer install Aspose.Cells Cloud SDK:
    composer install
    • Include Composer's autoloader in your PHP code:
    require 'vendor/autoload.php';
    • You're now ready to use Aspose.Cells Cloud in your PHP project.
  3. Use the conversion code provided below as a reference to add or modify your application.

Convert an Excel File Using PHP

<?php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Request\PutConvertWorkbookRequest;

#get CellsCloudClientId from https://dashboard.aspose.cloud/#/applications
#get CellsCloudClientSecret from https://dashboard.aspose.cloud/#/applications
$cellsApi = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"));
$response = $cellsApi->convertSpreadsheet(new \Aspose\Cells\Cloud\Request\ConvertSpreadsheetRequest( 'examples\EmployeeSalesSummary.xlsx', 'pdf'),"EmployeeSalesSummary.pdf");

Support file format

Format Description Load Save
XLS Excel 95/5.0 - 2003 Workbook.
XLSX Office Open XML SpreadsheetML Workbook or template file, with or without macros.
XLSB Excel Binary Workbook.
XLSM Excel Macro-Enabled Workbook.
XLT Excel 97 - Excel 2003 Template.
XLTX Excel Template.
XLTM Excel Macro-Enabled Template.
XLAM An Excel Macro-Enabled Add-In file that's used to add new functions to Excel.  
CSV CSV (Comma Separated Value) file.
TSV TSV (Tab-separated values) file.
TXT Delimited plain text file.
HTML HTML format.
MHTML MHTML file.
ODS ODS (OpenDocument Spreadsheet).
Numbers The document is created by Apple's "Numbers" application which forms part of Apple's iWork office suite, a set of applications which run on the Mac OS X and iOS operating systems.
JSON JavaScript Object Notation
DIF Data Interchange Format.  
PDF Adobe Portable Document Format.  
XPS XML Paper Specification Format.  
SVG Scalable Vector Graphics Format.  
TIFF Tagged Image File Format  
PNG Portable Network Graphics Format  
BMP Bitmap Image Format  
EMF Enhanced metafile Format  
JPEG JPEG is a type of image format that is saved using the method of lossy compression.  
GIF Graphical Interchange Format  
MARKDOWN Represents a markdown document.  
SXC An XML based format used by OpenOffice and StarOffice
FODS This is an Open Document format stored as flat XML.
DOCX A well-known format for Microsoft Word documents that is a combination of XML and binary files.
PPTX The PPTX format is based on the Microsoft PowerPoint open XML presentation file format.
OTS OTS (OpenDocument Spreadsheet).
XML XML file.
HTM HTM file.
TIF Tagged Image File Format  
WMF WMF Image Format  
PCL Printer Command Language Format  
AZW3 AZ3/KF8 File Format  
EPUB EPUB File Format  
DBF DBF File Format  
EPUB database file  
XHTML XHTML File Format  

Architecture

architecture.png

Developer Reference

Manipulate Excel and other spreadsheet files in the Cloud

  • File Manipulation: Users can upload, download, delete, and manage Excel files stored in the cloud.
  • Formatting: Supports formatting of cells, fonts, colors, and alignment modes in Excel files to cater to users' specific requirements.
  • Data Processing: Powerful functions for data processing including reading, writing, modifying cell data, performing formula calculations, and formatting data.
  • Formula Calculation: Built-in formula engine handles complex formula calculations in Excel and returns accurate results.
  • Chart Manipulation: Users can create, edit, and delete charts from Excel files for data analysis and visualization needs.
  • Table Processing: Offers robust processing capabilities for various form operations such as creation, editing, formatting, and conversion, meeting diverse form processing needs.
  • Data Verification: Includes data verification function to set cell data type, range, uniqueness, ensuring data accuracy and integrity.
  • Batch Processing: Supports batch processing of multiple Excel documents, such as batch format conversion, data extraction, and style application..
  • Import/Export: Facilitates importing data from various sources into spreadsheets and exporting spreadsheet data to other formats.
  • Security Management: Offers a range of security features like data encryption, access control, and permission management to safeguard the security and integrity of spreadsheet data.

Feature & Enhancements in Version v26.6.0

Full list of issues covering all changes in this release:

Summary Category
New Web API: Enable AI-Powered Data Analysis. New Feature
Add Auto-fit function to the format conversion feature. Improvement
AI development API summary New Feature
Fix the bug about Object reference not set to an instance of an object. Bug

Available SDKs

The Aspose.Cells Cloud SDK is available in multiple popular programming languages, enabling developers to integrate spreadsheet processing capabilities across various development environments.

Go Go

Java Java

.NET .NET

Node.js Node.js

Perl Perl

PHP PHP

Python Python

Ruby Ruby

Release history version

aspose/cells-sdk-php 适用场景与选型建议

aspose/cells-sdk-php 是一款 基于 PHP 开发的 Composer 扩展包,目前已累计 54.45k 次下载、GitHub Stars 达 1, 最近一次更新时间为 2015 年 05 月 26 日, 在 PHP 生态内属于活跃度较高的组件。

它主要适用于以下技术方向: 「excel」 「spreadsheet」 「xlsx」 「convert」 「cloud」 「chart」 等业务场景。在实际项目中,围绕这些方向常见需要落地的问题包括:接口对接、性能调优、并发安全、与既有框架(Laravel / ThinkPHP / Yii / Webman 等)的兼容适配,以及生产环境的日志埋点与稳定性保障。

我们在过去多个企业项目中使用过 aspose/cells-sdk-php 或与其功能相近的方案,如果你在选型或落地过程中遇到问题,例如 版本兼容、二次改造、私有化封装、与内部系统对接、生产 BUG 排查,欢迎联系我们协助评估。

围绕 aspose/cells-sdk-php 我们能提供哪些服务?
定制开发 / 二次开发

基于 aspose/cells-sdk-php 在你已有业务上做功能扩展、字段裁剪、UI 适配、与内部账号 / 权限 / 日志系统的深度对接。

BUG 修复 & 性能优化

线上偶发问题、内存泄漏、慢查询、并发异常等排查修复;针对高流量场景做缓存、队列、索引层面的调优。

项目外包 & 长期维护

承接完整的项目从需求 → 设计 → 开发 → 上线 → 长期运维;也可按月提供技术保姆服务。

yvsm@zunyunkeji.com QQ:316430983 微信:yvsm316 西安尊云信息科技 · 专注 PHP / Go / 分布式系统研发

统计信息

  • 总下载量: 54.45k
  • 月度下载量: 0
  • 日度下载量: 0
  • 收藏数: 3
  • 点击次数: 32
  • 依赖项目数: 0
  • 推荐数: 0

GitHub 信息

  • Stars: 1
  • Watchers: 1
  • Forks: 1
  • 开发语言: PHP

其他信息

  • 授权协议: MIT
  • 更新时间: 2015-05-26