摘要：要從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, 291 閱讀, 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, 1009 閱讀, 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, 318 閱讀, 0 推薦, 收藏,
摘要：c# Random Random.Next() 快速生成不連續隨機碼 seed 閱讀全文
Excel Index Match 用法
2013-01-12 20:56 by 小sa, 1012 閱讀, 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, 257 閱讀, 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, 601 閱讀, 0 推薦, 收藏,
摘要：HTML TABLE to Excel ，前端 html Table 內容 寫入 Excel 后下載 php實現 閱讀全文
vbs run as administrator win7
2012-07-11 14:39 by 小sa, 478 閱讀, 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 閱讀全文
浙公網安備 33010602011771號