将curl命令转换为PHP以获取csv-> Excel转换器

Question

Looks simple enough, but I can't get this to work in PHP.

curl -F files[]=@myfile.csv 'https://www.rebasedata.com/api/v1/convert?outputFormat=xlsx&errorResponse=zip' -o output.zip

myfile.csv is my data file to convert.

output.zip is the response containing the Excel file.

It's a csv to Excel converter service from this website https://www.rebasedata.com/convert-csv-to-excel-online

Can anyone assist?

Answer 1

Try following code

set_time_limit(0);

// output file
$fp = fopen('output.zip', 'w+');

$ch = curl_init('https://www.rebasedata.com/api/v1/convert?outputFormat=xlsx&errorResponse=zip');
curl_setopt($ch, CURLOPT_POST, true);
// Adding file to request
curl_setopt($ch, CURLOPT_POSTFIELDS, ['files' => curl_file_create('myfile.csv')]);
// For returning response data
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$data = curl_exec($ch);
fwrite($fp, $data);

curl_close($ch);
fclose($fp);