当前位置: 首页>>代码示例>>PHP>>正文


PHP COM::Set方法代码示例

本文整理汇总了PHP中COM::Set方法的典型用法代码示例。如果您正苦于以下问题:PHP COM::Set方法的具体用法?PHP COM::Set怎么用?PHP COM::Set使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在COM的用法示例。


在下文中一共展示了COM::Set方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: run

 public static function run($dataDir = null)
 {
     if (is_null($dataDir)) {
         die("Data Directory Undefined");
     }
     // Create Aspose.Cells Helper Object
     $ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
     // Opening through Path
     // Creating a Workbook object and opening an Excel file using its file path
     $workbook = $ptr->New("Aspose.Cells.Workbook", array());
     $worksheets = $ptr->Get($workbook, "Worksheets", array());
     $sheetIndex = $ptr->Call($worksheets, "Add", array());
     $worksheet = $ptr->Get($worksheets, "Item", array($sheetIndex));
     $cells = $ptr->Get($worksheet, "Cells", array());
     $a1 = $ptr->Get($cells, "Item_3", array("A1"));
     $ptr->Call($a1, "PutValue", array(1));
     $a2 = $ptr->Get($cells, "Item_3", array("A2"));
     $ptr->Call($a2, "PutValue", array(2));
     $a3 = $ptr->Get($cells, "Item_3", array("A3"));
     $ptr->Call($a3, "PutValue", array(3));
     $a4 = $ptr->Get($cells, "Item_3", array("A4"));
     $ptr->Call($a3, "PutValue", array(3));
     $ptr->Call($workbook, "Save", array($dataDir . "/output.xls"));
     $ptr->Set($a4, "Formula", "=SUM(A1:A3)", array());
     $ptr->Call($workbook, "CalculateFormula", array());
     $value = $ptr->Get($a4, "Value", array());
     $stringVal = $ptr->Call($value, "ToString", array());
     print "Calculated Value: " . $stringVal . PHP_EOL;
     $ptr->Call($workbook, "Save", array($dataDir . "/output.xls"));
     print "Completed." . PHP_EOL;
 }
开发者ID:xiurui12345,项目名称:Aspose_Cells_NET,代码行数:31,代码来源:CalculatingFormulas.php

示例2: run

 public static function run($dataDir = null)
 {
     if (is_null($dataDir)) {
         die("Data Directory Undefined");
     }
     // Create Aspose.Cells Helper Object
     $ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
     // Opening through Path
     // Creating a Workbook object and opening an Excel file using its file path
     $workbook = $ptr->New("Aspose.Cells.Workbook", array($dataDir . '/MyTestBook1.xls'));
     $worksheets = $ptr->Get($workbook, "Worksheets", array());
     $sheet = $ptr->Get($worksheets, 'Item', array(0));
     $imgOptions = $ptr->New("Aspose.Cells.Rendering.ImageOrPrintOptions", array());
     $imageFormat = new \DOTNET('mscorlib', 'System.Drawing.Imaging.ImageFormat');
     $ptr->Set($imgOptions, 'ImageFormat', $imageFormat->Jpeg, array());
     $ptr->Set($imgOptions, 'OnePagePerSheet', true, array());
     $sr = $ptr->New("Aspose.Cells.Rendering.SheetRender", array($sheet, $imgOptions));
     $bitmap = new \DOTNET("mscorlib", "System.Drawing.Bitmap");
     $bitmap->Save($dataDir . "./SheetImage.jpg");
     print "Conversion to Image(s) completed!" . PHP_EOL;
 }
开发者ID:xiurui12345,项目名称:Aspose_Cells_NET,代码行数:21,代码来源:WorksheetToImage.php

示例3: run

 public static function run($dataDir = null)
 {
     if (is_null($dataDir)) {
         die("Data Directory Undefined");
     }
     // Create Aspose.Cells Helper Object
     $ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
     // Opening through Path
     // Creating a Workbook object and opening an Excel file using its file path
     $workbook = $ptr->New("Aspose.Cells.Workbook", array($dataDir . '/book1.xls'));
     $worksheets = $ptr->Get($workbook, "Worksheets", array());
     $worksheet_index = $ptr->Call($worksheets, "Add_2", array());
     $worksheet = $ptr->Get($worksheets, "Item", array($worksheet_index));
     $ptr->Set($worksheet, "Name", "My Worksheet", array());
     $ptr->Call($workbook, "Save", array($dataDir . "/output.xls"));
     print "Completed." . PHP_EOL;
 }
开发者ID:xiurui12345,项目名称:Aspose_Cells_NET,代码行数:17,代码来源:AddWorksheetsToExistingExcelFile.php

示例4: run

 public static function run($dataDir = null)
 {
     if (is_null($dataDir)) {
         die("Data Directory Undefined");
     }
     // Create Aspose.Cells Helper Object
     $ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
     // Opening through Path
     // Creating a Workbook object and opening an Excel file using its file path
     $workbook = $ptr->New("Aspose.Cells.Workbook", array($dataDir . '/Book1.xls'));
     $XOR = $ptr->New("Aspose.Cells.EncryptionType.XOR", array());
     $crypt = $ptr->New("Aspose.Cells.EncryptionType.StrongCryptographicProvider", array());
     $ptr->Call($workbook, "SetEncryptionOptions", array($XOR, 40));
     $ptr->Call($workbook, "SetEncryptionOptions", array($crypt, 128));
     $settings = $ptr->Get($workbook, "Settings", array());
     $ptr->Set($settings, "Password", "1234", array());
     $ptr->Call($workbook, "Save", array($dataDir . "/encryptedoutBook1.xls"));
     print "Completed." . PHP_EOL;
 }
开发者ID:xiurui12345,项目名称:Aspose_Cells_NET,代码行数:19,代码来源:EncryptingFiles.php


注:本文中的COM::Set方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。