Tutorial 08: How to set header and footer in PHP

Corelcad Portable -

EasyXLS Excel library can be used to export Excel files with PHP on Windows, Linux, Mac or other operating systems. The integration vary depending on the operating system or if .NET Framework or Java is chosen:

1. EasyXLS on Windows using .NET Framework (COM+) with PHP

2. EasyXLS on Linux, Mac, Windows using Java with PHP

EasyXLS on Windows using .NET Framework (COM+) with PHP

If you opt for the COM+ version of EasyXLS, be sure that you have EasyXLS installed and registered on your machine.

Find more about Getting Started with EasyXLS

Corelcad Portable -

CorelCAD Portable: Efficiency and Flexibility for Designers on the Go

In the rapidly evolving world of Computer-Aided Design (CAD), the demand for high-performance tools that offer both power and flexibility has never been greater. CorelCAD Portable is a streamlined, non-install version of the industry-standard CorelCAD software, designed for professionals who need to work across multiple workstations without the constraints of a traditional installation.

This version provides the full suite of 2D drafting and 3D design tools that CorelCAD is known for, but with the added convenience of being entirely self-contained. Whether you are an architect, engineer, or graphic designer, CorelCAD Portable allows you to carry your workspace on a USB drive and launch it on any compatible machine. What is CorelCAD Portable?

CorelCAD Portable is a "thin-app" or "portableized" version of Corel’s robust CAD solution. Unlike the standard version, which requires an administrative installation on a computer's hard drive, the portable version runs directly from a removable storage device. It does not modify system registries or leave traces on the host computer, making it ideal for:

Freelancers who switch between client offices and home studios. Students who use shared university computers.

IT Professionals who need a quick diagnostic CAD tool without a full deployment. Key Features and Capabilities

Despite its compact delivery method, CorelCAD Portable does not compromise on functionality. It maintains the core features that have made it a viable alternative to more expensive industry leaders. 1. Native .DWG Support

CorelCAD uses the .DWG format as its native file type. This ensures total compatibility with AutoCAD and other major CAD platforms. You can open, edit, and save files without worrying about data loss or formatting errors during the conversion process. 2. Advanced 2D Drafting

The software provides a comprehensive set of precision drafting tools. From basic geometric shapes to complex constraints, the portable version includes:

Smart Dimensioning tools that automatically suggest the best dimension type. Layer management for organizing complex drawings.

Drawing Constraints to maintain geometric relationships between objects. 3. 3D Modeling and Design

CorelCAD Portable isn't just for flat drawings. It supports sophisticated 3D modeling workflows:

Solid Modeling: Create primitive shapes and use Boolean operations (Union, Subtract, Intersect) to build complex 3D parts. corelcad portable

3D Filleting and Chamfering: Add professional finishes to your 3D models.

3D Printing Ready: Export your designs to .STL format, the standard for 3D printing and rapid prototyping. The Advantages of Using a Portable CAD Solution

Why choose a portable version over a traditional desktop installation? The benefits revolve around mobility and security.

Zero Footprint: Since the software runs from a USB, it doesn't clutter the host PC's registry or file system. This is perfect for maintaining privacy and system cleanliness on borrowed hardware.

Instant Access: There is no waiting for long installation processes or configuration menus. You simply plug in your drive and start designing.

Consistency: All your settings, custom toolbars, and workspace preferences stay on your drive. No matter what computer you use, the environment feels exactly the same. System Requirements and Performance

To run CorelCAD Portable smoothly, the host computer should meet the standard specifications for CorelCAD: OS: Windows 10 or 11 (64-bit recommended).

Processor: Intel Core 2 Duo or AMD Athlon x2 Dual-Core processor. RAM: Minimum 4GB (8GB or more recommended for 3D work).

Graphics: 3D Graphics accelerator card with OpenGL 1.4 or higher.

Note: While the software is portable, high-complexity 3D rendering still relies heavily on the host machine's GPU and CPU power. Use Cases: Who is it for?

