摘要:
取系统时间和时间格式'20080812165758Dim file_Datetime As String = DateTime.Now.ToString("yyyyMMddHHmmss")Dim strTime As String = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")'增加或减当天的时间的天数Dim strTime As String = D... 阅读全文
摘要:
1.把以下代码复制到记事本里面,后缀名改成xls,根据需要修改所要的模板 Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Automated Report Generator Example 2008-09-23T01:35... 阅读全文
摘要:
转自:http://kb.cnblogs.com/page/42229/ 经常需要在数据库与Execl之间互导数据。net时代,ADO.NET可以使用使用Microsoft.Jet.OleDb访问访问Excel,网上已经有很多类似的资源,最典型也是最简单的可能如下:(asp.net环境) Code Code highlighting produced by Actipro CodeHi... 阅读全文
摘要:
1. vb.net Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Imports Microsoft.Office.Interop Private Sub NAR(ByVal o As Object) Try System.Ru... 阅读全文
摘要:
1.利用数组直接赋值给range,速度明显快多了。 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Public Sub WriteToExcelFile(ByVal FileName As String, ByVal intRows As In... 阅读全文
摘要:
Split分隔字符串的应用(asp.net,vb.net,split、分隔、字符串)1、用字符串分隔: c#CodeCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->usingSystem.Text.RegularExpressions;stringstr="aaajsbbbjsccc";string[]sArray=Regex.Split(str,"js",RegexOptions.IgnoreCase 阅读全文