Tutorial 08: How to set header and footer in PHP

E-stim 2b Audio - Files

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

E-stim 2b Audio - Files

The E-Stim Systems 2B without audio files is like a sports car driving in first gear. It works—it’s safe, it’s reliable—but you are missing the thrill of the open road. By exploring e-stim 2B audio files, you gain access to an infinite library of sensations: from the whisper-soft tease of a ghost to the overwhelming, involuntary climax of a milking machine.

Start with the free community packs on Social Stim. Invest in a tri-phase cable. And always, always prioritize safety over intensity. Once you feel your first perfectly synchronized stereo stroking pattern—timed to a sound file and moving in a way no built-in mode can replicate—you will understand why dedicated 2B users call audio mode "the only mode that matters."

Now plug in, press play, and let the waveforms take control.

Disclaimer: This article is for educational purposes only. E-stim should never be used above the waist, with heart conditions, or during pregnancy. Always follow manufacturer guidelines for the E-Stim Systems 2B.

The Ultimate Guide to E-Stim 2B Audio Files: Taking Your Experience to the Next Level

If you’ve dipped your toes into the world of electro-stimulation (e-stim), you’ve likely heard of the E-Stim Systems 2B. It is arguably the most popular power box on the market, known for its versatility, safety, and—most importantly—its Audio Mode.

While the built-in programs on the 2B are fantastic, the ability to control the pulses using sound opens up a whole new world of sensation. In this guide, we’ll break down what e-stim 2B audio files are, how they work, and how you can get the most out of them. What are E-Stim 2B Audio Files?

At its core, the E-Stim 2B has a "Stereo Stim" mode. When you connect the 2B to a phone, laptop, or tablet via a 3.5mm audio cable, the device translates sound waves into electrical pulses. Left Audio Channel: Controls Output A. Right Audio Channel: Controls Output B.

Standard music sounds "okay," but specialized 2B audio files are engineered specifically for the device. Instead of melodies, these files contain specific frequencies and rhythms designed to trigger rhythmic contractions, "thumping" sensations, or intense, sustained pulses. Why Use Audio Files Instead of Built-in Modes? e-stim 2b audio files

The 2B has great internal programs, but audio files offer three distinct advantages:

Complexity: Audio files can create patterns that are far more intricate than the onboard computer. Think of it like the difference between a metronome and a complex drum solo.

Synchronization: You can find files synced to videos (often called "PMV" or Power Movement Videos) or specific atmospheric soundscapes.

Hands-Free Variety: Once you hit play on a high-quality audio pack, you can sit back and enjoy a pre-programmed journey that changes intensity and style automatically. Types of 2B Audio Files

Not all audio files are created equal. Depending on your goals, you’ll usually encounter three types: 1. Pure Tones and Pulses

These are technical files. They might be a steady 425Hz tone (great for a "solid" feeling) or a rhythmic "pulse" that mimics a heartbeat. These are perfect for finding your specific "sweet spot." 2. "Sessions" or "Journeys"

These are longer files (10–30 minutes) designed to take you through a full experience. They usually start with a gentle warm-up, build into intense peaks, and finish with a cool-down period. 3. Reactive Music

Some creators take existing music and overlay "control tones" on top of it. This allows you to "feel" the beat of your favorite tracks through your electrodes. How to Set Up Your 2B for Audio To get the best results, follow these steps: The E-Stim Systems 2B without audio files is

The Cable: Use a high-quality 3.5mm to 3.5mm stereo cable. Connect your device's headphone jack to the "Audio" input on the 2B.

Volume Management: Set the volume on your phone/computer to about 70-80%. Use the physical knobs on the 2B to control the actual intensity. Note: Never start with the knobs turned up high.

Select "Audio" Mode: Switch your 2B to the "Stereo Stim" (Audio) mode.

Equalizer Settings: Ensure any "Bass Boost" or EQ settings on your music player are turned off. These can distort the signal and make the sensation feel muddy or unpredictable. Where to Find Quality Files

The e-stim community is incredibly active. You can find high-quality .mp3 or .wav files on:

E-Stim Systems Official Site: They offer a variety of free and paid loops.

Community Forums: Sites like the E-Stim Lab have user-generated content where enthusiasts share their custom-coded sessions.

Specialized Creators: There are "Stim-Designers" who create cinematic audio experiences specifically for the 2B. Safety First Disclaimer: This article is for educational purposes only

When playing with audio files, remember that digital files can have sudden spikes. Always test a new file at a low intensity first.

Use a dedicated player if possible so a sudden "low battery" notification or phone call doesn't send an unexpected jolt through the device.

Ensure your 2B is updated to the latest firmware to ensure the most accurate audio tracking. Conclusion

The E-Stim 2B is a powerhouse on its own, but using specialized audio files turns it into a customizable symphony of sensation. Whether you want a slow, rhythmic massage or an intense, high-frequency session, the right audio file makes all the difference.

The ecosystem of 2B audio files represents a fascinating democratization of haptic technology. There is no corporate library; instead, thousands of user-generated files are shared via Mega links, Dropbox folders, and private Discord servers. This is a living, open-source archive of human sensation design.

As of 2025, advances include multi-channel files (for the 2B’s optional accessory, the Estim Systems Roadster), synchronized video files (where a video’s on-screen action is encoded as a simultaneous audio track for the 2B), and even AI-generated files that learn a user’s preferences through reinforcement learning. The boundary between programmer, musician, and lover has dissolved into a single creative act: writing pleasure into raw binary.

The use of incorrectly produced audio files poses a risk of discomfort or tissue irritation.

Digital Clipping: If the source audio is distorted (clipping red line in the DAW), the resulting electrical signal will be jagged and harsh.

Verification: Always play a new audio file through speakers or headphones first to identify volume spikes, dropouts, or high-frequency noise before connecting it to the body.

Stereo Phasing: Ensure stereo files do not have phase cancellation issues, which can result in a weak signal or unpredictable field distribution.

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