Is there a way to populate an excel spreadsheet with the elapsed time of a single step

Integrations
,
7

I found that Katalon Studio bundles Super CSV
See How can I write values to a CSV file from Katalon Studio - #8 by kazurayam
I made a sample Test Case that utilized Super CSV

“Test Cases/TCx”

import static com.kms.katalon.core.testcase.TestCaseFactory.findTestCase

import java.nio.file.Files
import java.nio.file.Path
import java.nio.file.Paths
import java.time.Duration
import java.time.LocalDateTime

import org.supercsv.io.CsvListWriter
import org.supercsv.prefs.CsvPreference

import com.kms.katalon.core.configuration.RunConfiguration
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUI

LocalDateTime start = LocalDateTime.now()
WebUI.callTestCase(findTestCase("Test Cases/TC1"), [:])   // TC1 takes a few seconds to finish
LocalDateTime end = LocalDateTime.now()
Duration duration = Duration.between(start, end)

// report the duration
int nano = duration.getNano()
String secondsString = String.format("%.2f", nano / 1000000000)

Path projectDir = Paths.get(RunConfiguration.getProjectDir())
Path csvFile = projectDir.resolve("output.csv")

Writer writer = Files.newBufferedWriter(csvFile)
CsvListWriter clw = new CsvListWriter(writer, CsvPreference.EXCEL_PREFERENCE)

clw.write(Arrays.asList("memo","duration"))
clw.write(["calling \"TC1\" took", secondsString])

clw.flush()
clw.close()

output.csv

memo,duration
"calling ""TC1"" took",0.71