On-Site Architects: Quickly pull up blueprints on a contractor’s laptop to make immediate field adjustments.

Mechanical Engineers: Carry technical parts libraries and design tools to the factory floor or testing lab. If you must try portability—what to do safely

Collaborative Teams: Easily share a specific software version and project environment across a team by passing a physical or digital portable package. Conclusion

CorelCAD Portable represents a shift toward a more agile design workflow. By combining the professional-grade precision of Corel’s CAD engine with the "run-anywhere" convenience of portable software, it empowers designers to be productive wherever inspiration strikes. While a standard installation is still the choice for permanent workstations, the portable version is an essential tool for the modern, mobile professional.

CorelCAD was a professional 2D drafting and 3D design software based on the ARES CAD platform. It is important to note that CorelCAD was discontinued in 2024 . CorelCAD 2023 was the final version released. Transition and Support

Since the software has been discontinued, official "portable" versions (officially sanctioned stand-alone executable versions that do not require installation) are generally not provided by Corel. For users of the original software, the technology partner currently provides a transition offer for license owners to move to their CorelCAD Mobile (Portable Alternative)

While a desktop "portable" version isn't a standard retail product, Corel previously offered CorelCAD Mobile for those needing a portable solution on the go. Kamera Express Availability: Designed for iPad, iPhone, and Android devices. Key Functionality: Allows users to view, annotate, and edit files on site or during travel. Collaboration:

Supports voice notations and commenting within editable drawings. Kamera Express Key Desktop Features (for existing users)

If you are still using a legacy installation of CorelCAD (like versions 2019–2023), here are the core pillars of the software: Native .DWG Support: Full compatibility with AutoCAD

files, allowing for seamless sharing with other CAD professionals. 2D to 3D Conversion: Features tools like the Property Painter Design Resources docker to transform 2D sketches into 3D models. Industry Standards: Includes a VerifyStandards

command to ensure drawings match corporate or project naming conventions for layers and styles. Customization: Supports automation through (compatible with AutoCAD routines) and Kamera Express Quick Start Guide for Beginners CorelCAD 2018 Reviewer's Guide - Kamera Express

The phrase "CorelCAD Portable" typically refers to a modified, unauthorized version of the CorelCAD software designed to run without installation, often from a USB drive. While the concept of "portable" software is legitimate for open-source or freeware tools, in the context of commercial CAD software like CorelCAD, it is almost exclusively associated with software piracy and security risks.

Here is a deep analysis of the implications, risks, and technical realities surrounding "CorelCAD Portable."

2. Network Licensing

For businesses, Corel offers network licensing options. While this isn't "portable" in the USB sense, it allows authorized users to install the software on multiple machines and log in wherever they are working. This ensures you have the full, legal, and stable power of Corel lack technical support

Here’s a deep, practical guide to CorelCAD Portable — covering what it is, where to find it, limitations, risks, workflow tips, and legitimate alternatives.

If you must try portability—what to do safely

Use official licensing procedures: ensure activation and license transfer comply with Corel’s terms.
Prefer a VM approach: least likely to break activation and easier to control security.
Keep files backed up: version control or cloud backups to avoid corruption loss.
Avoid downloads from untrusted sites offering “portable” CorelCAD installers.

Verdict: Avoid unofficial "portable" repacks.

The security, legal, and stability risks far outweigh the convenience of a $10 USB drive. Instead:

If you own a CorelCAD license – Use Windows To Go or remote access.
If you need free, truly portable CAD – Use LibreCAD Portable (PortableApps.com).
If you need native .DWG on multiple PCs – Install CorelCAD legitimately on each machine or use a network license.

Corel Corporation has not made CorelCAD portable, and no ethical or safe method exists to force it. For professional work, always prioritize stability and legality over the fleeting convenience of running from a thumb drive.

Disclaimer: This article is for educational purposes. The author does not endorse piracy or the use of cracked software. Always respect software licenses and intellectual property rights.

4. Legal and Ethical Implications

