- 博客(9)
- 收藏
- 关注
RSS订阅原创 VBA - 粘贴为数值型
Private Sub PasteValue()'粘贴为数值型Application.ScreenUpdating = False '关闭屏幕刷新 '循环选择的可见区域 For Each r In Selection.SpecialCells(xlCellTypeVisible) ' 复制 -> 粘贴为数值型 r.Copy r.P
2017-03-26 16:42:26
14340
转载 VBA 分割求平均值
Function StrToArr(str As String, delimiter As String) As VariantDim ar, nar()If (Trim(str) = "") Then ReDim nar(0) StrToArr = nar GoTo EndREnd Ifar = Split(str, delimiter)ReDim nar(UBound
2017-02-28 13:53:22
1397
转载 YII 安装
composercomposer create-project yiisoft/yii2-app-advanced advanced 2.0.11归档init
2017-02-28 13:52:10
256
转载 YII2 返回文件
$response = Yii::$app->getResponse();$response->format = $response::FORMAT_RAW;$response->getHeaders()->set('Content-Type', 'application/vnd.ms-excel');$response->getHeaders()->set('Content-Dispositi
2017-02-28 00:44:33
867
转载 c# Blob Mysql
this.files = OTB( ds.Tables[0].Rows[0]["files"]) ;byte[] buff = ob as byte[];MemoryStream ms =new MemoryStream ();ms.Write(buff, 0, buff.Length);FileStream pFileStream = new FileStream(@"E:\3.docx",
2017-02-27 19:05:37
240
转载 YII查询
查询下拉菜单b1::find() ->leftJoin('b2', 'b1.`id`=b2.`id`') ->select(['b2.name','b1.id']) ->groupBy('b2.name') ->indexBy('id') //->asArray()//转数组 ->column(),查询所
2017-02-20 05:01:46
363
转载 php pjax JS自动刷新
php pjax JS自动刷新 time.php<?phpuse yii\widgets\Pjax;use yii\helpers\Html;Pjax::begin(['id' => 'comment']);$script = <<< JS$(document).ready(function() { var ts=setInterval(clock, 1000); fun
2017-02-18 01:25:31
448
转载 文章标题
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Wi
2016-07-03 14:21:56
168
转载 delegate
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using S
2016-07-03 03:51:20
180
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人