I have a Excel file stored on my webserver which i use as a calculator. I was wondering if it's any way possible to post/send values to specific cells and then extract the result from a specific cell? I would prefer to do this by PHP.
Use phpExcel, here's an example to open and modify your existing file:
<?php
error_reporting(E_ALL);
set_time_limit(0);
date_default_timezone_set('Europe/Lisbon');
set_include_path(get_include_path() . PATH_SEPARATOR . './Classes/');
include 'PHPExcel/IOFactory.php';
$fileType = 'Excel5'; //you may have to change this value
$fileName = 'yourfile.xlsm';
// Read the file
$objReader = PHPExcel_IOFactory::createReader($fileType);
$objPHPExcel = $objReader->load($fileName);
// Change the file
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', 'Hello')
->setCellValue('B1', 'World!');
// Write the file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $fileType);
$objWriter->save($fileName);
Please refer to the official documentation and list of examples.