writeData($range, $values);
// echo "寫入格數" .$result;
// echo "
";
//read data
$sheets_name=['RAG開課前','RAG開課中','RAG課程尾聲'];
$result = [];
foreach($sheets_name as $sheet_name){
$values = $assistant->readData("$sheet_name!A:B");
$result = array_merge($result, $values);
// foreach($values as $row){
// echo implode("\t",$row)."\n";
// }
// echo "\n\n";
// echo ""; print_r($values); echo "
";
// echo "
";
}
echo json_encode($result);
//find first empty
// $emptyRow = $assistant->findFirstEmptyRow("testing!A:B");
// echo "第一個空白列 Row Index:" .$emptyRow;