在PHP中向现有Excel文件添加工作表
Contents
[
Hide
]
向现有Excel文件添加工作表
向现有Excel文件添加工作表
PHP 代码
$dataDir = '';
// 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;
下载运行代码
从下面提到的任何社交编码站点下载向现有Excel文件添加工作表(Aspose.Cells)