如何在已经存在的 excel 文件中添加工作表


How to add Worksheet in an already existent excel file

我正在使用 pear.php.net 提供的"Writer.php"文件来生成excel文件。我发现很难做的是将工作表添加到现有的工作簿中。我尝试了一些事情,但未能添加工作表。我在OOP方面真的很差,任何帮助将不胜感激。提前谢谢。

以下是生成 excel 文件的 php 代码:

<?php
session_start();
require_once('Spreadsheet/Excel/Writer.php');
include ("config.php");
$username = $_SESSION['username'];
$uid = $_SESSION['uid'];
$name_in_logo=$_POST['name_in_logo'];
if (!is_dir($username))
{     
$oldumask = umask(0); 
mkdir($username, 0777); 
umask($oldumask); 
}
$now = new DateTime(null, new DateTimeZone('Asia/Kolkata'));
$date_time = $now->format('d-m-Y H:i:s');
$filename1 = $username;
$filename2 = "_Design Brief ";
$filename3 = ".xls";
$final_filename = $filename1.$filename2.$date_time.$filename3;
$path_xls = "/";
$path_to_xls = $username.$path_xls.$final_filename;
$workbook = new Spreadsheet_Excel_Writer($path_to_xls);
$_SESSION['objworkbook'] = $workbook;
$worksheet =& $workbook->addWorksheet('Design Brief Details');
$worksheet->write(0, 0, 'uid');
$worksheet->write(0, 1, $uid);
$worksheet->write(1, 0, 'name_in_logo');
$worksheet->write(1, 1, $name_in_logo);
$workbook->close();
?>

不能使用 Spreadsheet_Excel_Writer 读取现有文件。