public static function run($dataDir = null)
{
//Instantiating a Excel object by excel file path
$workbook = new Workbook($dataDir . "book1.xls");
//Hiding the vertical scroll bar of the Excel file
$workbook->getSettings()->setVScrollBarVisible(false);
//Hiding the horizontal scroll bar of the Excel file
$workbook->getSettings()->setHScrollBarVisible(false);
//Saving the modified Excel file in default (that is Excel 2003) format
$workbook->save($dataDir . "output.xls");
// Print message
print "Scroll bars are now hidden, please check the output document.";
}
public static function run($dataDir = null)
{
//Instantiating a Workbook object by excel file path
$workbook = new Workbook($dataDir . "book1.xls");
//Hiding the tabs of the Excel file
$workbook->getSettings()->setShowTabs(false);
//Saving the modified Excel file in default (that is Excel 2003) format
$workbook->save($dataDir + "output.xls");
// Print message
print "Tabs are now hidden, please check the output file." . PHP_EOL;
}
