f_xls_getcolumnlist.srf 1.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. $PBExportHeader$f_xls_getcolumnlist.srf
  2. global type f_xls_getcolumnlist from function_object
  3. end type
  4. forward prototypes
  5. global function s_xls_dwcolumnlist f_xls_getcolumnlist (datastore arg_ds)
  6. end prototypes
  7. global function s_xls_dwcolumnlist f_xls_getcolumnlist (datastore arg_ds);s_xls_dwcolumnlist s_col
  8. Long rowcnt,i,cnt = 0
  9. String tempstr,result,titlestr
  10. //result = arg_ds.Describe("Datawindow.Objects")
  11. //if isnull(result) or result = '' then return s_col
  12. //rowcnt = Long(arg_ds.Describe("datawidnow.column.count") )
  13. //if isnull(arg_ds.Object ) then return s_col
  14. //result = arg_ds.Object.DataWindow.Column.Count
  15. //if isnull(result) or result = '!' or result = '?' then return s_col
  16. rowcnt = Long(arg_ds.Object.DataWindow.Column.Count)
  17. // messagebox('',string(arg_ds.Object.DataWindow.Column.Count))
  18. FOR i = 1 TO rowcnt
  19. tempstr = arg_ds.Describe('#' + String(i) + ".name")
  20. IF tempstr <> '!' AND tempstr <> '?' THEN
  21. cnt ++
  22. s_col.columnname[cnt] = tempstr
  23. s_col.column_dscrp[cnt] = ''
  24. titlestr=arg_ds.Describe(tempstr+'_t.text')
  25. if titlestr <> '!' AND titlestr <> '?' THEN
  26. s_col.column_dscrp[cnt] = titlestr
  27. end if
  28. END IF
  29. NEXT
  30. //MessageBox(arg_ds.Describe('u_order_ml_ordercode_t.type') ,string(arg_ds.Object.DataWindow.dATA ))
  31. //MessageBox('',arg_ds.Describe("DataWindow.Objects"))
  32. RETURN s_col
  33. end function