pb 数据窗口导出到excel2007

最新推荐文章于 2025-05-26 10:41:42 发布

原创

最新推荐文章于 2025-05-26 10:41:42 发布 · 2.5k 阅读

1 ·

CC 4.0 BY-SA版权

本文介绍了如何使用pb数据窗口将数据导出到Excel2007，通过示例代码messagebox("Export OK", "Finished!")展示操作成功。参考链接提供了更多关于Excel的相关资料。" 130854856,11926277,PCA主成分分析详解,"['机器学习', '数据预处理', '统计学', '矩阵运算']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

oleobject loo_excel,loo_sheet
string ls_txt,ls_xls,ls_xls_new
loo_excel = create oleobject
if loo_excel.ConnectToNewObject("Excel.Application") = 0 then
    setpointer(HourGlass!)
    loo_excel.Application.Workbooks.Add()
    loo_sheet = loo_excel.Application.ActiveWorkbook.Worksheets.add()
    loo_sheet.name = "SAVEASTEST"

   idw_source.saveasascii("d:\TESTSAVEAS.txt")
   loo_excel.Application.Visible = false
   ls_txt="d:\TESTSAVEAS.txt"
      ls_xls="d:\TESTSAVEAS.xls"
   MoveFileEx(ls_txt,ls_xls,0)
   loo_excel.Application.Workbooks.Open(ls_xls)

   loo_excel.DisplayAlerts = false;
    loo_excel.Application.ActiveWorkbook.saveas(ls_xls, -4143)