Tutorial 08: How to set header and footer in PHP

Vlc Media Player Volume 400 -

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

Vlc Media Player Volume 400 -

VLC Media Player is widely celebrated for its ability to boost audio levels beyond the standard 100% threshold, often reaching up to 400% through specific user interactions or configuration tweaks. This feature, technically known as "software gain," is a lifesaver for low-volume recordings or quiet laptop speakers. How to Reach 400% Volume in VLC

While the standard volume slider in newer versions of VLC often caps at 125% or 200% by default, you can still push the audio further.

Mouse Scroll Method: In many versions, simply placing your mouse over the video window and scrolling up with the wheel allows the volume to climb to 400%.

Keyboard Shortcuts: Using Ctrl + Up Arrow can also push the volume past the slider's visible limit in some configurations.

Audio Gain Adjustment: For a permanent boost, you can modify the "Audio gain" setting. Navigate to Tools > Preferences, select the "All" radio button under "Show settings," click Audio, and increase the Audio gain value. Changing the Maximum Displayed Volume

If you want the volume slider itself to allow higher levels (typically up to 300%), follow these steps:

3.4. Chaining Multiple Volume Filters

Using --audio-filter=volume,volume (not allowed natively) would require forking VLC source.

Method 2: The Graphical Slider (Visual Control)

If you want to see exactly where you are on the spectrum, use the interface.

Look at the volume icon (the speaker) at the bottom right of the VLC window.
Click the speaker icon. A slider appears.
Drag the slider all the way to the right. It stops visually at 200% by default.
Wait... where is 400%? VLC hides the 400% mark behind a secondary click.
Right-click the speaker icon. A hidden menu pops up with specific numerical values: 100%, 125%, 150%, 200%, 300%, and 400%.
Click 400%.

Part 7: The Verdict – Is 400% a Gimmick of a Godsend?

The Final Take: The VLC Media Player volume 400% feature is neither a gimmick nor a reckless weapon. It is a professional tool.

For casual movie streaming at home: 400% is overkill. 150% usually fixes quiet dialogue.
For educational content or archival footage (1970s documentaries, VHS rips): 400% is a lifesaver.
For music listening: Avoid 400% completely. Music is already mastered to be loud.

The magic of VLC is that it trusts the user. It gives you the keys to a Ferrari (the audio engine) and says, "Drive it at 400% if you want, but don't crash your hearing."

Action Plan:

Open VLC right now.
Play a quiet video.
Press Ctrl + Up until you hit 400%.
Listen critically. Is it clean? Use it. Is it distorted? Back off to 250%.
Remember to reset to 100% before playing a modern movie, or you will scare your pets.

VLC remains the king of media players because it refuses to babysit you. Whether you need 100% or 400%, the power is in your hands (and your keyboard shortcuts).

Have you ever needed to go to 400% volume? What were you watching? Share your loudest VLC story in the comments below!

The Ceiling of Digital Sound: Understanding VLC’s 400% Volume Feature

VLC Media Player has earned its reputation as the "Swiss Army Knife" of media players, not just for its ability to play virtually any file format, but for its unique philosophy toward audio. While most media players treat 100% volume as a hard limit, VLC offers users the ability to push audio levels significantly higher—historically up to 400%. This feature is a powerful tool for low-quality recordings but serves as a cautionary tale about the limits of digital hardware. The Mechanics of Software Amplification

In standard audio playback, 100% volume represents the "flat" part of the gain curve, where the audio is played at the original amplitude intended by the file's creator without additional digital processing. VLC achieves levels beyond this through software amplification Digital Multiplication

: VLC increases volume by multiplying the digital samples of an audio stream by a factor greater than one. The "VLC 400" Legend

: In older versions of VLC (pre-2.1.0), the interface allowed users to scroll the volume slider up to 400%. While newer versions have capped the standard slider at 125% or 200%, the underlying ability to boost signal remains a core part of its identity. Gain vs. Master Volume

: Unlike Windows master volume, which merely controls the output of the sound card, VLC manipulates the raw data before it ever reaches the hardware. The Sound of Distortion: Clipping and Compression

Pushing audio to 400% is not a "magic" increase in loudness; it comes at a significant cost to fidelity. vlc media player volume 400

: When a digital signal is boosted beyond the maximum value that the hardware can represent, the peaks of the sound wave are literally "clipped" off. This results in a square-like wave that produces harsh, crackling distortion. Dynamic Range Compression

: To mitigate some of this, VLC uses advanced compression to keep quiet sounds loud while preventing the loudest sounds from exceeding the digital ceiling. This makes the audio perceiveably louder but flattens the "crispness" and dynamic range of the media. VLC volume only to 200%? - Super User

You can set maximum volume up to 300% in preferences. Tools -> Preferences (Show settings = All) -> Interface -> Main interfaces - Super User

Unlocking the Full Potential of VLC Media Player: How to Boost Volume Beyond the Norm

