SSQL="-- -"
WebService. GetDataTable (sSQL, oDt)
With Me. SpdData_Sheet1
. The RowCount=0
For I As Integer=0 To oDt. Rows. The Count - 1
. The RowCount=. RowCount + 1
SetText (. RowCount - 1, 0, oDt. Rows (I) (" CUSTOMERID "). The ToString ())
The SetText (RowCount - 1, 1, oDt. Rows (I) (" PRODUCTID "). The ToString ())
SetText (. RowCount - 1, 2, oDt. Rows (I) (" WFCSPEC "). The ToString ())
SetText (. RowCount - 1, 3, oDt. Rows (I) (" VOLUME "). The ToString ())
SetText (. RowCount - 1, 4, oDt. Rows (I) (" FORMULA "). The ToString ())
SetText (. RowCount - 1, 5, oDt. Rows (I) (" QCSTAGE "). The ToString ())
SetText (. RowCount - 1, 6, oDt. Rows (I) (" IS_COMP "). The ToString ())
The SetText (RowCount - 1, 7, oDt. Rows (I) (" SHIPTYPE "). The ToString ())
SetText (. RowCount - 1, 8, oDt. Rows (I) (" WFCTYPE "). The ToString ())
SetText (. RowCount - 1, 9, oDt. Rows (I) (" WFCSTOCK "). The ToString ())
SetText (. RowCount - 1, 10, oDt. Rows (I) (" MIDTYPE "). The ToString ())
Next
End With