在 PHP 中插入和删除行和列

Aspose.Cells - 管理行/列

插入行

通过调用 Cells 集合的 insertRows 方法在任意位置插入一行。 insertRows 方法将要插入新行的行索引作为第一个参数,将要插入的行数作为第二个参数。

PHP代码

 public static function insert_row($dataDir)

{

    # Instantiating a Workbook object by excel file path

    $workbook = new Workbook($dataDir . 'Book1.xls');

    # Accessing the first worksheet in the Excel file

    $worksheet = $workbook->getWorksheets()->get(0);

    # Inserting a row into the worksheet at 3rd position

    $worksheet->getCells()->insertRows(2,1);

    # Saving the modified Excel file in default (that is Excel 2003) format

    $workbook->save($dataDir . "Insert Row.xls");

    print "Insert Row Successfully." . PHP_EOL;

}  

插入多行

要将多行插入到工作表中,请调用 Cells 集合的 insertRows 方法。 InsertRows 方法有两个参数:

  • 行索引,将插入新行的行的索引。
  • 行数,需要插入的总行数。

PHP代码

 public static function insert_multiple_rows($dataDir)

{

    # Instantiating a Workbook object by excel file path

    $workbook = new Workbook($dataDir . 'Book1.xls');

    # Accessing the first worksheet in the Excel file

    $worksheet = $workbook->getWorksheets()->get(0);

    # Inserting a row into the worksheet at 3rd position

    $worksheet->getCells()->insertRows(2,10);

    # Saving the modified Excel file in default (that is Excel 2003) format

    $workbook->save($dataDir . "Insert Multiple Rows.xls");

    print "Insert Multiple Rows Successfully." . PHP_EOL;

}

删除一行

要删除任意位置的行,请调用 Cells 集合的 deleteRows 方法。 DeleteRows 方法有两个参数:

  • 行索引,将从其中删除行的行的索引。
  • 行数,需要删除的总行数。

PHP代码

 public static function delete_row($dataDir)

{

    # Instantiating a Workbook object by excel file path

    $workbook = new Workbook($dataDir . 'Book1.xls');

    # Accessing the first worksheet in the Excel file

    $worksheet = $workbook->getWorksheets()->get(0);

    # Deleting 3rd row from the worksheet

    $worksheet->getCells()->deleteRows(2,1,true);

    # Saving the modified Excel file in default (that is Excel 2003) format

    $workbook->save($dataDir . "Delete Row.xls");

    print "Delete Row Successfully." . PHP_EOL;

}

删除多行

要从工作表中删除多行,请调用 Cells 集合的 deleteRows 方法。 DeleteRows 方法有两个参数:

  • 行索引,将从其中删除行的行的索引。
  • 行数,需要删除的总行数。

PHP代码

 public static function delete_multiple_rows($dataDir)

{

    # Instantiating a Workbook object by excel file path

    $workbook = new Workbook($dataDir . 'Book1.xls');

    # Accessing the first worksheet in the Excel file

    $worksheet = $workbook->getWorksheets()->get(0);

    # Deleting 10 rows from the worksheet starting from 3rd row

    $worksheet->getCells()->deleteRows(2,10,true);

    # Saving the modified Excel file in default (that is Excel 2003) format

    $workbook->save($dataDir . "Delete Multiple Rows.xls");

    print "Delete Multiple Rows Successfully." . PHP_EOL;

}

插入列

开发人员还可以通过调用 Cells 集合的 insertColumns 方法在工作表的任意位置插入列。 insertColumns 方法有两个参数:

  • 列索引,将插入列的列的索引
  • 列数,需要插入的总列数

PHP代码

 public static function insert_column($dataDir)

{

    # Instantiating a Workbook object by excel file path

    $workbook = new Workbook($dataDir . 'Book1.xls');

    # Accessing the first worksheet in the Excel file

    $worksheet = $workbook->getWorksheets()->get(0);

    # Inserting a column into the worksheet at 2nd position

    $worksheet->getCells()->insertColumns(1,1);

    # Saving the modified Excel file in default (that is Excel 2003) format

    $workbook->save($dataDir . "Insert Column.xls");

    print "Insert Column Successfully." . PHP_EOL;

}

删除列

要从工作表中的任意位置删除列,请调用 Cells 集合的 deleteColumns 方法。 deleteColumns 方法采用以下参数:

  • 列索引,将从其中删除列的列的索引。
  • 列数,需要删除的列总数。
  • Shift cells,布尔参数,表示删除后单元格是否左移。

PHP代码

 public static function delete_column($dataDir)

{

    # Instantiating a Workbook object by excel file path

    $workbook = new Workbook($dataDir . 'Book1.xls');

    # Accessing the first worksheet in the Excel file

    $worksheet = $workbook->getWorksheets()->get(0);

    # Deleting a column from the worksheet at 2nd position

    $worksheet->getCells()->deleteColumns(1,1,true);

    # Saving the modified Excel file in default (that is Excel 2003) format

    $workbook->save($dataDir . "Delete Column.xls");

    print "Delete Column Successfully." . PHP_EOL;

}  

下载运行代码

下载**管理行/列 (Aspose.Cells)**来自以下任何一个社交编码网站: