1234567891011121314151617181920212223242526272829303132333435363738394041 |
- $PBExportHeader$f_xls_getcolumnlist.srf
- global type f_xls_getcolumnlist from function_object
- end type
- forward prototypes
- global function s_xls_dwcolumnlist f_xls_getcolumnlist (datastore arg_ds)
- end prototypes
- global function s_xls_dwcolumnlist f_xls_getcolumnlist (datastore arg_ds);s_xls_dwcolumnlist s_col
- Long rowcnt,i,cnt = 0
- String tempstr,result,titlestr
- //result = arg_ds.Describe("Datawindow.Objects")
- //if isnull(result) or result = '' then return s_col
- //rowcnt = Long(arg_ds.Describe("datawidnow.column.count") )
- //if isnull(arg_ds.Object ) then return s_col
- //result = arg_ds.Object.DataWindow.Column.Count
- //if isnull(result) or result = '!' or result = '?' then return s_col
- rowcnt = Long(arg_ds.Object.DataWindow.Column.Count)
- // messagebox('',string(arg_ds.Object.DataWindow.Column.Count))
- FOR i = 1 TO rowcnt
- tempstr = arg_ds.Describe('#' + String(i) + ".name")
- IF tempstr <> '!' AND tempstr <> '?' THEN
- cnt ++
- s_col.columnname[cnt] = tempstr
- s_col.column_dscrp[cnt] = ''
- titlestr=arg_ds.Describe(tempstr+'_t.text')
- if titlestr <> '!' AND titlestr <> '?' THEN
- s_col.column_dscrp[cnt] = titlestr
- end if
-
- END IF
-
- NEXT
- //MessageBox(arg_ds.Describe('u_order_ml_ordercode_t.type') ,string(arg_ds.Object.DataWindow.dATA ))
- //MessageBox('',arg_ds.Describe("DataWindow.Objects"))
- RETURN s_col
- end function
|