CorelCAD occupies a middle ground in the CAD market—it is more affordable than AutoCAD but more expensive than free alternatives like LibreCAD. The existence of "Portable" versions undermines the developer's ability to maintain and update the software.

While individual users often rationalize piracy due to high software costs, the use of cracked software in a commercial environment opens a company up to lawsuits and heavy fines. Furthermore, using unlicensed software violates the terms of service for professional certification in many engineering fields, potentially invalidating liability insurance.

What Exactly is CorelCAD Portable?

First, it is critical to clarify a common misconception. Corel, the developer of CorelCAD, does not officially distribute a "Portable" version. Therefore, when professionals refer to CorelCAD Portable, they are typically referring to one of two things:

Legally Portable via License Management: Using a licensed copy of CorelCAD installed on an external SSD or high-speed USB drive, activated via a volume license or network license that allows roaming users.
Unofficial "Cracked" Versions: Third-party repacks that attempt to bypass licensing to run without installation. We strongly advise against this. These versions are often unstable, contain malware, lack technical support, and violate software copyright laws.

This guide focuses on the legitimate methods to achieve portability using your own valid CorelCAD license.

Best Legitimate Alternatives to CorelCAD Portable

If the hassle of carrying your OS or remoting in is too great, consider these genuinely portable CAD solutions. They are different software packages, but they offer .DWG compatibility and a portable ethos.

Recommendation: If you require CorelCAD’s specific 3D ACIS modeling and cannot install software, nanoCAD Free Portable is the closest legitimate match for 2D work.

3. Stability and Data Corruption

Virtualized CAD applications often crash when accessing hardware acceleration (OpenGL/DirectX) or large 3D assemblies. A crash mid-save can corrupt your .DWG file permanently.

Execute the following PHP code that exports an Excel file with the header for center section containing the file name and a custom text, header for right section containing the date and time and footer for center section containing the page number and total number of pages.

View Excel file

Copy code

<?php

/*=============================================================
| Tutorial 08
|
| This tutorial shows how to create an Excel file in PHP having
| multiple sheets. The first sheet is filled with data
| and the cells are formatted and locked.
| The column header has comments.
| The first sheet has header & footer.
* ===========================================================*/

include("DataType.inc");
include("Alignment.inc");
include("Border.inc");
include("Color.inc");
include("Header.inc");
include("Footer.inc");

header("Content-Type: text/html");

echo "Tutorial 08<br>";
echo "----------<br>";

// Create an instance of the class that exports Excel files
$workbook = new COM("EasyXLS.ExcelDocument");

// Create two sheets
$workbook->easy_addWorksheet_2("First tab");
$workbook->easy_addWorksheet_2("Second tab");

// Protect first sheet
$workbook->easy_getSheetAt(0)->setSheetProtected(true);

// Get the table of data for the first worksheet
$xlsFirstTable = $workbook->easy_getSheetAt(0)->easy_getExcelTable();

// Create the formatting style for the header
$xlsStyleHeader = new COM("EasyXLS.ExcelStyle");
$xlsStyleHeader->setFont("Verdana");
$xlsStyleHeader->setFontSize(8);
$xlsStyleHeader->setItalic(True);
$xlsStyleHeader->setBold(True);
$xlsStyleHeader->setForeground((int)$COLOR_YELLOW);
$xlsStyleHeader->setBackground((int)$COLOR_BLACK);
$xlsStyleHeader->setBorderColors ((int)$COLOR_GRAY, (int)$COLOR_GRAY, (int)$COLOR_GRAY, (int)$COLOR_GRAY);
$xlsStyleHeader->setBorderStyles ($BORDER_BORDER_MEDIUM, $BORDER_BORDER_MEDIUM, 
                                        $BORDER_BORDER_MEDIUM, $BORDER_BORDER_MEDIUM);
$xlsStyleHeader->setHorizontalAlignment($ALIGNMENT_ALIGNMENT_CENTER);
$xlsStyleHeader->setVerticalAlignment($ALIGNMENT_ALIGNMENT_BOTTOM);
$xlsStyleHeader->setWrap(True);
$xlsStyleHeader->setDataType($DATATYPE_STRING);