VLC Media Player, a stalwart in the realm of media playback software, is renowned for its versatility, wide format support, and robust feature set. One of its less commonly known features, however, is the ability to push the volume beyond the standard limits available in most media players. For those who have ever found themselves wishing for just a bit more oomph from their audio, VLC's "volume 400" trick is a game-changer.

The Standard Volume Limit

Typically, media players cap the volume at 100%. This is sufficient for most users under normal conditions. However, there are scenarios where you might crave more volume: watching a movie in a noisy environment, for instance, or perhaps ensuring that every subtle detail in a music track is audible.

VLC's Volume Boost Solution

VLC Media Player offers a straightforward solution to those seeking more volume. By introducing a preference tweak, users can elevate the volume cap to 400%. Yes, you read that correctly – 400% of the standard maximum volume. This is more than sufficient for almost any situation, ensuring that your media consumption experience is not compromised by ambient noise.

How to Enable 400% Volume in VLC

Enabling the increased volume in VLC is a straightforward process:

Open VLC and navigate to Preferences (or press Ctrl + P on Windows or Command + P on macOS).
In the Preferences window, at the bottom, select Show settings: All. This option reveals VLC's advanced settings.
Navigate to Audio > Filters > Audio Gain.
Check the box next to Audio gain and set the Audio gain to 20.0 dB (this directly correlates to the 400% volume setting).
Click Save to apply your changes.

Alternatively, a quicker method exists for those comfortable with directly editing VLC's configuration:

Open the VLC installation directory on your computer.
Navigate to lua > filters.
Open audio.c with a text editor (if you can find it) or directly edit vlc-qt.conf (on Windows) or create/edit vlcrc (on macOS/Linux), adding or modifying the line: audio-gain=20

Be Cautious

While the ability to boost volume to 400% can be a lifesaver, caution is warranted. Prolonged listening at high volumes can lead to hearing damage. Additionally, increased volume might lead to distortion, particularly with lower-quality audio equipment or headphones. Always use this feature judiciously.

Conclusion

The "VLC media player volume 400" trick offers a simple yet powerful way to overcome volume limitations during media playback. For those who frequently find themselves battling background noise or craving more from their audio experience, VLC's solution is both accessible and effective. Just remember to protect your hearing and your equipment. Enjoy your amplified audio experiences with VLC, knowing you're pushing the boundaries of what's possible with standard media players.

VLC Media Player's ability to boost volume beyond the standard 100%—sometimes up to 400%—is one of its most iconic (and potentially speaker-blowing) features. This isn't just a UI trick; it’s a form of digital signal amplification. 1. The Core Mechanism: Digital Gain

When you set VLC to 100%, the software is playing the audio file at its native amplitude—the maximum level it was recorded at without modification.

When you push past 100%, VLC performs a mathematical multiplication of the audio samples: VLC Media Player is widely celebrated for its

The Math: Audio data is stored as a series of numerical values (samples). To increase volume, VLC multiplies every sample value by a gain factor (e.g., 2.0 for 200%).

Pre-amplification: This happens before the signal reaches your operating system's mixer or your hardware's Digital-to-Analog Converter (DAC). 2. Why 400% Specifically?

While the default UI slider often caps at 125% or 200% for safety, VLC can be pushed further:

The Mouse Scroll Trick: On many versions, if you hover over the video and use the mouse scroll wheel, the volume can continue to climb to 400%, even if the visual slider stops earlier.

Qt Interface Settings: In VLC's advanced preferences (Tools > Preferences > Show Settings: All > Interface > Main interfaces > Qt), you can manually set the "Maximum volume displayed" to values like 300 or higher. 3. The Trade-off: Hard Clipping and Distortion

Software amplification is not "magic" volume; it has a hard limit called 0 dBFS (Decibels Full Scale).

VLC Media Player typically limits its volume slider to 125% or 200%. While there is no native setting to reach exactly 400% without severe distortion, you can push the interface to its absolute limit (300%) or use software tricks to mimic higher amplification. 1. How to Unlock 300% Volume (Maximum Interface Setting)

You can modify the "Maximum Volume" setting in the advanced preferences to allow the slider to go higher than the default. Open VLC and go to Tools > Preferences. At the bottom left, under "Show settings," select All.

In the left sidebar, navigate to Interface > Main interfaces > Qt.

On the right pane, scroll down to find Maximum volume displayed.

Change this value to 300 (the maximum supported software limit). Click Save and Restart VLC. 2. Alternatives to Mimic "400%" Boost

If 300% isn't loud enough, you can use these methods to further amplify quiet files:

Audio Effects (Compressor/Equalizer): Go to Tools > Effects and Filters > Audio Effects. Enable the Equalizer and push all sliders up, or use the Compressor to increase the "Makeup Gain," which boosts the overall volume floor.

Normalize Volume: In Preferences > Audio, check Normalize volume to: and set it to a higher value (e.g., 2.0 or 3.0).

System-Wide Boost: Use third-party software like Equalizer APO or Boom 3D to add a secondary layer of amplification on top of VLC. ⚠ Important Safety Note

