使用powerbuilder从excel写入和读取 [英] write and read from excel using powerbuilder

问题描述

使用Powerbuilder OLE可以从excel工作表中读写的任何示例（我需要在excel工作表文件中写入值并在excel执行其某些功能后读取其他值）

Any sample to write and read from excel sheet (i need to write values in excel sheet file and read other values after excel execute some its functions) using Powerbuilder "OLE"

推荐答案

以下是通过OLE访问Excel文件的示例：

Here is a sample of accessing to an Excel file through OLE :

int li_rtn
string ls_range
oleobject lole_excel, lole_workbook, lole_worksheet, lole_range
lole_excel = create oleobject
li_rtn = lole_excel.ConnectToNewObject("excel.application")
if li_rtn <> 0 then
      MessageBox( "Error", 'Error running MS Excel api.')
      destroy lole_Excel
else
  lole_excel.WorkBooks.Open("C:\some_path_to\sample.xls") 

  lole_workbook = lole_excel.application.workbooks(1)
  lole_worksheet = lole_workbook.worksheets(1)

  // Set the cell value
  lole_worksheet.cells(1,11).value = "Some value" //it is cells(line, column)

  //example to work on a range of cells
  ls_range = "A1:F"+string(ll_excel_rows)
  lole_range = lole_worksheet.Range(ls_range)
  lole_range.Select
  lole_range.Locked = True

  // Save
  lole_workbook.save()
  // Quit
  lole_excel.application.quit()
  lole_excel.DisconnectObject()

  destroy lole_Excel
end if

可以通过工作表轻松进行读写值。细胞属性。

唯一的问题是通过OLE在大量单元格上驱动Excel很慢。

The only problem is that driving Excel on a large amount of cells through OLE is slow.

这篇关于使用powerbuilder从excel写入和读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！