Hi folks, 
Today, we are back with another TestCloud-focused article.
Our team have often received inquiries in the past that are similar to the situation below:
“I have local test case that downloads an
.xlsxExcel File from a website and then opens it to validate the data, and now I want to do the same using TestCloud. How do I achieve it?”
Read more below to learn more! 
Note: At the moment, the code in this article can currently work locally from Katalon Studio and when executed to TestCloud from Katalon Studio. Implementation for tests scheduled from TestOps to TestCloud is currently being tested for implementation and will be updated once resolved.
1. Initial Test Code
To start, the local test code that is used to download the file can be reused, but an additional custom keyword needs to be included to interact with the file itself in a TestCloud environment, once added it will still work locally as well:
import static com.kms.katalon.core.checkpoint.CheckpointFactory.findCheckpoint
import static com.kms.katalon.core.testcase.TestCaseFactory.findTestCase
import static com.kms.katalon.core.testdata.TestDataFactory.findTestData
import static com.kms.katalon.core.testobject.ObjectRepository.findTestObject
import static com.kms.katalon.core.testobject.ObjectRepository.findWindowsObject
import com.kms.katalon.core.checkpoint.Checkpoint as Checkpoint
import com.kms.katalon.core.cucumber.keyword.CucumberBuiltinKeywords as CucumberKW
import com.kms.katalon.core.mobile.keyword.MobileBuiltInKeywords as Mobile
import com.kms.katalon.core.model.FailureHandling as FailureHandling
import com.kms.katalon.core.testcase.TestCase as TestCase
import com.kms.katalon.core.testdata.TestData as TestData
import com.kms.katalon.core.testng.keyword.TestNGBuiltinKeywords as TestNGKW
import com.kms.katalon.core.testobject.TestObject as TestObject
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUI
import com.kms.katalon.core.windows.keyword.WindowsBuiltinKeywords as Windows
import internal.GlobalVariable as GlobalVariable
import org.openqa.selenium.Keys as Keys
WebUI.openBrowser('')
//WebUI.navigateToUrl('Your URL Goes Here')
WebUI.navigateToUrl('https://go.microsoft.com/fwlink/?LinkID=521962')
WebUI.delay(15)
String fileName = "Financial Sample.xlsx"
CustomKeywords.'com.xlsx.xlsxHandler.getExcelFileContent'(fileName);
WebUI.closeBrowser()
In this sample test case, we navigate to a sample .xlsx file downloaded from Microsoft, then provide the known file name as a string to be passed to a custom keyword that handles the validation of the .xlsx file.
2. Custom Keyword
As a part of Katalon’s TestCloud Keywords, there are several File related keywords, such as getFileContent(), getFileDescription(), and exist().
While the file description and exists keywords work for .xlsx, getFileContent() does not, as it is designed to read log or text-based files for content. Therefore, a new keyword is needed to be added in a new package. To do so, you can navigate to the Keywords folder, create a new package called “com.xlsx” and create a keyword called “xlsxHandler“. From this new Keyword file you can then copy and paste the following code:
package com.xlsx
import static com.kms.katalon.core.checkpoint.CheckpointFactory.findCheckpoint
import static com.kms.katalon.core.testcase.TestCaseFactory.findTestCase
import static com.kms.katalon.core.testdata.TestDataFactory.findTestData
import static com.kms.katalon.core.testobject.ObjectRepository.findTestObject
import static com.kms.katalon.core.testobject.ObjectRepository.findWindowsObject
import com.kms.katalon.core.annotation.Keyword
import com.kms.katalon.core.checkpoint.Checkpoint
import com.kms.katalon.core.cucumber.keyword.CucumberBuiltinKeywords as CucumberKW
import com.kms.katalon.core.mobile.keyword.MobileBuiltInKeywords as Mobile
import com.kms.katalon.core.model.FailureHandling
import com.kms.katalon.core.testcase.TestCase
import com.kms.katalon.core.testdata.TestData
import com.kms.katalon.core.testobject.TestObject
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUI
import com.kms.katalon.core.windows.keyword.WindowsBuiltinKeywords as Windows
import com.kms.katalon.core.webui.driver.DriverFactory
import org.openqa.selenium.JavascriptExecutor
import org.openqa.selenium.remote.RemoteWebDriver
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
import internal.GlobalVariable
import java.io.File;
import java.nio.file.attribute.FileTime;
import java.time.Instant;
import java.time.ZoneId;
import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;
import com.kms.katalon.core.testdata.ExcelData as ExcelData
import com.kms.katalon.core.testdata.reader.ExcelFactory as ExcelFactory
import com.kms.katalon.core.testdata.AbstractTestData as AbstractTestData
import java.util.regex.Matcher
import java.util.regex.Pattern
public class xlsxHandler {
/**
* Download .xlsx file content
*
* @param the given file name
* @return the file content in base64
*/
@Keyword
def getExcelFileContent(String fileName) {
Path userHome = Paths.get(System.getProperty("user.home"));
Path downloadsDirectory = userHome.resolve("Downloads");
Path filePath = downloadsDirectory.resolve(fileName);
String filePathString = filePath.toString();
ExcelFactory sampleExcelFactory = new ExcelFactory();
TestData sampleFile = sampleExcelFactory.getExcelDataWithDefaultSheet(filePathString, "Sheet1", true)
// At this point we now have the .xlsx file saved as TestData, and can manipulate it how we chose
// For example, we could now pass the sampleFile TestData to another keyword for parsing or another function
// In this example, instead of calling another keyword, we are iterating through the entire file and printing the values of the cells
int columnCount = sampleFile.getColumnNumbers();
int rowCount = sampleFile.getRowNumbers();
int rowIterate = 1;
int columnIterate = 1;
String cellValue = '';
while (rowIterate <= rowCount) {
while (columnIterate <= columnCount) {
cellValue = sampleFile.getValue(columnIterate, rowIterate);
println("Cell Value is " + cellValue + " at Column " + columnIterate + " and at Row " + rowIterate);
columnIterate = (columnIterate + 1);
}
columnIterate = 1;
rowIterate = (rowIterate + 1);
}
}
}
Once implemented, you can then run your test case on TestCloud and it should successfully locate and begin validation of the contents of the file. Currently, the script is designed to just print the contents of each cell, but you can modify the section of code in the while() loop to do any specific actions you would like for validation.
3. Sample Project
If you find this article helpful, then don’t forget to leave us a like 
or a heart 
and share it with your colleagues and teammates. It would mean a lot for us!
