English 中文(简体)
• 如何使用PHPExcel的加固功能
原标题:How to use concatenate function in PHPExcel
  • 时间:2012-01-11 11:44:10
  •  标签:
  • php
  • phpexcel
$objPHPExcel->getActiveSheet()->SetCellValue( L .CONCATENATE( A , C , D , E , F , G , H , I , J , K ), 0); );

谁能说明如何利用在“Secel”的加固功能?

问题回答

如果你在牢房中重写一个公式,那么你需要写上这个公式,因为你会写出一种Excel公式:

=CONCATENATE("A","C","D","E","F","G","H","I","J","K")

如果我读一下你试图正确做些什么的话。

$objPHPExcel->getActiveSheet()->SetCellValue( A1 , =CONCATENATE("A","C","D","E","F","G","H","I","J","K") ); 

http://www.ohchr.org。

解释你的含义:

$objPHPExcel->getActiveSheet()->SetCellValue( E .($i+$j), =CONCATENATE(A .($i+$j). ," ",D .($i+$j). ) ); 

如果i+$j = 5,那么这将写公式。

=CONCATENATE(A5," ",D5)

E5室

因此,如果A5号单元含有这种内容,

Hello

D5

世界

然后,E5室将显示价值。

Hello World





相关问题
Brute-force/DoS prevention in PHP [closed]

I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

定值美元

如何确认来自正确来源的数字。

Generating a drop down list of timezones with PHP

Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...

Text as watermarking in PHP

I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...

How does php cast boolean variables?

How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...

热门标签