public static function run($dataDir = null)
 {
     $fileFormatType = new FileFormatType();
     //Creating an Workbook object with an Excel file path
     $workbook = new Workbook($dataDir . "book.xls");
     //Save in default (Excel2003) format
     $workbook->save($dataDir . "book.default.out.xls");
     //Save in Excel2003 format
     $workbook->save($dataDir . "book.out.xls", $fileFormatType->EXCEL_97_TO_2003);
     //Save in Excel2007 xlsx format
     $workbook->save($dataDir . "book.out.xlsx", $fileFormatType->XLSX);
     //Save in SpreadsheetML format
     $workbook->save($dataDir . "book.out.xml", $fileFormatType->EXCEL_2003_XML);
     //Print Message
     print "<BR>";
     print "Worksheets are saved successfully.";
 }
 public static function run($dataDir = null)
 {
     $saveFormat = new SaveFormat();
     $workbook = new Workbook($dataDir . "Book1.xls");
     //Save the document in PDF format
     $workbook->save($dataDir . "OutBook1.html", $saveFormat->HTML);
     // Print message
     echo "\n Excel to HTML conversion performed successfully.";
 }
 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;
 }
 public static function run($dataDir = null)
 {
     //Instantiate a Workbook object by excel file path
     $workbook = new Workbook($dataDir . "Book1.xls");
     //Retrieve a list of all custom document properties of the Excel file
     $customProperties = $workbook->getWorksheets()->getCustomDocumentProperties();
     //Accessing a custom document property by using the property index
     $customProperty1 = $customProperties->get(3);
     //Accessing a custom document property by using the property name
     $customProperty2 = $customProperties->get("Owner");
     //Adding a custom document property to the Excel file
     $publisher = $customProperties->add("Publisher", "Aspose");
     //Save the file
     $workbook->save($dataDir . "Test_Workbook.xls");
     //Removing a custom document property
     $customProperties->remove("Publisher");
     //Save the file
     $workbook->save($dataDir . "Test_Workbook_RemovedProperty.xls");
     // Print message
     print "Excel file's custom properties accessed successfully." . PHP_EOL;
 }
 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 Excel object by excel file path
     $workbook = new Workbook($dataDir . "book.xls");
     //Accessing the first worksheet in the Excel file
     $worksheets = $workbook->getWorksheets();
     $worksheet = $worksheets->get(0);
     //Applying freeze panes settings
     $worksheet->freezePanes(3, 2, 3, 2);
     //Saving the modified Excel file in default format
     $workbook->save($dataDir . "book.out.xls");
     //Print Message
     print "Panes freeze successfull." . PHP_EOL;
 }
 public static function run($dataDir = null)
 {
     //Instantiating a Excel object by excel file path
     $workbook = new Workbook($dataDir . "book1.xls");
     //Accessing the first worksheet in the Excel file
     $worksheets = $workbook->getWorksheets();
     $worksheet = $worksheets->get(0);
     //Setting the zoom factor of the worksheet to 75
     $worksheet->setZoom(75);
     //Saving the modified Excel file in default format
     $workbook->save($dataDir . "output.xls");
     // Print message
     print "Zoom factor set to 75% for sheet 1, please check the output document.";
 }
 public static function run($dataDir = null)
 {
     //Instantiating a Excel object by excel file path
     $workbook = new Workbook($dataDir . "book1.xls");
     //Adding a new worksheet to the Workbook object
     $worksheets = $workbook->getWorksheets();
     $worksheet = $worksheets->get(0);
     //Displaying the worksheet in page break preview
     $worksheet->setPageBreakPreview(true);
     //Saving the modified Excel file in default format
     $workbook->save($dataDir . "output.xls");
     // Print message
     print "Page break preview is enabled for sheet 1, please check the output document." . PHP_EOL;
 }
 public static function run($dataDir = null)
 {
     //Instantiating a Workbook object by excel file path
     $workbook = new Workbook($dataDir . "book1.xls");
     //Accessing the first worksheet in the Excel file
     $worksheets = $workbook->getWorksheets();
     $worksheet = $worksheets->get(0);
     //Hiding the first worksheet of the Excel file
     $worksheet->setVisible(false);
     //Saving the modified Excel file in default (that is Excel 2003) format
     $workbook->save($dataDir . "output.xls");
     // Print message
     print "Worksheet 1 is now hidden, please check the output document." . PHP_EOL;
 }
 public static function run($dataDir = null)
 {
     $saveFormat = new SaveFormat();
     //Instantiate a new workbook
     //Open a template file
     $book = new Workbook($dataDir . "book.xls");
     //Set the active cell
     $book->getWorksheets()->get(0)->setActiveCell("A20");
     //Split the worksheet window
     $book->getWorksheets()->get(0)->split();
     //Save the excel file
     $book->save($dataDir . "book.out.xls", $saveFormat->EXCEL_97_TO_2003);
     //Print Message
     print "Panes split successfully." . PHP_EOL;
 }
 public static function run($dataDir = null)
 {
     //Creating a file stream containing the Excel file to be opened
     $fstream = new FileInputStream($dataDir . "book.xls");
     //Instantiating a Workbook object with the stream
     $workbook = new Workbook($fstream);
     //Removing a worksheet using its sheet name
     $workbook->getWorksheets()->removeAt("Sheet1");
     //Saving the Excel file
     $workbook->save($dataDir . "book.out.xls");
     //Closing the file stream to free all resources
     $fstream->close();
     //Print Message
     print "Sheet removed successfully.";
 }
 public static function run($dataDir = null)
 {
     $filesFormatType = new FileFormatType();
     //Instantiating a Workbook object
     $workbook = new Workbook($dataDir . "book1.xls");
     $worksheets = $workbook->getWorksheets();
     $worksheet = $worksheets->get(0);
     $protection = $worksheet->getProtection();
     //Unprotecting the worksheet with a password
     $worksheet->unprotect("aspose");
     // Save the excel file.
     $workbook->save($dataDir . "output.xls", $filesFormatType->EXCEL_97_TO_2003);
     //Print Message
     print "Worksheet unprotected successfully.";
 }
 public static function scaling($dataDir = null)
 {
     # Instantiating a Workbook object by excel file path
     $workbook = new Workbook($dataDir . 'Book1.xls');
     # Accessing the first worksheet in the Excel file
     $worksheets = $workbook->getWorksheets();
     $sheet_index = $worksheets->add();
     $sheet = $worksheets->get($sheet_index);
     # Setting the scaling factor to 100
     $page_setup = $sheet->getPageSetup();
     $page_setup->setZoom(100);
     # Saving the modified Excel file in default (that is Excel 2003) format
     $workbook->save($dataDir . "Scaling.xls");
     print "Set scaling, please check the output file." . PHP_EOL;
 }
 public static function run($dataDir = null)
 {
     //Instantiating a Workbook object
     $workbook = new Workbook();
     //Adding a new worksheet to the Workbook object
     $worksheets = $workbook->getWorksheets();
     $sheetIndex = $worksheets->add();
     $worksheet = $worksheets->get($sheetIndex);
     //Setting the name of the newly added worksheet
     $worksheet->setName("My Worksheet");
     //Saving the Excel file
     $workbook->save($dataDir . "book.out.xls");
     //Print Message
     print "Sheet added successfully.";
 }
 public static function run($dataDir = null)
 {
     $sveFormat = new SaveFormat();
     //Specify the file path
     $filePath = $dataDir . "Book1.xlsx";
     //Specify the HTML saving options
     $sv = new HtmlSaveOptions($sveFormat->M_HTML);
     //Instantiate a workbook and open the template XLSX file
     $wb = new Workbook($filePath);
     //Save the MHT file
     $wb->save($filePath . ".out.mht", $sv);
     // Print message
     print "<br>";
     print "<br>";
     print "Excel to MHTML conversion performed successfully.";
 }
 public static function run($dataDir = null)
 {
     // Instantiating a Workbook object that represents a Microsoft Excel file.
     $workbook = new Workbook();
     // Note when you create a new workbook, a default worksheet,
     // "Sheet1", is by default added to the workbook.
     // Accessing the first worksheet in the book ("Sheet1").
     $sheet = $workbook->getWorksheets()->get(0);
     # Access cell "A1" in the sheet.
     $cell = $sheet->getCells()->get("A1");
     # Input the "Hello World!" text into the "A1" cell
     $cell->setValue("Hello World!");
     # Saving the modified Excel file in default (that is Excel 2003) format
     $file_format_type = new FileFormatType();
     $workbook->save($dataDir . "HelloWorld.xls", $file_format_type->EXCEL_97_TO_2003);
     print "Document has been saved, please check the output file.";
 }
 public static function run($dataDir = null)
 {
     $saveFormat = new SaveFormat();
     $workbook = new Workbook($dataDir . "Book1.xls");
     //Get the first worksheet.
     $sheet = $workbook->getWorksheets()->get(0);
     //Apply different Image and Print options
     $options = new ImageOrPrintOptions();
     //Set the Format
     $options->setSaveFormat($saveFormat->XPS);
     // Render the sheet with respect to specified printing options
     $sr = new SheetRender($sheet, $options);
     $sr->toImage(0, $dataDir . "out_printingxps.xps");
     //Save the complete Workbook in XPS format
     $workbook->save($dataDir . "out_whole_printingxps", $saveFormat->XPS);
     // Print message
     print "Excel to XPS conversion performed successfully.";
 }
 public static function run($dataDir = null)
 {
     $filesFormatType = new FileFormatType();
     //Instantiating a Workbook object
     $workbook = new Workbook($dataDir . "book1.xls");
     $worksheets = $workbook->getWorksheets();
     $worksheet = $worksheets->get(0);
     $protection = $worksheet->getProtection();
     //The following 3 methods are only for Excel 2000 and earlier formats
     $protection->setAllowEditingContent(false);
     $protection->setAllowEditingObject(false);
     $protection->setAllowEditingScenario(false);
     //Unprotecting the worksheet
     $worksheet->unprotect();
     // Save the excel file.
     $workbook->save($dataDir . "output.xls", $filesFormatType->EXCEL_97_TO_2003);
     //Print Message
     print "Worksheet unprotected successfully." . PHP_EOL;
 }
 public static function run($dataDir = null)
 {
     //Instantiating a Excel object by excel file path
     $excel = new Workbook($dataDir . "book1.xls");
     //Accessing the first worksheet in the Excel file
     $worksheets = $excel->getWorksheets();
     $worksheet = $worksheets->get(0);
     $protection = $worksheet->getProtection();
     //The following 3 methods are only for Excel 2000 and earlier formats
     $protection->setAllowEditingContent(false);
     $protection->setAllowEditingObject(false);
     $protection->setAllowEditingScenario(false);
     //Protects the first worksheet with a password "1234"
     $protection->setPassword("1234");
     //Saving the modified Excel file in default format
     $excel->save($dataDir . "output.xls");
     //Print Message
     print "Sheet protected successfully." . PHP_EOL;
 }
 public static function copy_columns($dataDir)
 {
     # Instantiating a Workbook object by excel file path
     $workbook = new Workbook();
     # Accessing the first worksheet in the Excel file
     $worksheet = $workbook->getWorksheets()->get(0);
     # Put some data into header rows (A1:A4)
     $i = 0;
     while ($i < 5) {
         $worksheet->getCells()->get($i, 0)->setValue("Header Row #{$i}");
         $i++;
     }
     # Put some detail data (A5:A999)
     $i = 5;
     while ($i < 1000) {
         $worksheet->getCells()->get($i, 0)->setValue("Detail Row #{$i}");
         $i++;
     }
     # Create another Workbook.
     $workbook1 = new Workbook();
     # Get the first worksheet in the book.
     $worksheet1 = $workbook1->getWorksheets()->get(0);
     # Copy the first column from the first worksheet of the first workbook into
     # the first worksheet of the second workbook.
     $worksheet1->getCells()->copyColumn($worksheet->getCells(), 0, 2);
     # Autofit the column.
     $worksheet1->autoFitColumn(2);
     # Saving the modified Excel file in default (that is Excel 2003) format
     $workbook->save($dataDir . "Copy Columns.xls");
     print "Copy Columns Successfully." . PHP_EOL;
 }