소규모 프로그램 개발을 위해 PHP를 사용하여 데이터 가져오기 및 내보내기

<?php
require_once 'PHPExcel/PHPExcel.php';

$excel = PHPExcel_IOFactory::load("data.xlsx");
$sheet = $excel->getActiveSheet();

$data = array();
foreach ($sheet->getRowIterator() as $row) {
    $rowData = array();
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(FALSE);
    
    foreach ($cellIterator as $cell) {
        $rowData[] = $cell->getValue();
    }
    $data[] = $rowData;
}

print_r($data);
?>

<?php
$file = fopen("data.csv", "r");

$data = array();
while (($row = fgetcsv($file)) !== false) {
    $data[] = $row;
}

fclose($file);

print_r($data);
?>

<?php
require_once 'PHPExcel/PHPExcel.php';

$data = array(
    array('Name', 'Age', 'City'),
    array('John', 25, 'New York'),
    array('Alice', 30, 'Los Angeles'),
    array('Bob', 35, 'Chicago')
);

$excel = new PHPExcel();

$sheet = $excel->getActiveSheet();
$sheet->fromArray($data, NULL, 'A1');

$writer = PHPExcel_IOFactory::createWriter($excel, 'Excel2007');
$writer->save('data.xlsx');
?>

<?php
$data = array(
    array('Name', 'Age', 'City'),
    array('John', 25, 'New York'),
    array('Alice', 30, 'Los Angeles'),
    array('Bob', 35, 'Chicago')
);

$file = fopen('data.csv', 'w');

foreach ($data as $row) {
    fputcsv($file, $row);
}

fclose($file);
?>