<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                # 如何在 QTP / UFT 中從 EXCEL 導入,讀取,更改數據 > 原文: [https://www.guru99.com/using-excel-with-qtp-hp-uft.html](https://www.guru99.com/using-excel-with-qtp-hp-uft.html) 在本教程中,我們將通過 Micro Focus UFT 使用 Excel。 考慮我們要導入以下 Sales.xls ![Using Excel with QTP ](https://img.kancloud.cn/0d/89/0d890f19a5d803133e5fa31f27e0f927_617x309.png "Using Excel with QTP ") **導入 HP UFT 后,第一行成為列標題。 因此,相應地構建數據**。 導入整個 Excel 文件的語法是 ``` DataTable.Import(FileName) ``` 就我們而言 ``` Datatable.import "D:\Automation\Sales.xls" ``` ![Using Excel with QTP ](https://img.kancloud.cn/15/ad/15ad20eee8ddbc5e03b09f27eea9f7df_591x609.png "Using Excel with QTP ") 導入特定工作表的語法是 ``` DataTable.ImportSheet(FileName, SheetSource, SheetDest) ``` 使用方法 Getrowcount 獲取工作表中的行數 ``` Datatable.import "D:\Automation\Sales.xls"row = Datatable.getsheet(1).Getrowcount MsgBox row ``` ![Using Excel with QTP ](https://img.kancloud.cn/03/97/0397436222efc7bcffb3ec364d9c309e_678x602.png "Using Excel with QTP ") 設置當前行以使用方法 SetCurrentRow ``` Datatable.import "D:\Automation\Sales.xls"DataTable.SetCurrentRow(1) ``` '在下面的代碼中,1 是工作表編號 ``` Row1= Datatable.Value("Year",1) DataTable.SetCurrentRow(2) Row2= Datatable.Value("Year",1) MsgBox("Year Row 1 =" & Row1 & " Year Row 2 =" & Row2 ) ``` ![Using Excel with QTP ](https://img.kancloud.cn/78/65/7865c999ed755fa241559778b7ce7459_743x523.png "Using Excel with QTP ") 使用**值**方法更改導入工作表中的數據。 使用**導出**方法導出 Excel ![Using Excel with QTP ](https://img.kancloud.cn/be/6d/be6dfbb8c77527c83fd9db546b1c8a91_559x511.png "Using Excel with QTP ") ![Using Excel with QTP ](https://img.kancloud.cn/41/c7/41c7c10dd9b3468f01c447ef1512ae98_770x453.png "Using Excel with QTP ")
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看