Skip to content
TestsigmaDOCS
LoginBook a demo

Help

How to Update an Excel File in Testsigma Uploads?

Prerequisites

  • Before you begin, ensure that you have an excel file that has been uploaded to Testsigma.

Install the Addons

Section titled “Install the Addons”

  1. From the left navigation bar, click Addons. Addons

  2. Under the New & Updated Addons section, search for the Upload Latest file to Testsigma Uploads addon and click Install. Upload Latest File to Testsigma Uploads

  3. Under the New & Updated Addons section, search for the ExcelActions_cloud addon and click Install. ExcelActions

Steps to Resolve the Issue

Section titled “Steps to Resolve the Issue”

  1. In your test case, first use the Wait the data datavalue into the Excelfile excel-path with Cell value rowNo, columnNo, sheet-index and store the path in runtime variable variable-name (supports upload section) NLP to enter the value that you want to add to the excel file. NLP 1

    • Enter the value you want to write into the datavalue placeholder.datavalue
    • Click the excel-path placeholder and replace it by selecting Upload from the Test Data Types dropdown.Upload
    • In the Uploads overlay, choose the Excel file you want to update.Excel file
    • Specify the row number in the rowNo placeholder. rowNo
    • Specify the column number in the columnNo placeholder. columnNo
    • Specify the sheet number in the sheet-index placeholder. sheet-index
    • Enter a variable name in the variable-name placeholder. Variable Name
    • Click Create Step. Create Step

  2. Secondly, use the Upload file with path on testigma uploads with projectid, applicationid, uploadname, url with API key api_key NLP to push the updated file back to your project. NLP 2

    • Click the absolutepath placeholder and replace it by selecting Runtime from the Test Data Types dropdown.Runtime
    • In the Runtime Variable overlay, select the runtime variable you created in the previous step. select the runtime variable
    • Click the projectid placeholder and enter your project id. projectid [[info | NOTE:]] | To get project id and application id use the following steps: | 1. Before you begin, open the inspect panel and refresh the page. Now, right-click on the application name and select Inspect.Inspect | 2. Go to the Network tab and refresh the page. Network | 3. Click applications query. applications query | 4. Here you can find your projectId and applicationId under the Preview tab. Preview
    • Click the applicationid placeholder and enter your application id. applicationid
    • Click the uploadname placeholder and enter your excel file’s name. uploadname [[info | NOTE:]] | To get uploadname and upload id, go to Uploads and hover over the excel file you want to update. Uploads
    • Enter the following URL https://app.testsigma.com/api/v1/uploads/{ID} and replace with the upload ID copied from the Uploads page. For example, https://app.testsigma.com/api/v1/uploads/8 URL
    • Enter the api key in the testdata placeholder. api [[info | NOTE:]] | Please refer to the documentation on generating api keys.
    • Click Create Step. Create Step

After you execute it, here’s how it looks: Run Result