<?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");
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
Related Article
How to Export MySQL Data to Separate Excel Cells using PHP?
25 Nov 2024
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?
13 Dec 2024
Linking Static Libraries to Other Static Libraries: A Comprehensive ApproachStatic libraries provide a convenient mechanism to package reusable...
How can I export MySQL data to Excel using PHP and ensure proper cell distribution?
25 Nov 2024
Exporting MySQL Data to Excel in PHPWhen exporting MySQL data to Excel, it's crucial to ensure that the data is properly distributed across...
How to Silence TensorFlow\'s Debugging Output?
28 Oct 2024
Suppression of Tensorflow Debugging OutputTensorflow prints extensive information about loaded libraries, found devices, and other debugging data...
How Does jQuery Simplify DOM Manipulation for Web Developers?
03 Jan 2025
Overflow: Hidden and Expansion of HeightjQuery distinguishes itself from other JavaScript libraries through its cross-platform compatibility and...
Which native Java image processing library is right for you?
30 Oct 2024
Native Java Image Processing Libraries for High-Quality ResultsAs you have encountered limitations with ImageMagick and JAI, let's explore other...
Hot Tools
PHP library for dependency injection containers
PHP library for dependency injection containers
A collection of 50 excellent classic PHP algorithms
Classic PHP algorithm, learn excellent ideas and expand your thinking
Small PHP library for optimizing images
Small PHP library for optimizing images