[求助]请问如何调用excel模版在vb程序界面显示呢?
如题。补充:做好一个模版,包括边框,合成单元格,小数需要“四舍六入,奇进偶舍”等格式,但是怎么才能把这些显示出来呢?FlexGrid,DataGrid,还是OLE等都没成功,当然主要是自己水平有限了。请高手指点一二!!
2007-07-26 09:30
2007-07-26 15:53
2007-07-26 16:03
这个我明白的,就是下面这些吗?
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
xlApp.Visible = False
Set xlBook = xlApp.Workbooks.Open(App.Path & "\three.XLS")
Set xlsheet = xlBook.Worksheets(1)
xlBook.Close
xlApp.Quit
Set xlApp = Nothing
我的意思是在form窗体上显示,就像datagrid 控件那样,直接镶嵌在form内
2007-07-26 20:13
2007-07-26 23:06
这个我明白的,就是下面这些吗?
Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook
Dim xlsheet As Excel.Worksheet
xlApp.Visible = False
Set xlBook = xlApp.Workbooks.Open(App.Path & "\three.XLS")
Set xlsheet = xlBook.Worksheets(1)
xlBook.Close
xlApp.Quit
Set xlApp = Nothing
我的意思是在form窗体上显示,就像datagrid 控件那样,直接镶嵌在form内
Visible=false......
2007-07-27 11:07
2007-07-30 11:20
2007-07-31 08:19
2007-07-31 08:58
2007-08-05 09:21