PHP Libraries

Other libraries

PHP class to export excel table

Other libraries

Get it now

PHP class to export excel table

<?php
  public function setEncode($incode,$outcode){
    $this->inEncode=$incode;
    $this->outEncode=$outcode;
  }
  public function setTitle($titlearr){
    $title="";
    foreach($titlearr as $v){
      if($this->inEncode!=$this->outEncode){
        $title.=iconv($this->inEncode,$this->outEncode,$v)."\t";
      }
      else{
        $title.=$v."\t";
      }
    }
    $title.="\n";
    return $title;
  }

Usage method

$excel=new Excel();

Set encoding:

$excel->setEncode("utf-8" ,"gb2312"); //If you don't want to transcode, just write the same parameters, for example $excel->setEncode("utf-8","utf-8");

settings Title bar

$titlearr=array("a","b","c","d");

Set content bar

$contentarr=array(

1=>array("ab","ac","ad","ae"),

2=>array( "abc","acc","adc","aec"),

3=>array("abd","acd","add","aed"),

4=>array("abe","ace","ade","aee"),

);

$excel->getExcel($titlearr,$ contentarr,"abc");

Disclaimer

All resources on this site are contributed by netizens or reprinted by major download sites. Please check the integrity of the software yourself! All resources on this site are for learning reference only. Please do not use them for commercial purposes. Otherwise, you will be responsible for all consequences! If there is any infringement, please contact us to delete it. Contact information: admin@php.cn

How to Export MySQL Data to Separate Excel Cells using PHP?

25Nov2024

Retrieving MySQL Data in Separate Excel Cells using PHPYour original PHP script combines all text values into a single Excel cell, conflicting...

How Do I Link Static Libraries That Depend on Other Static Libraries?

13Dec2024

Linking Static Libraries to Other Static Libraries: A Comprehensive ApproachStatic libraries provide a convenient mechanism to package reusable...

How to export Excel file and set column width in native PHP?

31Mar2025

When exporting Excel files using native PHP, you often encounter the problem of how to set the column width. This article will focus on "How to export Excel files in native PHP and...