以前在论坛里贴过与fisher一同开发的c#通视和数畅接口代码,zwz也贴过他的代码,可能有朋友使用。想调查一下现在有多少人在使用c#开发的通视/数畅接口,包括自行开发的或参考我们几个代码改编开发的。没有版权方面的考虑,只是想知道有多少人懂并在使用这类东西。
不能下载xls文件 我想程序下载 地址为 http://market.finance.sina.com.cn/downxls.php?date=2009-05-18&symbol=sh600050 的xls文件,游览器可以下载,但程序不能下载, 请给一段示例代码
Dim b() As Byte Dim d As String Private Sub Command1_Click() End Sub Private Sub Command2_Click() For m = DTPicker1.Value To DTPicker2.Value For i = 0 To List1.ListCount - 1 mysymbol = List1.List(i) m = Format(m, "yyyy-mm-dd") Call mdownload(m, mysymbol) objInet.Cancel Next Next End Sub Private Sub Command3_Click() List1.Clear For i = 0 To List2.ListCount List1.AddItem (List2.List(i)) Next End Sub Private Sub Command4_Click() List1.Clear End Sub Private Sub Drive1_Change() Dir1.Path = Drive1.Drive End Sub Private Sub Form_Load() Dir1.Path = Drive1.Drive DTPicker1 = Now() DTPicker2 = Now() End Sub Private Sub mdownload(ByVal mydate As String, ByVal mysymbol As String) Dim b() As Byte Label1.Caption = "" mfilename = Dir1.Path & "\" & mydate & mysymbol & ".xls" Command2.Enabled = False Label1.Caption = "开始下载" & mysymbol & "日期:" & mydate b() = objInet.OpenURL("http://market.finance.sina.com.cn/downxls.php?date=" & mydate & "&symbol=" & mysymbol, 1) Label1.Caption = "下载完成" & mysymbol If UBound(b) < 1001 Then strerrormsg = "无法打开该URL地址!" Label1.Caption = strerrormsg Command2.Enabled = True Else Label1.Caption = "正在保存" & mysymbol mfilenum = FreeFile() Open mfilename For Binary As mfilenum Put mfilenum, , b() Close mfilenum Command2.Enabled = True Label1.Caption = "完成保存" & mysymbol End If End Sub Private Sub Form_Terminate() objInet.Cancel End Sub Private Sub Form_Unload(Cancel As Integer) End End Sub Private Sub List1_DblClick() List1.RemoveItem (List1.ListIndex) End Sub Private Sub List2_DblClick() List1.AddItem (List2.Text) End Sub