// Add data in cells for report header
for ($column=0; $column<5; $column++)
{
    $xlsFirstTable->easy_getCell(0,$column)->setValue("Column " . ($column + 1));
    $xlsFirstTable->easy_getCell(0,$column)->setStyle($xlsStyleHeader);

    // Add comment for report header cells
    $xlsFirstTable->easy_getCell(0, $column)->setComment_2("This is column no " . ($column + 1));
}
$xlsFirstTable->easy_getRowAt(0)->setHeight(30);

// Create a formatting style for cells
$xlsStyleData = new COM("EasyXLS.ExcelStyle");
$xlsStyleData->setHorizontalAlignment($ALIGNMENT_ALIGNMENT_LEFT);
$xlsStyleData->setForeground((int)$COLOR_DARKGRAY);
$xlsStyleData->setWrap(false);
// Protect cells
$xlsStyleData->setLocked(true);
$xlsStyleData->setDataType($DATATYPE_STRING);

// Add data in cells for report values
for ($row=0; $row<100; $row++)
{
    for ($column=0; $column<5; $column++)
    {
        $xlsFirstTable->easy_getCell($row+1,$column)->setValue("Data " . ($row + 1) .
                                                               ", " . ($column + 1));
        $xlsFirstTable->easy_getCell($row+1,$column)->setStyle($xlsStyleData);
    }
}

// Set column widths
$xlsFirstTable->setColumnWidth_2(0, 70);
$xlsFirstTable->setColumnWidth_2(1, 100);
$xlsFirstTable->setColumnWidth_2(2, 70);
$xlsFirstTable->setColumnWidth_2(3, 100);
$xlsFirstTable->setColumnWidth_2(4, 70);

// Add header on center section
$xlsFirstTab = $workbook->easy_getSheetAt(0);
$xlsFirstTab->easy_getHeaderAt_2($HEADER_POSITION_CENTER)->InsertSingleUnderline();
$xlsFirstTab->easy_getHeaderAt_2($HEADER_POSITION_CENTER)->InsertFile();
$xlsFirstTab->easy_getHeaderAt_2($HEADER_POSITION_CENTER)->InsertValue(" - How to create header and footer");

// Add header on right section
$xlsFirstTab->easy_getHeaderAt_2($HEADER_POSITION_RIGHT)->InsertDate();
$xlsFirstTab->easy_getHeaderAt_2($HEADER_POSITION_RIGHT)->InsertValue(" ");
$xlsFirstTab->easy_getHeaderAt_2($HEADER_POSITION_RIGHT)->InsertTime();

// Add footer on center section
$xlsFirstTab->easy_getFooterAt_2($FOOTER_POSITION_CENTER)->InsertPage();
$xlsFirstTab->easy_getFooterAt_2($FOOTER_POSITION_CENTER)->InsertValue(" of ");
$xlsFirstTab->easy_getFooterAt_2($FOOTER_POSITION_CENTER)->InsertPages();

// Export Excel file
echo "Writing file: C:\Samples\Tutorial08 - header and footer in Excel.xlsx<br>";
$workbook->easy_WriteXLSXFile("C:\Samples\Tutorial08 - header and footer in Excel.xlsx");

// Confirm export of Excel file
if ($workbook->easy_getError() == "")
    echo "File successfully created.";
else
    echo "Error encountered: " . $workbook->easy_getError();

// Dispose memory
$workbook->Dispose();
$workbook = null;
$xlsStyleHeader = null;
$xlsStyleData = null;

?>

Overloaded methods
For methods with same name but different parameters, only the first method overload retains the original name. Subsequent overloads are uniquely renamed by appending to the method name '_2', '_3', etc (method, method_2, method_3), an integer that corresponds to the order of declaration that can be found in EasyXLS.h, a file that comes with EasyXLS installation.

EasyXLS on Linux, Mac, Windows using Java with PHP

