# PHP での数式の計算

Contents
[ ]

## 数式の計算

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());

\$worksheets = \$ptr->Get(\$workbook,"Worksheets",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->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;