摘要：要从Excel 多个sheet内导出指定行为txt文件，懒得用C#了，写个VBA宏 1 Sub Export() 2 Dim FileName As Variant 3 Dim Sep As String 4 Dim StartSheet As Integer 5 ... 阅读全文
Tsql 获取服务器信息
2014-03-20 17:42 by 小sa, 285 阅读, 0 推荐, 收藏, 编辑
摘要：Tsql 获取服务器属性，如服务器版本。服务器名ref:http://technet.microsoft.com/zh-cn/library/ms174396.aspxselect serverproperty ('servername') select serverproperty ('BuildClrVersion');select serverproperty ('Collation');select serverproperty ('CollationID');select serverproperty ('Com 阅读全文
c# winform文本框数字，数值校验
2013-07-03 17:21 by 小sa, 969 阅读, 0 推荐, 收藏, 编辑
摘要：文本框数字，数值校验 public void DigitCheck_KeyPress(object sender, KeyPressEventArgs e) { e.Handled = !char.IsDigit(e.KeyChar) && !char.IsControl(e.KeyChar); } public void DecimalCheck_KeyPress(object sender, KeyPressEventArgs e) { if (!char.IsControl(... 阅读全文
c# Random 快速生成不连续随机码
2013-01-18 17:14 by 小sa, 304 阅读, 0 推荐, 收藏, 编辑
摘要：c# Random Random.Next() 快速生成不连续随机码 seed 阅读全文
Excel Index Match 用法
2013-01-12 20:56 by 小sa, 998 阅读, 0 推荐, 收藏, 编辑
摘要：INDEX / MATCH -- Example 4Instead of matching information in column headings, you may need to match information that's stored in the columns, as shown in the table below.ABCD1CodeItemSizePrice2SW001SweaterSmall103JK001JacketSmall304PN001PantsSmall255SW002SweaterMed126JK002JacketMed357PN002PantsM 阅读全文
Dictionary，hashtable如何排序
2012-12-25 09:50 by 小sa, 250 阅读, 0 推荐, 收藏, 编辑
摘要：Dictionary<string,float> dic=Dictionary<string,float>();List<KeyValuePair<string, float>> list = new List<KeyValuePair<string, float>>(dic);list.Sort(delegate(KeyValuePair<string, float> firstPair, KeyValuePair<string, float> nextPair){ return nextPair 阅读全文
Html Table to Excel 的一种实现 （PHP）
2012-08-09 16:58 by 小sa, 591 阅读, 0 推荐, 收藏, 编辑
摘要：HTML TABLE to Excel ，前端 html Table 内容 写入 Excel 后下载 php实现 阅读全文
vbs run as administrator win7
2012-07-11 14:39 by 小sa, 467 阅读, 0 推荐, 收藏, 编辑
摘要：vba vbs ps bat regex xmlIf WScript.Arguments.Named.Exists("elevated") = False Then'Launch the script again as administratorCreateObject("Shell.Application").ShellExecute "wscript.exe", """" & WScript.ScriptFullName & """ /e 阅读全文