Aspose.Cells Java for PHP

Introduction to Aspose.Cells Java for PHP

PHP / Java Bridge

The PHP/Java Bridge is an implementation of a streaming, XML-based network protocol, which can be used to connect a native script engine, for example PHP, Scheme or Python, with a Java virtual machine. It is up to 50 times faster than local RPC via SOAP, requires less resources on the web-server side. It is faster and more reliable than direct communication via the Java Native Interface, and it requires no additional components to invoke Java procedures from PHP or PHP procedures from Java.

Read more at sourceforge.net

Aspose.Cells for Java

Aspose.Cells for Java is an award-winning Excel Spreadsheet component that allows Java developers to embed the ability to read, write and manipulate Excel® spreadsheets (XLS, XLSX, XLSM, XLSB, XLTX, SpreadsheetML, CSV, ODS), HTML, MHTML, PDF and image file formats into their own Java applications without needing to rely on Microsoft Excel®.

Aspose.Cells for Java is a mature, scalable and feature rich component that offers many functions that are way beyond the simple data exporting capabilities of other vendors. With Aspose.Cells for Java developers can export data, format spreadsheets to the most granular level, import images, create charts, apply and calculate complex formulas, stream Excel® data, save in various formats and much more - all this without the need of Microsoft Excel® or Microsoft Office Automation.

Aspose.Cells Java for PHP

Project Aspose.Cells for PHP shows how different tasks can be performed using Aspose.Cells Java APIs in PHP. This project is aimed to provide useful examples for PHP Developers who want to utilise Aspose.Cells for Java in their PHP Projects using PHP/Java Bridge.

This section includes the following topics:

• Download and Configure Aspose.Cells in PHP
• PHP Programmers Guide
  • Introduction in PHP
    • Hello World
  • Working With Files in PHP
    • File Handling Features in PHP
      • Opening Files in PHP
      • Saving Files in PHP
    • Utility Features in PHP
      • Converting Chart to Image in PHP
      • Converting Excel Files to HTML in PHP
      • Converting Excel to PDF Files in PHP
      • Converting to MHTML Files in PHP
      • Converting Worksheet to Image in PHP
      • Converting Worksheet to SVG in PHP
      • Managing Document Properties in PHP
  • Working With Rows And Columns in PHP
    • Adjusting Row Height and Column Width in PHP
    • Autofit Rows and Columns in PHP
    • Copying Rows and Columns in PHP
    • Grouping and Ungrouping Rows and Columns in PHP
    • Hiding and Showing Rows and Columns in PHP
    • Inserting and Deleting Rows and Columns in PHP
  • Working With Worksheets in PHP
    • Display Features in Php
      • Display or Hide Gridlines in Php
      • Display or Hide Scroll Bars in Php
      • Display or Hide Tabs in Php
      • Freeze Panes in Php
      • Hide or Unhide a Worksheet in Php
      • Page Break Preview in Php
      • Split Panes in Php
    • Management Features in Php
      • Managing Worksheets in Php
    • Page Setup Features in Php
      • Setting Page Options in Php
    • Security Features in Php
      • Protecting Worksheets in Php
      • Unprotect a Worksheet in Php
    • Value Features in Php
      • Copying and Moving Worksheets in Php
      • Managing Page Breaks in Php
• Support, Extend and Contribute to Aspose.Cells in PHP

System Requirements and Supported Platforms

System Requirements

Following are the system requirements to use Aspose.Cells Java for PHP:

• Tomcat Server 8.0 or above installed.
• PHP/JavaBridge is configured.
• FastCGI is installed.
• Downloaded Aspose.Cells component.

Supported Platforms

Following are the supported platforms:

• PHP 5.3 or above
• Java 1.8 or above

Downloads and Configure

Download Required Libraries

Download required libraries mentioned below. These are the required for executing Aspose.Cells Java for PHP examples.

• Aspose: Aspose.Cells for Java Component
• PHP/Java Bridge

Download Examples from Social Coding Sites