If you opt for the Java version of EasyXLS, a similar code as above requires PHP/Java Bridge between PHP and Java.

Find more about Getting Started with EasyXLS

Step 1: Download EasyXLS Excel Library for Java

To download the trial version of EasyXLS Excel Library, press the below button:

If you already own a license key, you may login and download EasyXLS from your account.

Step 2: License file setup

Step required for EasyXLS v9.0 or later.

If you are using a trial, generate a trial license file from EasyXLS trials page. The trial license is valid for 30-days.

If you own a license key, you may login to the account that purchased the license and generate the license file from:
https://www.easyxls.com/my-orders

Setup the license file into your project using these guidelines.

Step 3: Install PHP/Java Bridge

Download PHP/Java Bridge and follow the PHP/Java Bridge installation guide for directions.

Step 4: Setup EasyXLS library in Tomcat

Copy EasyXLS.jar into Tomcat installation path, lib folder.

Step 5: Run PHP code that exports an Excel file with header and footer

View Excel file

Copy code

<?php require_once("http://localhost:8080/JavaBridge/java/Java.inc");

/*=============================================================
| Tutorial 08
|
| This tutorial shows how to create an Excel file in PHP having
| multiple sheets. The first sheet is filled with data
| and the cells are formatted and locked.
| The column header has comments.
| The first sheet has header & footer.
=============================================================*/

include("DataType.inc");
include("Alignment.inc");
include("Border.inc");
include("Color.inc");
include("Header.inc");
include("Footer.inc");

header("Content-Type: text/html");
	
echo "Tutorial 08<br>";
echo "----------<br>";
	
// Create an instance of the class that exports Excel files
$workbook = new java("EasyXLS.ExcelDocument");
	
// Create two sheets
$workbook->easy_addWorksheet("First tab");
$workbook->easy_addWorksheet("Second tab");

// Protect first sheet
$workbook->easy_getSheetAt(0)->setSheetProtected(true);
	
// Get the table of data for the first worksheet
$xlsFirstTable = $workbook->easy_getSheetAt(0)->easy_getExcelTable();

// Create the formatting style for the header
$xlsStyleHeader = new java("EasyXLS.ExcelStyle");
$xlsStyleHeader->setFont("Verdana");
$xlsStyleHeader->setFontSize(8);
$xlsStyleHeader->setItalic(True);
$xlsStyleHeader->setBold(True);
$xlsStyleHeader->setForeground(java("java.awt.Color")->YELLOW);
$xlsStyleHeader->setBackground(java("java.awt.Color")->BLACK);
$xlsStyleHeader->setBorderColors (java("java.awt.Color")->GRAY, java("java.awt.Color")->GRAY,
                                  java("java.awt.Color")->GRAY, java("java.awt.Color")->GRAY);
$xlsStyleHeader->setBorderStyles ($BORDER_BORDER_MEDIUM, $BORDER_BORDER_MEDIUM,
                                  $BORDER_BORDER_MEDIUM, $BORDER_BORDER_MEDIUM);
$xlsStyleHeader->setHorizontalAlignment($ALIGNMENT_ALIGNMENT_CENTER);
$xlsStyleHeader->setVerticalAlignment($ALIGNMENT_ALIGNMENT_BOTTOM);
$xlsStyleHeader->setWrap(True);
$xlsStyleHeader->setDataType($DATATYPE_STRING);
	
// Add data in cells for report header
for ($column=0; $column<5; $column++)
{
    $xlsFirstTable->easy_getCell(0,$column)->setValue("Column " . ($column + 1));
    $xlsFirstTable->easy_getCell(0,$column)->setStyle($xlsStyleHeader);

    // Add comment for report header cells
    $xlsFirstTable->easy_getCell(0, $column)->setComment("This is column no " . ($column + 1));
}
$xlsFirstTable->easy_getRowAt(0)->setHeight(30);
	
