Create XLSM File in PHP
High-speed PHP library for creating XLSM file. This is a professional software solution to import and export XLSX, PDF, and many other formats using PHP.
Aspose.Cells for PHP
Overview
Create XLSM File Using PHP
How to create XLSM file? With Aspose.Cells for PHP via Java library, you can easily create XLSM file programmatically with a few lines of code. Aspose.Cells for PHP via Java is capable of building cross-platform applications with the ability to generate, modify, convert, render and print all Excel files. PHP Excel API not only convert between spreadsheet formats, it can also render Excel files as images, PDF, HTML, ODS, CSV, SVG, JSON, WORD, PPT and more, thus making it a perfect choice to exchange documents in industry-standard formats.How to Create XLSM in PHP
It is easy for the developers to create, load, modify and convert XLSM files within running different reporting applications for data processing in just a few lines of code.
- Install ‘Aspose.Cells for PHP via Java’.
- Add a library reference (import the library) to your PHP project.
- Create an instance of Workbook class.
- Access the relevant worksheet using getWorksheets.get() method.
- Select the relevant cell, input the value into the desired cell using the cell name, like A1, B3, etc.
- Save the workbook as XLSM format using the save() method.
Sample code shows how to create XLSM file in PHP.
require_once("Java.inc");
require_once("lib/aspose.cells.php");
use aspose\cells;
use aspose\cells\Workbook;
$workbook = new Workbook();
$sheets = $workbook->getWorksheets();
$cells = $sheets->get(0)->getCells();
// Add relevant content in the cell
$cells->get("A1")->putValue("ColumnA");
$cells->get("B1")->putValue("ColumnB");
$cells->get("A2")->putValue("ValueA");
$cells->get("B2")->putValue("ValueB");
// Save the workbook as XLSM file
$workbook->save("Excel.xlsm");
PHP library to create XLSM file
There are three options to install “Aspose.Cells for PHP via Java” onto your system. Please choose one that resembles your needs and follow the step-by-step instructions:
- Install Aspose.Cells for PHP via Java in Windows. See Documentation
- Install Aspose.Cells for PHP via Java in Linux. See Documentation
- Install Aspose.Cells for PHP via Java in macOS. See Documentation
System Requirements
Aspose.Cells for PHP via Java is platform independent API and can be used on any platform (Windows, Linux, MacOS etc.) where PHP 7 or greater versions is installed. The machine must have Oracle JDK 7 or greater versions before setting up the installation.
XLSM What is XLSM File Format?
Files with XLSM extension is a type of Spreadsheet files that support Macros. From application point of view, a Macro is set of instructions that are used for automating processes. A macro is used to record the steps that are performed repeatedly and facilitates performing the actions by running the macro again. Macros are programmed with Microsoft’s Visual Basic for Applications (VBA) from within the Excel Workbook using the Visual Basic Editor and can be run/debug directly from there.
Read MoreOther Supported Spreadsheet Generation
You can also create other Microsoft Excel formats including few listed below.