msflegrid数据快速向EXCEL 导出? msflegrid数据快速向EXCEL 导出? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 msflegrid数据来自何处?是否绑定了记录集? 来自输入一定参数后数值计算的结果,数据比较多,在mshflegrid中显示,想尽快保存出来,没有使用记录集 http://community.csdn.net/Expert/topic/4934/4934537.xml?temp=.1385614of123:帮我看下这个问题,谢谢先 Rem 快速保存的数据文件格式CSV,可以用EXCEL打开Private Sub MnuCsv_Click()Dim i As Integer''写入CSV文件,EXCEL可以打开的文件Dim FileName As String '''''''''''将数据保存到Excel表里CommDiag1.FileName = ""CommDiag1.Filter = "Excel表|*.csv"CommDiag1.ShowSaveFileName = CommDiag1.FileNameIf FileName = "" Then Exit SubEnd If Open FileName For Output As #1 Print #1, " 步进序号"; ","; ''''' '这里是写CSV的第一行,固定的列头 Print #1, "1"; ","; Print #1, "2"; ","; Print #1, "3"; ","; Print #1, "4"; ","; Print #1, "5"; ","; Print #1, "6"; ","; Print #1, "7"; ","; Print #1, "8"; ","; Print #1, vbNullString ''''结束换行 ''''''写入数据 For i = 1 To 546 Print #1, Val(MSHFlexGrid1.TextMatrix(i, 0)); ","; ''csv是一个逗号一个逗号‘’隔开的,直接生成文本文件就是了 Print #1, Val(MSHFlexGrid1.TextMatrix(i, 1)); ","; Print #1, Val(MSHFlexGrid1.TextMatrix(i, 2)); ","; Print #1, Val(MSHFlexGrid1.TextMatrix(i, 3)); ","; Print #1, Val(MSHFlexGrid1.TextMatrix(i, 4)); ","; Print #1, Val(MSHFlexGrid1.TextMatrix(i, 5)); ","; Print #1, Val(MSHFlexGrid1.TextMatrix(i, 6)); ","; Print #1, Val(MSHFlexGrid1.TextMatrix(i, 7)); ","; Print #1, Val(MSHFlexGrid1.TextMatrix(i, 8)); ","; Print #1, vbNullString Next Close #1End Sub Excel读取一个图片后如何得到它的像素值? vb 向网页flie里 录入地址不能赋值 为何 vb 日期转换问题 谁有开发工控控件的经历,进来聊聊吧:) 怎样将MSFlexGrid控件跟ADO控件绑定? 【BlueDog】——★★★ 查找IP地址的属地确定数据库 ★★★ 问题。。。》???? 有什么函数或者其他方法能知道两个5号排列在一起所占的宽度(单位为象素) 帮帮忙大哥! 我想测试网络速度怎么编程实现!?有没有这样程序。可以使用。大家见过吗? 回写HOOK的近来帮忙 求批量将WORD转换HTML网页 vb宏(在线)
Private Sub MnuCsv_Click()
Dim i As Integer''写入CSV文件,EXCEL可以打开的文件Dim FileName As String '''''''''''将数据保存到Excel表里
CommDiag1.FileName = ""
CommDiag1.Filter = "Excel表|*.csv"
CommDiag1.ShowSave
FileName = CommDiag1.FileName
If FileName = "" Then
Exit Sub
End If
Open FileName For Output As #1
Print #1, " 步进序号"; ","; ''''' '这里是写CSV的第一行,固定的列头
Print #1, "1"; ",";
Print #1, "2"; ",";
Print #1, "3"; ",";
Print #1, "4"; ",";
Print #1, "5"; ",";
Print #1, "6"; ",";
Print #1, "7"; ",";
Print #1, "8"; ",";
Print #1, vbNullString ''''结束换行
''''''写入数据
For i = 1 To 546
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 0)); ","; ''csv是一个逗号一个逗号‘’隔开的,直接生成文本文件就是了
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 1)); ",";
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 2)); ",";
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 3)); ",";
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 4)); ",";
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 5)); ",";
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 6)); ",";
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 7)); ",";
Print #1, Val(MSHFlexGrid1.TextMatrix(i, 8)); ",";
Print #1, vbNullString
Next
Close #1
End Sub