VLC achieves these high volumes through digital gain (multiplying the bits of the audio signal).

Distortion: Pushing the volume this high often leads to "clipping," where the audio waveform is flattened, causing crackling or muffled sound.

Hardware Risk: While VLC's developers state the software won't directly "break" speakers, the physical vibrations from sustained, distorted high-volume audio can eventually damage lower-quality speaker diaphragms.

Here’s a useful, practical review of using VLC Media Player at 400% volume (i.e., 4× normal playback level). Look at the volume icon (the speaker) at

Final verdict

400% volume is a “break glass in emergency” tool – great for rescuing a super-quiet file, but not for daily listening. Keep it at 150–200% max unless you absolutely need more and don’t mind degraded audio quality.

Score: ★★★☆☆ (3/5 – powerful but distortion-prone)

VLC Media Player's "volume 400%" Easter egg / controversy — short interesting story:

In the mid-2000s VLC added a feature letting users boost playback volume up to 200% (and later 300% and even 400%) above the original audio amplitude. That capability came from VLC's software-based digital gain: instead of relying on the OS or hardware mixer, VLC could multiply PCM samples before sending them to the audio output. For quiet files this was useful; for loud files it could clip and distort—but many users loved the ability to crank output well beyond system limits.

What made "400%" memorable wasn't just the technical tweak but the culture around it. On forums and early social media, people treated "VLC 400%" like a memeified power-up: screenshots captioned "VLC 400%: for when you want to summon the gods" and jokes about using it to "wake the dead" circulated. Some users shared dramatic before/after clips showing tiny, inaudible recordings suddenly blasting at full volume (often with heavy distortion), and YouTube reaction videos popped up where viewers pretended horror or awe.

There were a few real-world consequences that added to the lore. Several users permanently surprised themselves or others by forgetting their speakers/headphones weren't rated for that gain—blown earpieces, startled pets, and one documented case of a laptop speaker grill being damaged by distortion at extreme gain. Audiophiles debated whether software gain was acceptable practice; VLC developers pointed out the feature is useful when original recordings are low-level and that users should apply proper gain staging for high-quality results.

Over time VLC tempered default UI behavior (preventing accidental jumps to extreme gain) and added warnings about clipping. But "VLC 400%" remains a geek-culture anecdote: a tiny, user-empowering feature that spawned memes, mishaps, and a debate about the line between handy tools and dangerous power.

If you want, I can:

Summarize how VLC implements software gain (brief technical explanation).
Show how to safely boost quiet audio in VLC without clipping.
Find notable forum threads or videos about "VLC 400%".

VLC Media Player is well-known for its ability to boost volume beyond the standard 100%—a feature that has become a staple for users trying to hear quiet recordings or maximize their laptop speakers. While the interface default typically caps at , you can configure it to go even higher. Increasing Maximum Volume to 300%

In modern versions of VLC, you can manually adjust the "Maximum Volume" setting through the advanced preferences. Preferences At the bottom-left, under "Show settings," select Navigate to Main interfaces Scroll down to Maximum Volume displayed and change the value to and restart VLC to apply the changes. Reaching 400% via the Scroll Wheel

Interestingly, many users have discovered that they can push the volume even further by using the mouse scroll wheel. While the slider might be visually limited, hovering your mouse over the video and scrolling up can sometimes boost the volume up to in certain versions. How Software Amplification Works VLC achieves these high volumes through software amplification

(gain). Instead of increasing the physical power of your speakers, it multiplies the digital values of the audio samples. How to Increase VLC Media Player Volume Upto 300%? 1 Jan 2020 —

To achieve a volume level of in VLC Media Player, you can use built-in keyboard and mouse shortcuts , as the standard volume slider is typically capped at How to Reach 400% Volume

While the visual slider may stop earlier, you can force the volume higher using these methods: Mouse Scroll

: Hover your mouse anywhere over the video screen and scroll the mouse wheel up

. The volume percentage displayed in the top-right corner will continue to climb up to 400%. Keyboard Shortcut : Hold the key and press the

key repeatedly to boost the volume in small increments until it reaches the 400% limit. Adjusting the Maximum Volume Slider

If you want the actual volume slider in the interface to go higher than its default (usually 125%), you can adjust the "Maximum Volume" setting: Preferences At the bottom left, under Show settings Navigate to Main interfaces Scroll to the bottom of the right-hand panel to find Maximum volume displayed

Enter a value (many modern versions of VLC cap this UI setting at

, though the shortcuts mentioned above can still push it further). restart VLC for the changes to take effect. ⚠️ Safety Note:

Boosting volume above 100% uses digital amplification, which can cause audio distortion and potentially damage laptop speakers if used at extreme levels for long periods. Compressor in VLC to improve sound clarity at these higher volumes?

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

Vlc Media Player Volume 400 -

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

Vlc Media Player Volume 400 -

3.4. Chaining Multiple Volume Filters

Method 2: The Graphical Slider (Visual Control)

Part 7: The Verdict – Is 400% a Gimmick of a Godsend?

Final verdict

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: