Graphical code tutorial on how to export excel tables in the YII2 framework-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Graphical code tutorial on how to export excel tables in the YII2 framework

黄舟

Jul 22, 2017 pm 03:01 PM

excel yii2 how

Recently I have been studying the Yii framework of PHP and I like it very much. When I encountered the problem of exporting Excel, I studied it and came up with the following article. This article mainly introduces you to the export of excel tables in the YII2 framework. The information is introduced in great detail through sample code. Friends in need can refer to it. Let’s take a look together.

Preface

The import and export of tables is a function we often encounter in daily development, and I happened to do it in a recent project Let’s talk about the table output function, and I have done it before when using TP, so I thought I would take advantage of this opportunity to sort it out, so that it can be conveniently used when needed in the future, or for friends who need it for reference and study. I won’t say anything else below. Enough to say, let’s take a look at the detailed introduction:

This article is developed based on the YII2 framework. Different frameworks may need to be changed

1. Ordinary excel format Table output

First is the most common table exported in .xls format. First, let’s take a look at the display effect of the table on the website

Here you can see that the entire table has a total of 7 columns. Let’s look at the implementation of the code.

1.controller file

//导出统计

public function actionStatistics(){
 //设置内存
 ini_set("memory_limit", "2048M");
 set_time_limit(0);

 //获取用户ID
 $id = Yii::$app->user->identity->getId();

 //去用户表获取用户信息
 $user = Employee::find()->where([&#39;id&#39;=>$id])->one();

 //获取传过来的信息（时间，公司ID之类的，根据需要查询资料生成表格）
 $params = Yii::$app->request->get();
 $objectPHPExcel = new \PHPExcel();

 //设置表格头的输出
 $objectPHPExcel->setActiveSheetIndex()->setCellValue(&#39;A1&#39;, &#39;代理公司&#39;);
 $objectPHPExcel->setActiveSheetIndex()->setCellValue(&#39;B1&#39;, &#39;收入&#39;);
 $objectPHPExcel->setActiveSheetIndex()->setCellValue(&#39;C1&#39;, &#39;成本&#39;);
 $objectPHPExcel->setActiveSheetIndex()->setCellValue(&#39;D1&#39;, &#39;稿件数&#39;);
 $objectPHPExcel->setActiveSheetIndex()->setCellValue(&#39;E1&#39;, &#39;毛利（收入-成本）&#39;);
 $objectPHPExcel->setActiveSheetIndex()->setCellValue(&#39;F1&#39;, &#39;毛利率（毛利/收入）*100%&#39;);
 $objectPHPExcel->setActiveSheetIndex()->setCellValue(&#39;G1&#39;, &#39;ARPU值&#39;);

 //跳转到recharge这个model文件的statistics方法去处理数据
 $data = Recharge::statistics($params);

 //指定开始输出数据的行数
 $n = 2;
 foreach ($data as $v){
 $objectPHPExcel->getActiveSheet()->setCellValue(&#39;A&#39;.($n) ,$v[&#39;company_name&#39;]);
 $objectPHPExcel->getActiveSheet()->setCellValue(&#39;B&#39;.($n) ,$v[&#39;company_cost&#39;]);
 $objectPHPExcel->getActiveSheet()->setCellValue(&#39;C&#39;.($n) ,$v[&#39;cost&#39;]);
 $objectPHPExcel->getActiveSheet()->setCellValue(&#39;D&#39;.($n) ,$v[&#39;num&#39;]);
 $objectPHPExcel->getActiveSheet()->setCellValue(&#39;E&#39;.($n) ,$v[&#39;gross_margin&#39;]);
 $objectPHPExcel->getActiveSheet()->setCellValue(&#39;F&#39;.($n) ,$v[&#39;gross_profit_rate&#39;]);
 $objectPHPExcel->getActiveSheet()->setCellValue(&#39;G&#39;.($n) ,$v[&#39;arpu&#39;]);
 $n = $n +1;
 }
 ob_end_clean();
 ob_start();
 header(&#39;Content-Type : application/vnd.ms-excel&#39;);

 //设置输出文件名及格式
 header(&#39;Content-Disposition:attachment;filename="代理公司统计&#39;.date("YmdHis").&#39;.xls"&#39;);

 //导出.xls格式的话使用Excel5,若是想导出.xlsx需要使用Excel2007
 $objWriter= \PHPExcel_IOFactory::createWriter($objectPHPExcel,&#39;Excel5&#39;);
 $objWriter->save(&#39;php://output&#39;);
 ob_end_flush();

 //清空数据缓存
 unset($data);
}

Copy after login

2.model file

 <?php
 namespace app\models;//model层的命名空间
 //注意要引用yii的arrayhelper
 use yii\helpers\ArrayHelper;
 use Yii;
 class Recharge extends \yii\db\ActiveRecord
 {
 //excel一次导出条数
 const EXCEL_SIZE = 10000;
 
 //统计导出
 public static function statistics($params){

 //导出时间条件
 if(empty($params[&#39;min&#39;])){
 $date_max = date("Y-m-d",strtotime("-1 day"));
 $date_min = date("Y-m-d",strtotime("-31 day"));
 }else{
 $date_min = $params[&#39;min&#39;];
 $date_max = $params[&#39;max&#39;];
 }
 $where = &#39;&#39;;
 $where .= &#39;(`issue_date` BETWEEN &#39;.&#39;\&#39;&#39;.$date_min.&#39;\&#39;&#39;.&#39; AND &#39;.&#39;\&#39;&#39;.$date_max.&#39;\&#39;)&#39;;

 //查找指定数据
 $sql = &#39;select
 article.company_id,
 article.cost,
 article.company_cost
 from article WHERE article.status=2 AND &#39;.$where;
 $article = Article::findBySql($sql)->asArray()->all();
 $article = ArrayHelper::index($article,null,&#39;company_id&#39;);
 $companys = [];

 foreach ($article as $key=>$v){
 if(empty($key)){
 continue;
 }else{
 $number = count($v);
 $company = Company::find()->where([&#39;id&#39;=>$key])->select(&#39;name&#39;)->one();
 $company_name = $company[&#39;name&#39;];
 $cost = 0;
 $company_cost = 0;
 foreach ($v as $n){
 $cost += $n[&#39;cost&#39;];
 $company_cost += $n[&#39;company_cost&#39;];
 }
 if($company_cost == 0){
 $company_cost =1;
 }

 //这里注意，数据的存储顺序要和输出的表格里的顺序一样
 $companys[] = [
 //公司名
 &#39;company_name&#39; => $company_name,

 //收入
 &#39;company_cost&#39; => $company_cost,

 //成本
 &#39;cost&#39; => $cost,

 //稿件数
 &#39;num&#39; => $number,

 //毛利
 &#39;gross_margin&#39; => $company_cost-$cost,

 //毛利率
 &#39;gross_profit_rate&#39; => round(($company_cost-$cost)/$company_cost*100,2).&#39;%&#39;,

 //ARPU值
 &#39;arpu&#39; => round($company_cost/$number,2),
 ];
 }
 }
 return $companys;
 }
}

Copy after login

The final export effect (the cell size has been adjusted after exporting) can be seen to be basically the same as what is displayed on the web page.

2. Big data table export

At this time, the boss said, we can’t Only look at the total data, it is best to export the detailed data as well. Now that the boss has spoken, do it. I still followed the first method, but the result prompted me that php crashed. When I tried again, I found that the number of written bytes exceeded. Open the php configuration file php.ini

memory_limit = 128M

Copy after login

and find that the default memory has been given to 128M, which should be enough. So I opened the database and took a look, oh!

Querying and exporting nearly 830,000 pieces of data will cause problems! What should I do, so I Googled it and found that for exporting big data (more than 20,000 items), it is best to export it in .csv format. No nonsense, just go to the code

1.controller file

//导出清单

public function actionInventory(){
 ini_set("memory_limit", "2048M");
 set_time_limit(0);
 $id = Yii::$app->user->identity->getId();
 $user = Employee::find()->where([&#39;id&#39;=>$id])->one();
 $params = Yii::$app->request->get();
 
 //类似的，跳转到recharge这个model文件里的inventory方法去处理数据
 $data = Recharge::inventory($params);
 
 //设置导出的文件名
 $fileName = iconv(&#39;utf-8&#39;, &#39;gbk&#39;, &#39;代理商统计清单&#39;.date("Y-m-d"));
 
 //设置表头
 $headlist = array(&#39;代理商&#39;,&#39;文章ID&#39;,&#39;文章标题&#39;,&#39;媒体&#39;,&#39;统计时间范围&#39;,&#39;状态&#39;,&#39;创建时间&#39;,&#39;审核时间&#39;,&#39;发稿时间&#39;,&#39;退稿时间&#39;,&#39;财务状态&#39;,&#39;成本&#39;,&#39;销售额&#39;,&#39;是否是预收款媒体类型&#39;,&#39;订单类别&#39;);
 header(&#39;Content-Type: application/vnd.ms-excel&#39;);
 
 //指明导出的格式
 header(&#39;Content-Disposition: attachment;filename="&#39;.$fileName.&#39;.csv"&#39;);
 header(&#39;Cache-Control: max-age=0&#39;);
 
 //打开PHP文件句柄,php://output 表示直接输出到浏览器
 $fp = fopen(&#39;php://output&#39;, &#39;a&#39;);
 
 //输出Excel列名信息
 foreach ($headlist as $key => $value) {
 //CSV的Excel支持GBK编码，一定要转换，否则乱码
 $headlist[$key] = iconv(&#39;utf-8&#39;, &#39;gbk&#39;, $value);
 }
 
 //将数据通过fputcsv写到文件句柄
 fputcsv($fp, $headlist);
 
 //每隔$limit行，刷新一下输出buffer，不要太大，也不要太小
 $limit = 100000;
 
 //逐行取出数据，不浪费内存
 foreach ($data as $k => $v) {
 //刷新一下输出buffer，防止由于数据过多造成问题
 if ($k % $limit == 0 && $k!=0) {
 ob_flush();
 flush();
 }
 $row = $data[$k];
 foreach ($row as $key => $value) {
 $row[$key] = iconv(&#39;utf-8&#39;, &#39;gbk&#39;, $value);
 }
 fputcsv($fp, $row);
 }
}

Copy after login

2.model file (because this part I have too much to process, so I only selected part of the code). In the part of querying data, because there is a lot of data to be checked, you can take a look at the article I wrote before about Mysql big data query processing

//List export

public static function inventory($params){
 //统计时间范围
 if(!empty($params[&#39;min&#39;]) && !empty($params[&#39;max&#39;])){
 $ti = strtotime($params[&#39;max&#39;])+3600*24;
 $max = date(&#39;Y-m-d&#39;,$ti);
 $time = $params[&#39;min&#39;].&#39;-&#39;.$params[&#39;max&#39;];
 $date_min = $params[&#39;min&#39;];
 $date_max = $max;
 }else{
 $date_max = date(&#39;Y-m-d&#39;);
 $date_min = date(&#39;Y-m-d&#39;,strtotime("-31 day"));
 $time = $date_min.&#39;-&#39;.$date_max;
 }
 //查询数据
 if($params[&#39;state&#39;] == 1){
 $where = &#39;&#39;;
 $where .= &#39; AND (`issue_date` BETWEEN &#39;.&#39;\&#39;&#39;.$date_min.&#39;\&#39;&#39;.&#39; AND &#39;.&#39;\&#39;&#39;.$date_max.&#39;\&#39;)&#39;;
 $map = &#39;select
  company.name,
  article.id,
  article.title,
  media.media_name,
  article.status,
  article.created,
  article.audit_at,
  article.issue_date,
  article.back_date,
  article.finance_status,
  article.cost,
  article.company_cost,
  media.is_advance
  from article
  LEFT JOIN custom_package ON custom_package.id = article.custom_package_id
  LEFT JOIN `order` ON custom_package.order_id = `order`.`id`
  LEFT JOIN company ON company.id = article.company_id
  LEFT JOIN media ON media.id = article.media_id
  where article.status=2 and `order`.package=0&#39;.$where;
 //查找的第一部分数据，使用asArray方法可以使我们查找的结果直接形成数组的形式，没有其他多余的数据占空间（注意：我这里查找分三部分是因为我要查三种不同的数据）
 $list1 = Article::findBySql($map)->asArray()->all();
 $where2 = &#39;&#39;;
 $where2 .= &#39; AND (`issue_date` BETWEEN &#39;.&#39;\&#39;&#39;.$date_min.&#39;\&#39;&#39;.&#39; AND &#39;.&#39;\&#39;&#39;.$date_max.&#39;\&#39;)&#39;;
 $where2 .= &#39; AND (`back_date` > \&#39;&#39;.$date_max.&#39;\&#39;)&#39;;
 $map2 = &#39;select
  company.name,
  article.id,
  article.title,
  media.media_name,
  article.status,
  article.created,
  article.audit_at,
  article.issue_date,
  article.back_date,
  article.finance_status,
  article.cost,
  article.company_cost,
  media.is_advance
  from article
  LEFT JOIN custom_package ON custom_package.id = article.custom_package_id
  LEFT JOIN `order` ON custom_package.order_id = `order`.`id`
  LEFT JOIN company ON company.id = article.company_id
  LEFT JOIN media ON media.id = article.media_id
  where article.status=3 and `order`.package=0 &#39;.$where2;
 //查找的第二部分数据
 $list2 = Article::findBySql($map2)->asArray()->all();
 $where3 = &#39;&#39;;
 $where3 .= &#39; AND (`issue_date` BETWEEN &#39;.&#39;\&#39;&#39;.$date_min.&#39;\&#39;&#39;.&#39; AND &#39;.&#39;\&#39;&#39;.$date_max.&#39;\&#39;)&#39;;
 $map3 = &#39;select
  company.name,
  article.id,
  article.title,
  media.media_name,
  article.status,
  article.created,
  article.audit_at,
  article.issue_date,
  article.back_date,
  article.finance_status,
  article.cost,
  article.company_cost,
  media.is_advance
  from article
  LEFT JOIN custom_package ON custom_package.id = article.custom_package_id
  LEFT JOIN `order` ON custom_package.order_id = `order`.`id`
  LEFT JOIN company ON company.id = article.company_id
  LEFT JOIN media ON media.id = article.media_id
  where article.status=5 &#39;.$where3;
 //查找的第三部分数据
 $list3 = Article::findBySql($map3)->asArray()->all();
 $list4 = ArrayHelper::merge($list1,$list2);
 $list = ArrayHelper::merge($list4,$list3);
 }
 //把结果按照显示顺序存到返回的数组中
 if(!empty($list)){
 foreach ($list as $key => $value){
 //代理公司
 $inventory[$key][&#39;company_name&#39;] = $value[&#39;name&#39;];
 //文章ID
 $inventory[$key][&#39;id&#39;] = $value[&#39;id&#39;];
 //文章标题
 $inventory[$key][&#39;title&#39;] = $value[&#39;title&#39;];
 //媒体
 $inventory[$key][&#39;media&#39;] = $value[&#39;media_name&#39;];
 //统计时间
 $inventory[$key][&#39;time&#39;] = $time;
 //状态
 switch($value[&#39;status&#39;]){
 case 2:
  $inventory[$key][&#39;status&#39;] = &#39;已发布&#39;;
  break;
 case 3:
  $inventory[$key][&#39;status&#39;] = &#39;已退稿&#39;;
  break;
 case 5:
  $inventory[$key][&#39;status&#39;] = &#39;异常稿件&#39;;
  break;
 }
 //创建时间
 $inventory[$key][&#39;created&#39;] = $value[&#39;created&#39;];
 //审核时间
 $inventory[$key][&#39;audit&#39;] = $value[&#39;audit_at&#39;];
 //发稿时间
 $inventory[$key][&#39;issue_date&#39;] = $value[&#39;issue_date&#39;];
 //退稿时间
 $inventory[$key][&#39;back_date&#39;] = $value[&#39;back_date&#39;];
 //财务状态
 switch($value[&#39;finance_status&#39;]){
 case 0:
  $inventory[$key][&#39;finance_status&#39;] = &#39;未到结算期&#39;;
  break;
 case 1:
  $inventory[$key][&#39;finance_status&#39;] = &#39;可结算&#39;;
  break;
 case 2:
  $inventory[$key][&#39;finance_status&#39;] = &#39;资源审批中&#39;;
  break;
 case 3:
  $inventory[$key][&#39;finance_status&#39;] = &#39;财务审批中&#39;;
  break;
 case 4:
  $inventory[$key][&#39;finance_status&#39;] = &#39;已结款&#39;;
  break;
 case 5:
  $inventory[$key][&#39;finance_status&#39;] = &#39;未通过&#39;;
  break;
 case 6:
  $inventory[$key][&#39;finance_status&#39;] = &#39;财务已审批&#39;;
  break;
 }
 //成本
 $inventory[$key][&#39;cost&#39;] = $value[&#39;cost&#39;];
 //销售额
 $inventory[$key][&#39;company_cost&#39;] = $value[&#39;company_cost&#39;];
 //是否是预售
 switch($value[&#39;is_advance&#39;]){
 case 0:
  $inventory[$key][&#39;is_advance&#39;] = &#39;否&#39;;
  break;
 case 1:
  $inventory[$key][&#39;is_advance&#39;] = &#39;是&#39;;
  break;
 case 2:
  $inventory[$key][&#39;is_advance&#39;] = &#39;合同&#39;;
  break;
 }
 //订单类别
 switch($params[&#39;state&#39;]){
 case 1:
  $inventory[$key][&#39;order_type&#39;] = &#39;时间区间无退稿完成订单&#39;;
  break;
 case 2:
  $inventory[$key][&#39;order_type&#39;] = &#39;时间区间发布前退稿订单&#39;;
  break;
 case 3:
  $inventory[$key][&#39;order_type&#39;] = &#39;时间区间发布后时间区间退稿订单&#39;;
  break;
 case 4:
  $inventory[$key][&#39;order_type&#39;] = &#39;时间区间之前发布时间区间内退稿订单&#39;;
  break;
 case 5:
  $inventory[$key][&#39;order_type&#39;] = &#39;异常订单&#39;;
  break;
 }
 }
 }else{
 $inventory[0][&#39;company_name&#39;] = &#39;无数据导出&#39;;
 }
 return $inventory;
}

Copy after login

3. Export results

Number of exports

#Exported files

Basically ensure that the entire process is completed within 2~4 seconds

3. Merge cells

The boss noticed that you did a good job and asked you to export the recharge statistics by the way. , think about it, I am someone who has dealt with so much data, can’t it be done in minutes? Come on, show me the prototype

Pfft, I’ve said it all, let’s do it. While doing it, I discovered that this export is mainly to solve the problem of cell merging. After checking the information, I found that PHP itself cannot achieve cell merging, so I plan to achieve it through phpexcel

If you use PHPExcel, the basic operation is like this (merge A1 to E1)

$objPHPExcel->getActiveSheet()->mergeCells(&#39;A1:E1&#39;);
// 表格填充内容
$objPHPExcel->getActiveSheet()->setCellValue(&#39;A1&#39;,&#39;The quick brown fox.&#39;);

Copy after login

Result

Or like this (merge A1 to E4)

$objPHPExcel->getActiveSheet()->mergeCells(&#39;A1:E4&#39;);
$objPHPExcel->getActiveSheet()->setCellValue(&#39;A1&#39;,&#39;The quick brown fox.&#39;);

Copy after login

Result

#This does not meet my requirements. First of all, it is merged one by one. Secondly, the type of the recharge amount I want to display will change. No. Maybe hard-coded and then changed every time. So this method was abandoned.

Later, with the help of my friends, I tried to use html to transfer excel.

1. Method file (because I have to execute it regularly every day , so it is not written to the controller layer)

public function actionExcelRechargeStatistics(){

 //先定义一个excel文件
 $filename = date(&#39;【充值统计表】(&#39;.date(&#39;Y-m-d&#39;).&#39;导出)&#39;).".xls";
 header("Content-Type: application/vnd.ms-execl");
 header("Content-Type: application/vnd.ms-excel; charset=utf-8");
 header("Content-Disposition: attachment; filename=$filename");
 header("Pragma: no-cache");
 header("Expires: 0");
 //时间条件
 if(empty($params[&#39;min&#39;])){
 $time = date(&#39;Y-m-d&#39;,strtotime("+1 day"));
 $where = &#39; created < \&#39; &#39;.$time.&#39;\&#39;&#39;;
 }else{
 $time = $params[&#39;min&#39;]+3600*24;
 $time_end = $params[&#39;max&#39;]+3600*24;
 $where = &#39; created <= \&#39; &#39;.$time_end.&#39;\&#39; AND created >= \&#39;&#39;.$time.&#39;\&#39; &#39;;
 }
 //充值类型列表
 $recharge_type = Recharge::find()->asArray()->all();
 if(empty($recharge_type)){
 $rechargelist[0]= &#39;&#39;;
 }else{
 $rechargelist = ArrayHelper::map($recharge_type,&#39;id&#39;,&#39;recharge_name&#39;);
 }
 $rechargelist1 = $rechargelist;
 $count = count($rechargelist1);
 //使用html语句生成显示的格式
 $excel_content = &#39;<meta http-equiv="content-type" content="application/ms-excel; charset=utf-8"/>&#39;;
 $excel_content .= &#39;<table border="1" style="font-size:14px;">&#39;;
 $excel_content .= &#39;<thead>
   <tr>
   <th rowspan="2">ID</th>
   <th rowspan="2">公司名称</th>
   <th colspan=&#39;.$count.&#39;>充值金额</th>
   <th rowspan="2">充值大小</th>
   <th rowspan="2">实际消费</th>
   <th rowspan="2">当前余额</th>
   </tr>
   <tr>
  &#39;;
 foreach ($rechargelist1 as $v => $t){
 $excel_content .= &#39;<th colspan="1">&#39;.$t.&#39;</th>&#39;;
 }
 $excel_content .= &#39;</tr>
  </thead>&#39;;
 //查找最新的固化数据
 $search = RechargeStatistics::find()->where($where)->asArray()->all();
 if(!empty($search)){
 foreach ($search as $key => $value){
 $search[$key][&#39;recharge&#39;] = unserialize($value[&#39;recharge&#39;]);
 }
 }
 //html语句填充数据
 if(empty($search)){
 }else{
 foreach ($search as $k) {
 $excel_content .= &#39;<td>&#39;.$k[&#39;company_id&#39;].&#39;</td>&#39;;
 $excel_content .= &#39;<td>&#39;.$k[&#39;company_name&#39;].&#39;</td>&#39;;
 foreach ($rechargelist1 as $v=>$t){
 $price = 0;
 foreach ($k[&#39;recharge&#39;] as $q=>$w){
  if($w[&#39;recharge_id&#39;] == $v){
  $price = $w[&#39;price&#39;];
  break;
  }
 }
 $excel_content .= &#39;<td>&#39;.$price.&#39;</td>&#39;;
 }
 $excel_content .= &#39;<td>&#39;.$k[&#39;total&#39;].&#39;</td>&#39;;
 $excel_content .= &#39;<td>&#39;.$k[&#39;consume&#39;].&#39;</td>&#39;;
 $excel_content .= &#39;<td>&#39;.($k[&#39;total&#39;]-$k[&#39;consume&#39;]).&#39;</td></tr>&#39;;
 }
 }
 $excel_content .= &#39;</table>&#39;;
 echo $excel_content;
 die;
}

Copy after login

2.结果

到这里基本就完成所有的任务了！

总结

The above is the detailed content of Graphical code tutorial on how to export excel tables in the YII2 framework. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

How to fix KB5055523 fails to install in Windows 11?

4 weeks ago By DDD

How to fix KB5055518 fails to install in Windows 10?

4 weeks ago By DDD

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

How to fix KB5055612 fails to install in Windows 10?

3 weeks ago By DDD

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1664

CakePHP Tutorial

1421

Laravel Tutorial

1315

PHP Tutorial

1266

C# Tutorial

1239

Related knowledge

What should I do if the frame line disappears when printing in Excel? Mar 21, 2024 am 09:50 AM

If when opening a file that needs to be printed, we will find that the table frame line has disappeared for some reason in the print preview. When encountering such a situation, we must deal with it in time. If this also appears in your print file If you have questions like this, then join the editor to learn the following course: What should I do if the frame line disappears when printing a table in Excel? 1. Open a file that needs to be printed, as shown in the figure below. 2. Select all required content areas, as shown in the figure below. 3. Right-click the mouse and select the "Format Cells" option, as shown in the figure below. 4. Click the “Border” option at the top of the window, as shown in the figure below. 5. Select the thin solid line pattern in the line style on the left, as shown in the figure below. 6. Select "Outer Border"

How to filter more than 3 keywords at the same time in excel Mar 21, 2024 pm 03:16 PM

Excel is often used to process data in daily office work, and it is often necessary to use the "filter" function. When we choose to perform "filtering" in Excel, we can only filter up to two conditions for the same column. So, do you know how to filter more than 3 keywords at the same time in Excel? Next, let me demonstrate it to you. The first method is to gradually add the conditions to the filter. If you want to filter out three qualifying details at the same time, you first need to filter out one of them step by step. At the beginning, you can first filter out employees with the surname "Wang" based on the conditions. Then click [OK], and then check [Add current selection to filter] in the filter results. The steps are as follows. Similarly, perform filtering separately again

How to change excel table compatibility mode to normal mode Mar 20, 2024 pm 08:01 PM

In our daily work and study, we copy Excel files from others, open them to add content or re-edit them, and then save them. Sometimes a compatibility check dialog box will appear, which is very troublesome. I don’t know Excel software. , can it be changed to normal mode? So below, the editor will bring you detailed steps to solve this problem, let us learn together. Finally, be sure to remember to save it. 1. Open a worksheet and display an additional compatibility mode in the name of the worksheet, as shown in the figure. 2. In this worksheet, after modifying the content and saving it, the dialog box of the compatibility checker always pops up. It is very troublesome to see this page, as shown in the figure. 3. Click the Office button, click Save As, and then

How to type subscript in excel Mar 20, 2024 am 11:31 AM

eWe often use Excel to make some data tables and the like. Sometimes when entering parameter values, we need to superscript or subscript a certain number. For example, mathematical formulas are often used. So how do you type the subscript in Excel? ?Let’s take a look at the detailed steps: 1. Superscript method: 1. First, enter a3 (3 is superscript) in Excel. 2. Select the number "3", right-click and select "Format Cells". 3. Click "Superscript" and then "OK". 4. Look, the effect is like this. 2. Subscript method: 1. Similar to the superscript setting method, enter "ln310" (3 is the subscript) in the cell, select the number "3", right-click and select "Format Cells". 2. Check "Subscript" and click "OK"

How to set superscript in excel Mar 20, 2024 pm 04:30 PM

When processing data, sometimes we encounter data that contains various symbols such as multiples, temperatures, etc. Do you know how to set superscripts in Excel? When we use Excel to process data, if we do not set superscripts, it will make it more troublesome to enter a lot of our data. Today, the editor will bring you the specific setting method of excel superscript. 1. First, let us open the Microsoft Office Excel document on the desktop and select the text that needs to be modified into superscript, as shown in the figure. 2. Then, right-click and select the "Format Cells" option in the menu that appears after clicking, as shown in the figure. 3. Next, in the “Format Cells” dialog box that pops up automatically

How to use the iif function in excel Mar 20, 2024 pm 06:10 PM

Most users use Excel to process table data. In fact, Excel also has a VBA program. Apart from experts, not many users have used this function. The iif function is often used when writing in VBA. It is actually the same as if The functions of the functions are similar. Let me introduce to you the usage of the iif function. There are iif functions in SQL statements and VBA code in Excel. The iif function is similar to the IF function in the excel worksheet. It performs true and false value judgment and returns different results based on the logically calculated true and false values. IF function usage is (condition, yes, no). IF statement and IIF function in VBA. The former IF statement is a control statement that can execute different statements according to conditions. The latter

Where to set excel reading mode Mar 21, 2024 am 08:40 AM

In the study of software, we are accustomed to using excel, not only because it is convenient, but also because it can meet a variety of formats needed in actual work, and excel is very flexible to use, and there is a mode that is convenient for reading. Today I brought For everyone: where to set the excel reading mode. 1. Turn on the computer, then open the Excel application and find the target data. 2. There are two ways to set the reading mode in Excel. The first one: In Excel, there are a large number of convenient processing methods distributed in the Excel layout. In the lower right corner of Excel, there is a shortcut to set the reading mode. Find the pattern of the cross mark and click it to enter the reading mode. There is a small three-dimensional mark on the right side of the cross mark.

How to insert excel icons into PPT slides Mar 26, 2024 pm 05:40 PM

1. Open the PPT and turn the page to the page where you need to insert the excel icon. Click the Insert tab. 2. Click [Object]. 3. The following dialog box will pop up. 4. Click [Create from file] and click [Browse]. 5. Select the excel table to be inserted. 6. Click OK and the following page will pop up. 7. Check [Show as icon]. 8. Click OK.

See all articles