<?php
// Scenario: Set bold font for a specific cell in an Excel file
$xhe_host = getenv("RPABOT_HOST_URL");
// Connect functional objects if not already connected
if (!isset($path)){
  $path = "../../../Templates/init.php";
  require($path);
}

// beginning
echo "\n<span >excelfile->".basename (__FILE__)."</span>\n";

// Kill existing Excel processes
SYSTEM::$excel->kill();

// Example 1: Set bold font for a cell
// Set arguments as variables
$filePath = "test/test.xlsx";
$sheetIndex = 0;
$rowNumber = 7;
$columnLetter = "A";
$boldValue = true;

echo("\n\n1. Set bold font for a cell: ");
$result = SYSTEM::$excel->set_cell_font_bold($filePath, $sheetIndex, $rowNumber, $columnLetter, $boldValue);
if ($result) {
    echo("Success - Bold font set to cell $columnLetter$rowNumber\n");
} else {
    echo("Failed - Could not set bold font to cell $columnLetter$rowNumber\n");
}

// end
echo "\n";

// Quit
WINDOW::$app->quit();
?>