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; }