// Create a formatting style for cells
$xlsStyleData = new java("EasyXLS.ExcelStyle");
$xlsStyleData->setHorizontalAlignment($ALIGNMENT_ALIGNMENT_LEFT);
$xlsStyleData->setForeground(java("java.awt.Color")->LIGHT_GRAY);
$xlsStyleData->setWrap(false);
$xlsStyleData->setLocked(true);
$xlsStyleData->setDataType($DATATYPE_STRING);
	
// Add data in cells for report values
for ($row=0; $row<100; $row++)
{
    for ($column=0; $column<5; $column++)
    {
        $xlsFirstTable->easy_getCell($row+1,$column)->setValue("Data " . ($row + 1) .
                                                               ", " . ($column + 1));
        $xlsFirstTable->easy_getCell($row+1,$column)->setStyle($xlsStyleData);
    }
}
	
// Set column widths
$xlsFirstTable->setColumnWidth(0, 70);
$xlsFirstTable->setColumnWidth(1, 100);
$xlsFirstTable->setColumnWidth(2, 70);
$xlsFirstTable->setColumnWidth(3, 100);
$xlsFirstTable->setColumnWidth(4, 70);
	
// Add header on center section
$xlsFirstTab = $workbook->easy_getSheetAt(0);
$xlsFirstTab->easy_getHeaderAt($HEADER_POSITION_CENTER)->InsertSingleUnderline();
$xlsFirstTab->easy_getHeaderAt($HEADER_POSITION_CENTER)->InsertFile();
$xlsFirstTab->easy_getHeaderAt($HEADER_POSITION_CENTER)->InsertValue(" - How to create header and footer");

// Add header on right section
$xlsFirstTab->easy_getHeaderAt($HEADER_POSITION_RIGHT)->InsertDate();
$xlsFirstTab->easy_getHeaderAt($HEADER_POSITION_RIGHT)->InsertValue(" ");
$xlsFirstTab->easy_getHeaderAt($HEADER_POSITION_RIGHT)->InsertTime();

// Add footer on center section
$xlsFirstTab->easy_getFooterAt($FOOTER_POSITION_CENTER)->InsertPage();
$xlsFirstTab->easy_getFooterAt($FOOTER_POSITION_CENTER)->InsertValue(" of ");
$xlsFirstTab->easy_getFooterAt($FOOTER_POSITION_CENTER)->InsertPages();
	
// Export Excel file
echo "Writing file: C:\Samples\Tutorial08 - header and footer in Excel.xlsx<br>";
$workbook->easy_WriteXLSXFile("C:\Samples\Tutorial08 - header and footer in Excel.xlsx");
	
// Confirm export of Excel file
if ($workbook->easy_getError() == "")
    echo "File successfully created.";
else
    echo "Error encountered: " . $workbook->easy_getError();
		
// Dispose memory
$workbook->Dispose();

?>

EasyXLS Excel libraries:
Excel Library for PHP COM+
full COM+ version to import, export or convert Excel files
Excel Writer for PHP COM+
COM+ version to create and export Excel files


Excel Library for PHP Java
full Java version to import, export or convert Excel files
Excel Writer for PHP Java
Java version to create and export Excel files

File formats:
Office 365 MS Excel 2021 - 2026 MS Excel 2007 - 2019 MS Excel 97 - 2003

Corelcad Portable -

EasyXLS on Windows using .NET Framework (COM+) with PHP

Corelcad Portable -

2. Network Licensing

If you must try portability—what to do safely

Verdict: Avoid unofficial "portable" repacks.

4. Legal and Ethical Implications

What Exactly is CorelCAD Portable?

Best Legitimate Alternatives to CorelCAD Portable

3. Stability and Data Corruption

EasyXLS on Linux, Mac, Windows using Java with PHP

Step 1: Download EasyXLS Excel Library for Java

Step 2: License file setup

Step 3: Install PHP/Java Bridge

Step 4: Setup EasyXLS library in Tomcat

Step 5: Run PHP code that exports an Excel file with header and footer

Related sections

See also

Related methods

Related constants

EasyXLS Excel libraries:

File formats: