ccbbcc 2024-10-18 09:36 采纳率: 90.3%
浏览 0

再问往*.csv文件里写数据的问题

我往*。csv里存数据,第一个老是井号
代码;

Public Sub SaveData(a As String, b As String, c As String, d As String, e As String, f As String, g As String, h As String, i As String, j As String, k As String, l As String, m As String)
    ' 打开文件以追加数据
    Open "d:\excel.csv" For Append As #1
      
    ' 写入一行数据
    'Print #1, a & "," & b & "," & c & "," & d & "," & e & "," & f & "," & g & "," & h & "," & i & "," & j & "," & k & "," & l & "," & m
     Print #1, a, b, c, d, e, f, g, h, i, j, k, l, m
    ' 关闭文件
    Close #1
End Sub

Dim data(1 To 13) As String
data(1) = Date
    data(2) = Time
    data(3) = d
    data(4) = Label8.Caption
    data(5) = Label10.Caption
    data(6) = Label12.Caption
    data(7) = Label15.Caption
    data(8) = Label17.Caption
    data(9) = Label19.Caption
    data(10) = Label25.Caption
    data(11) = Label27.Caption
    data(12) = Label29.Caption

data(13) = "启动"
            
            Call SaveData(data(1), data(2), data(3), data(4), data(5), data(6), data(7), data(8), data(9), data(10), data(11), data(12), data(13))

img


请问专家,如何解决?谢谢

  • 写回答

1条回答 默认 最新

  • 赵4老师 2024-10-18 10:45
    关注
    data(1)=Str(Date)
    Print #1,CHR(34) & a & CHR(34) & "," & ……
    
    
    评论

报告相同问题?

问题事件

  • 创建了问题 今天

悬赏问题

  • ¥15 已知平面坐标系(非直角坐标系)内三个点的坐标,反求两坐标轴的夹角
  • ¥15 webots有问题,无响应
  • ¥15 数据量少可以用MK趋势分析吗
  • ¥15 使用VH6501干扰RTR位,CANoe上显示的错误帧不足32个就进入bus off快慢恢复,为什么?
  • ¥15 大智慧怎么编写一个选股程序
  • ¥100 python 调用 cgps 命令获取 实时位置信息
  • ¥15 两台交换机分别是trunk接口和access接口为何无法通信,通信过程是如何?
  • ¥15 C语言使用vscode编码错误
  • ¥15 用KSV5转成本时,如何不生成那笔中间凭证
  • ¥20 ensp怎么配置让PC1和PC2通讯上