Following releases of running examples are available to download on below mentioned social coding sites:

---

GitHub

• Aspose.Cells Java for PHP Examples
  • Aspose.Cells Java for PHP

How to configure the source code on Linux Platform

Please follow these simple steps in order to open and extend the source code while using:

1. Install Tomcat Server

To install tomcat server, issue following command on the linux console. This will successfully install tomcat server.

 sudo apt-get install tomcat8

2. Download and Configure PHP/JavaBridge

In order to download the PHP/JavaBridge binaries, issue following command on the linux console.

  wget https://sourceforge.net/projects/php-java-bridge/files/Binary%20package/php-java-bridge_7.2.1/php-java-bridge_7.2.1_documentation.zip/download 

Unzip the PHP/JavaBridge binaries by issuing the following command on linux console.

  unzip -d php-java-bridge_6.2.1_documentation.zip 

This will extract JavaBridge.war file. Copy it to tomcat88 webapps folder by issuing the following command on Linux console.

  sudo cp JavaBridge.war /var/lib/tomcat8/webapps/JavaBridge.war 

By copying, tomcat8 will automatically create a new folder “JavaBridge” in webapps. Once the folder is created, make sure your tomcat8 is running and then check localhost:8080/JavaBridge in browser, it should open a default page of JavaBridge.

If any error message appears then install  FastCGI by issuing the following command on Linux console.

  sudo apt-get install php55-cgi 

After installing php5.5 cgi, restart tomcat8 server and check localhost:8080/JavaBridge again in the browser.

If JAVA_HOME error is displayed, then open /etc/default/tomcat8 file and uncomment the line that sets the JAVA_HOME. Check localhost:8080/JavaBridge in browser again, it should come with PHP/JavaBridge Examples page. 

3. Configure Aspose.Cells Java for PHP Examples

Clone, PHP examples by issuing the following commands inside webapps/JavaBridge folder. 

 $ git init 

$ git clone [https://github.com/aspose-cells/Aspose.Cells-for-Java/tree/master/Plugins/Aspose_Cells_Java_for_PHP] 

How to configure the source code on Windows Platform

Please follow below simple steps to configure PHP/Java Bridge on Windows Platform

\1. Install PHP5 and configure as you normally do \2. Install JRE 6 (Java Runtime Environment) if you don’t already have it. You can check this in C:\Program Files etc. You can download it here . I am using JRE 6 as It is compatible with PHP Java Bridge (PJB).

\3. Install Apache Tomcat 8.0. You can download it here

4.Download JavaBridge.war. Copy this file to tomcat webapps directory. (ex: C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps )

\5. Restart tomcat apache service.

6.Go to localhost:8080/JavaBridge/test.php to check if php works. You can find other examples in there

7.Copy your Aspose.Cells Java jar file to C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\JavaBridge\WEB-INF\lib

\8. Clone Aspose.Cells Java for PHP examples inside C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\ folder.

\8. Copy folder C:\Program Files\Apache Software Foundation\Tomcat 8.0\webapps\JavaBridge\java to your Aspose.Cells Java for PHP examples folder.

\10. Restart apache tomcat service and start using examples.

Support, Extend and Contribute

Support

From the very first days of Aspose, we knew that just giving our customers good products would not be enough. We also needed to deliver good service. We are developers ourselves and understand how frustrating it is when a technical issue or a quirk in the software stops you from doing what you need to do. We’re here to solve problems, not create them.

This is why we offer free support. Anyone who uses our product, whether they have bought them or are using an evaluation, deserves our full attention and respect.

You can log any issues or suggestions related to Aspose.Cells Java for PHP using any of the following platforms:

• Github

Extend and Contribute

Aspose.Cells Java for PHP is open source and its source code is available on the major social coding websites listed below. Developers are encouraged to download the source code and contribute by suggesting or adding new feature or improving the existing ones, so that others could also benefit from it.

Source Code

You can get the latest source code from one of the following locations

• Github