| 网站首页 | VB.Net实例分析 | .Net技术文摘 | 下载中心 | VB.Net书籍笔记 | .Net源码 | VBS脚本与组件调用 | Windows2008技术文摘 | 给我们留言 | 
最新公告:

  没有公告

您现在的位置: 乐博网 >> VB.Net实例分析 >> 其他 >> 实例分析正文
最新推荐 更多内容
VB.Net数据自增的3个实例
VB.Net数据自增的3个实例
作者:Ilu    来源:乐博网整理     更新时间:2009-9-23

乐博网lob.cn提示:调试环境为 vs2008 +  windows2003 / windows2008 / xp / vista

VB.Net数据自增的代码如下:
Public Class Sheet1
    Private MyWeekMenu As Office.CommandBarButton
    Private MyMonthMenu As Office.CommandBarButton
    Private MySeriesMenu As Office.CommandBarButton
    Private missing = System.Reflection.Missing.Value
    Private Sub Sheet1_Startup(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Startup
        AddMenuBar()
    End Sub
    Private Sub Sheet1_Shutdown(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Shutdown
    End Sub
    Private Sub AddMenuBar()
        Try
            Dim MyCommandBarPopup As Office.CommandBarPopup = Nothing
            Dim MyCommandBarMenu As Office.CommandBar = _
                CType(Application.CommandBars.ActiveMenuBar, Office.CommandBar)
            Dim MyControlsCount As Integer = MyCommandBarMenu.Controls.Count
            MyCommandBarPopup = CType(MyCommandBarMenu.Controls.Add( _
                Office.MsoControlType.msoControlPopup, missing, missing, _
                MyControlsCount, True), Office.CommandBarPopup)
            If (MyCommandBarPopup IsNot Nothing) Then
                MyCommandBarPopup.Caption = "演示数据自增"
                MyWeekMenu = CType(MyCommandBarPopup.Controls.Add( _
                    Office.MsoControlType.msoControlButton, missing, missing, _
                    missing, True), Office.CommandBarButton)
                MyWeekMenu.Caption = "自增星期数据"
                AddHandler MyWeekMenu.Click, AddressOf MyWeekMenuCommand_Click
                MyMonthMenu = CType(MyCommandBarPopup.Controls.Add( _
                    Office.MsoControlType.msoControlButton, missing, missing, _
                    missing, True), Office.CommandBarButton)
                MyMonthMenu.Caption = "自增月份数据"
                AddHandler MyMonthMenu.Click, AddressOf MyMonthMenuCommand_Click
                MySeriesMenu = CType(MyCommandBarPopup.Controls.Add( _
                    Office.MsoControlType.msoControlButton, missing, missing, _
                    missing, True), Office.CommandBarButton)
                MySeriesMenu.Caption = "自增序列数据"
                AddHandler MySeriesMenu.Click, AddressOf MySeriesMenuCommand_Click
            End If
        Catch ex As Exception
            MessageBox.Show(ex.Message, "乐博网信息提示", _
                                MessageBoxButtons.OK, MessageBoxIcon.Error)
        End Try
    End Sub
    '自增星期数据
    Private Sub MyWeekMenuCommand_Click(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean)
        Dim MyRange As Microsoft.Office.Tools.Excel.NamedRange = _
            Me.Controls.AddNamedRange(Me.Range("A1", missing), "NamedRange1")
        'MyRange.Value2 = "星期一"
        'MyRange.AutoFill(Me.Range("A1", "A5"), Excel.XlAutoFillType.xlFillWeekdays)
        MyRange.Value2 = "Monday"
        MyRange.AutoFill(Me.Range("A1", "A5"), Excel.XlAutoFillType.xlFillWeekdays)
    End Sub
    '自增月份数据  '更多.net源码和实例,来自乐博网 www.lob.cn
    Private Sub MyMonthMenuCommand_Click(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean)
        Dim MyRange As Microsoft.Office.Tools.Excel.NamedRange = _
            Me.Controls.AddNamedRange(Me.Range("B1", missing), "NamedRange2")
        'MyRange.Value2 = "Jan"
        MyRange.Value2 = "January"
        MyRange.AutoFill(Me.Range("B1", "B12"), Excel.XlAutoFillType.xlFillMonths)
    End Sub
    '自增序列数据
    Private Sub MySeriesMenuCommand_Click(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean)
        Dim MyRange As Microsoft.Office.Tools.Excel.NamedRange = _
            Me.Controls.AddNamedRange(Me.Range("C1", missing), "NamedRange3")
        MyRange.Value2 = "1975年1月1日 生产日报"
        MyRange.AutoFill(Me.Range("C1", "C31"), Excel.XlAutoFillType.xlFillSeries)
    End Sub
End Class

  • 上一篇:

  • 下一篇:
  • 【字体: 】【打印此文】【关闭窗口
      相关文章:(只显示最新16条)
    VB.Net在Excel工作簿中使用Chart宿主控件显示图表
    VB.Net为excel取消用户密码的实例
    VB.Net为excel设置用户密码的实例
    VB.Net把excel导出XPS文件
    VB.Net把excel导出PDF文件的实例
    VB.Net把excel导入Access数据库
    VB.Net把excel导入文本文件的实例
    VB.Net把excel导入XML文件的实例
    VB.Net显示和隐藏Excel操作窗格的实例
    VB.Net Excel合并单元格的实例
    VB.Net输出Word和Excel报表的实例

    | 设为首页 | 加入收藏 | 联系站长 | | 友情链接 | 版权申明 |
    乐博网欢迎各种媒体转载我们的原创作品[转载请注明出处];我们鼓励更多VB.Net开发者一起加入研究与探讨;如发现文章访问错误、内容错误或版权疑问、内容有违相关法律(如涉及政治、色情、反动或散布虚假有害信息)等情况,请及时向我们举报,我们将及时纠正!
    联系邮箱:Shiny#vip.qq.com (#替换为@) QQ交流群: 40797788 [闽ICP备05014267号]