Win a copy of Secure Financial Transactions with Ansible, Terraform, and OpenSCAP this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Rob Spoor
  • Henry Wong
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh
  • Jj Roberts

Create, Manipulate & Convert Excel Spreadsheets without using MS Excel in PHP APPs

 
Ranch Hand
Posts: 714
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is new in this release?

Aspose team is pleased to announce the first public release of Aspose.Cells for PHP via Java The new API incorporates MS Excel data processing and rendering functionalities in PHP (a widely-used open source scripting language). Aspose.Cells for PHP via Java has full functionality of Aspose.Cells for Java with a few limitations, minor API changes and additional requirements. Aspose.Cells for PHP is a subset API that includes all the important and useful features present in its native Aspose.Cells for Java. Aspose.Cells for PHP via Java is equally robust and feature rich component. It supports high-fidelity file format conversions to and from XLS, XLSX, XLSM, SpreadsheetML, CSV, Tab Delimited, HTML, MHTML and OpenDocument Spreadsheet in PHP. The developers will have full programmatic access through a rich APIs set to all MS Excel document objects and formatting that allows to create, modify, extract, copy, merge, and replace spreadsheet content. With Aspose.Cells for PHP via Java, developers can export data, format spreadsheets to the most granular level, create, manipulate and render charts, apply and calculate complex formulas efficiently and much more. The list of most notable new and improved features in this release are listed below

- Supports for XLS, SpreadsheetML (XLSX, XML), Comma Separated Value (CSV), HTML, OpenDocument Spreadsheet (ODS), PDF, Tab Delimited, -  Plain Text (TXT)
- Render spreadsheet to vector images (EMF)
- Render worksheets to raster images (Multipage TIFF, GIF)
- Render worksheets to raster images (PNG, JPEG, etc.)
- Render Spreadsheet to PDF with high fidelity
- Render spreadsheet to vector images (EMF)
- Render worksheets to raster images (Multipage TIFF, GIF)
- Render worksheets to raster images (PNG, JPEG, etc.)
- Render Spreadsheet to PDF with high fidelity
- Copy or move worksheets within or between workbooks
- Insert images, Create conventional and custom charts and Set gradient background for charts using API
- Add comments to cells
- Microsoft Excel 2007/2010 themes and colors
- Create auto-filters
- Implement data validations
- Implement data sorting
- Find and replace text
- Merge/split Cells
- Group/ungroup rows and columns
- Create custom page breaks
- Calculate complex Excel formulae
- Support advanced conditional formatting supported in Microsoft Excel 2007/2010
- Freeze/unfreeze Panes
- Insert hyperlinks to link data
- Implement Smart Markers
- Specify document properties settings
- Protect/unprotect worksheets
- Specify advanced protection options introduced in Excel XP and later versions
- Create list object/Microsoft Excel tables
- Create subtotals
- Insert form controls and other drawing shapes/objects
- Create pivot tables and pivot charts
- Preserve or remove addin, VBA, macros
- Manipulate named ranges
- Add, preserve or extract OLE objects from the spreadsheets.
- Implement Microsoft Excel sparklines
- Apply all characters formatting in the cells including fonts, colors, effects, borders and shading
- Apply all the number format settings (supported in Microsoft 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 Format settings on a worksheet, row, column or a range of cells etc.
- Adjust your page orientation, scaling, paper size
- Specify your margins and page centering
- Create or edit your header and/or footer
- Set print area, print titles, or turn on gridlines etc.

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for PHP via Java documentation that may guide users briefly how to use Aspose.Cells for performing different tasks like the followings.

- Product Overview
-   Converting Excel Files to HTML ?

Overview: Aspose.Cells for PHP via Java

Aspose.Cells for PHP via Java is an Excel Spreadsheet Processing API that allows the developers to add the ability to read, write, convert and manipulate Excel spreadsheets in their on PHP applications while using the JavaBridge. The new API is equally robust and feature rich component. It supports high-fidelity file format conversions to and from XLS, XLSX, XLSM, SpreadsheetML, CSV, Tab Delimited, HTML, MHTML and OpenDocument Spreadsheet in PHP.It is capable of converting spreadsheets to PDF, XPS & HTML formats while maintaining the highest visual fidelity.

More about Aspose.Cells for PHP via Java

- Homepage of Aspose.Cells for PHP via Java
- Download Aspose.Cells for PHP via Java
- Online documentation of Aspose.Cells for PHP via Java
- Post your technical questions/queries to Aspose.Cells Forum

Contact Information
Aspose Pty Ltd
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - Your File Format Experts
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
 
Popeye has his spinach. I have this tiny ad:
SKIP - a book about connecting industrious people with elderly land owners
https://coderanch.com/t/skip-book
reply
    Bookmark Topic Watch Topic
  • New Topic