php json xls,PHPExcel-将JSON数据写入Excel

最新推荐文章于 2021-09-20 18:50:03 发布
最新推荐文章于 2021-09-20 18:50:03 发布
阅读量226 收藏
点赞数
文章标签： php json xls

JSON数据格式:

2016-08-17.json

{

"flights": [

{

"from": "Beijing",

"duration": "19h50m",

"class": "Economy",

"flight": "|DL128|DL129",

"departureAirport": "Beijing Capital International Airport",

"stops": "2+ stops",

"airline": "Delta Air Lines",

"to": "Seattle",

"arriveTime": "Wed Aug 17 16:10",

"departureTime": "Wed Aug 17 11:20",

"price": "|7524|7995",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR|STU",

"flightType": "|UNCERTAIN|Boeing 737-800"

},

{

"from": "Beijing",

"duration": "22h26m",

"class": "Economy",

"flight": "|DL128|DL2492",

"departureAirport": "Beijing Capital International Airport",

"stops": "2+ stops",

"airline": "Delta Air Lines",

"to": "Seattle",

"arriveTime": "Wed Aug 17 18:46",

"departureTime": "Wed Aug 17 11:20",

"price": "|7524|7995",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR|STU",

"flightType": "|UNCERTAIN|Boeing 737-800"

},

{

"from": "Beijing",

"duration": "20h55m",

"class": "Economy",

"flight": "|DL128|DL848",

"departureAirport": "Beijing Capital International Airport",

"stops": "2+ stops",

"airline": "Delta Air Lines",

"to": "Seattle",

"arriveTime": "Wed Aug 17 17:15",

"departureTime": "Wed Aug 17 11:20",

"price": "|7524|7995",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR|STU",

"flightType": "|UNCERTAIN|Boeing 737-800"

},

{

"from": "Beijing",

"duration": "15h5m",

"class": "Economy",

"flight": "|BR715|BR026",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "EVA Air",

"to": "Seattle",

"arriveTime": "Wed Aug 17 19:50",

"departureTime": "Wed Aug 17 19:45",

"price": "|7675|7689",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR|NOR",

"flightType": "|Boeing 747-400|Boeing 777-300ER"

},

{

"from": "Beijing",

"duration": "11h32m",

"class": "Economy",

"flight": "|DL128",

"departureAirport": "Beijing Capital International Airport",

"stops": "Nonstop",

"airline": "Delta Air Lines",

"to": "Seattle",

"arriveTime": "Wed Aug 17 07:52",

"departureTime": "Wed Aug 17 11:20",

"price": "|9332|10304|14104",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|STU|NOR|NOR",

"flightType": "|Boeing767-300"

},

{

"from": "Beijing",

"duration": "15h58m",

"class": "Economy",

"flight": "|UA889|UA322",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "United Airlines",

"to": "Seattle",

"arriveTime": "Wed Aug 17 12:58",

"departureTime": "Wed Aug 17 12:00",

"price": "|9649",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing 747-400|Boeing 737-900"

},

{

"from": "Beijing",

"duration": "30h20m",

"class": "Economy",

"flight": "|KE854|KE019",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "Korean Air",

"to": "Seattle",

"arriveTime": "Thu Aug 18 12:35",

"departureTime": "Wed Aug 17 21:15",

"price": "|9844|11822",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR|SEA",

"flightType": "|Airbus A330-300|Boeing 777-300ER"

},

{

"from": "Beijing",

"duration": "13h54m",

"class": "Economy",

"flight": "|AC030|AC8097",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "Air Canada",

"to": "Seattle",

"arriveTime": "Wed Aug 17 14:59",

"departureTime": "Wed Aug 17 16:05",

"price": "|11626",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing 777-300ER|TBD"

},

{

"from": "Beijing",

"duration": "10h55m",

"class": "Economy",

"flight": "|HU495",

"departureAirport": "Beijing Capital International Airport",

"stops": "Nonstop",

"airline": "Hainan Airlines",

"to": "Seattle",

"arriveTime": "Wed Aug 17 11:35",

"departureTime": "Wed Aug 17 15:40",

"price": "|12996",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Airbus A330-300"

},

{

"from": "Beijing",

"duration": "28h15m",

"class": "Economy",

"flight": "|CA983|VX781",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "",

"to": "Seattle",

"arriveTime": "Thu Aug 18 10:15",

"departureTime": "Wed Aug 17 21:00",

"price": "|13500",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing 777-300ER|Airbus A319"

},

{

"from": "Beijing",

"duration": "26h39m",

"class": "Economy",

"flight": "|MU5160|DL588",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "",

"to": "Seattle",

"arriveTime": "Thu Aug 18 09:19",

"departureTime": "Wed Aug 17 21:40",

"price": "|13733",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Airbus A320|Boeing767-300"

},

{

"from": "Beijing",

"duration": "24h20m",

"class": "Economy",

"flight": "|CA981|UA1858",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "",

"to": "Seattle",

"arriveTime": "Wed Aug 17 22:20",

"departureTime": "Wed Aug 17 13:00",

"price": "|15409",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing 747|Airbus A320"

},

{

"from": "Beijing",

"duration": "15h44m",

"class": "Economy",

"flight": "|CA985|UA424",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "",

"to": "Seattle",

"arriveTime": "Wed Aug 17 16:24",

"departureTime": "Wed Aug 17 15:40",

"price": "|15409",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing 747|Airbus A320"

},

{

"from": "Beijing",

"duration": "37h5m",

"class": "Economy",

"flight": "|LH7321|LH490",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "Lufthansa",

"to": "Seattle",

"arriveTime": "Thu Aug 18 12:05",

"departureTime": "Wed Aug 17 14:00",

"price": "|17922",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing 747|Boeing 747-400"

},

{

"from": "Beijing",

"duration": "11h32m",

"class": "Economy",

"flight": "|CZ1155",

"departureAirport": "Beijing Capital International Airport",

"stops": "Nonstop",

"airline": "China Southern Airlines",

"to": "Seattle",

"arriveTime": "Wed Aug 17 07:52",

"departureTime": "Wed Aug 17 11:20",

"price": "|17927",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing767-300"

},

{

"from": "Beijing",

"duration": "14h40m",

"class": "Business",

"flight": "|NH956|DL166",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "",

"to": "Seattle",

"arriveTime": "Wed Aug 17 09:30",

"departureTime": "Wed Aug 17 09:50",

"price": "|21086",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing-787|Boeing 747-400"

},

{

"from": "Beijing",

"duration": "19h9m",

"class": "Business",

"flight": "|AA186|AA2674",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "American Airlines",

"to": "Seattle",

"arriveTime": "Wed Aug 17 14:19",

"departureTime": "Wed Aug 17 10:10",

"price": "|21644",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing787-800|Boeing 737-800"

},

{

"from": "Beijing",

"duration": "16h35m",

"class": "Economy",

"flight": "|NH956|NH178",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "ANA",

"to": "Seattle",

"arriveTime": "Wed Aug 17 11:25",

"departureTime": "Wed Aug 17 09:50",

"price": "|23922",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Boeing787-800|Boeing787-800"

},

{

"from": "Beijing",

"duration": "28h",

"class": "Business",

"flight": "|EK307|EK229",

"departureAirport": "Beijing Capital International Airport",

"stops": "1 stop",

"airline": "Emirates",

"to": "Seattle",

"arriveTime": "Thu Aug 18 12:55",

"departureTime": "Wed Aug 17 23:55",

"price": "|41458",

"arrivalAirport": "Seattle–Tacoma International Airport",

"passengerType": "|NOR",

"flightType": "|Airbus A380-800|Boeing 777-300ER"

}

],

"count": 19,

"date": "2016-08-17"

}

PHPExcel把JSON写入到Excel

require_once dirname(__FILE__) . '/Classes/PHPExcel.php';

$filename = "./jsonfile/2016-08-17.json";

$json_string = file_get_contents($filename);

//echo print_r($json_string,true); //打印文件的内容

//echo "
";

$array = json_decode($json_string,true);

if (!is_array($array)){

die('no successful');

}

// echo "

";

// print_r($array);

// echo "

";

$flightsArray = $array['flights'];

// echo "

";

// print_r($flightsArray);

// echo "

";

$sortFlightsArray = array();

for ($i=0; $i < count($flightsArray); $i++) {

# code...

$tempArray = array();

$tempArray['from'] = $flightsArray[$i]['from'];

$tempArray['to'] = $flightsArray[$i]['to'];

$tempArray['departureAirport'] = $flightsArray[$i]['departureAirport'];

$tempArray['departureTime'] = $flightsArray[$i]['departureTime'];

$tempArray['arrivalAirport'] = $flightsArray[$i]['arrivalAirport'];

$tempArray['arriveTime'] = $flightsArray[$i]['arriveTime'];

$tempArray['duration'] = $flightsArray[$i]['duration'];

$tempArray['airline'] = $flightsArray[$i]['airline'];

$tempArray['flightType'] = $flightsArray[$i]['flightType'];

$tempArray['flight'] = $flightsArray[$i]['flight'];

$tempArray['stops'] = $flightsArray[$i]['stops'];

$tempArray['class'] = $flightsArray[$i]['class'];

$tempArray['price'] = $flightsArray[$i]['price'];

$tempArray['passengerType'] = $flightsArray[$i]['passengerType'];

$sortFlightsArray[$i] = $tempArray;

}

// echo "

";

// print_r($sortFlightsArray);

// echo "

";

//********************************************************************************

// Create new PHPExcel object

$objPHPExcel = new PHPExcel();

// Fill worksheet from values in array

$objPHPExcel->getActiveSheet()->fromArray($sortFlightsArray, null, 'A1');

// Rename worksheet

$objPHPExcel->getActiveSheet()->setTitle('Members');

// Set AutoSize for name and email fields

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);

$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);

// Save Excel 2007 file

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

$objWriter->save("./2016-08-17.xlsx");

?>

生成的Excel文件

1092396f0a82?nomobile=yes

PHPExcel生成的excel文件.png

参考资料：

Fatal error: 'break' not in the 'loop' or 'switch' context in

\PHPExcel\PHPExcel\Calculation\Functions.php on line 581

需要把PHPExcel官方库的Functions.php代码的581行break删掉

1092396f0a82?nomobile=yes

需要把PHPExcel官方库的Functions.php代码的581行 break； 删掉.png

weixin_39526564
关注
将json数据转化为excel表格文件
m0_46649866的博客
12-03 2960
js将json数据转化为excel表格文件
thinkphp5.0+PHPExcel-demo
03-01
4. **写入Excel文件**：创建新的Excel工作簿，设置工作表和单元格数据，最后用`WriterInterface`的子类（如`PHPExcel_Writer_Excel2007`）保存文件。 5. **错误处理**：考虑可能出现的文件不存在、权限不足或数据...
php输出json到表格,Vue如何导出json数据到Excel电子表格方法
weixin_30974667的博客
03-22 335
本文主要介绍了Vue导出json数据到Excel电子表格的示例，小编觉得挺不错的，现在分享给大家，也给大家做个参考，希望能帮助到大家。一、安装依赖(前面基本一样)npm install file-saver --savenpm install xlsx --savenpm install script-loader --save-dev二、下载两个所需要的js文件Blob.js和 Export2E...
csv文件怎么转成excel_Java读写excel,excel转成json写入磁盘文件
weixin_39800387的博客
11-05 143
pom读写excel主要的dependency <dependency> <groupId>org.apache.poigroupId> <artifactId>poiartifactId> <version>3.16version> dependency> <depend...
phpexcel将json转excel
肿有刁民想呀么想害朕……！
12-11 1762
<?php header ( "Content-type: text/html; charset=utf-8" ); date_default_timezone_set ( 'PRC' ); //设置中国时区 include 'PHPExcel.php'; $dir=dirname(__FILE__); $filename = "/Users/jiangminghui/Documents
java json 写入excel_用java解析从接口获取json内容并用XSSFWorkbook写到excel(.xlsx)
weixin_35009700的博客
02-27 298
importcom.alibaba.fastjson.JSONArray;importcom.alibaba.fastjson.JSONObject;importorg.apache.poi.xssf.usermodel.XSSFCell;importorg.apache.poi.xssf.usermodel.XSSFRow;importorg.apache.poi.xssf.usermodel....
phpExcel导出大量数据出现内存溢出错误的解决方法
10-27
例如，对于大量数据，可以先将数据分批写入不同的sheet中，然后再通过AJAX进行分批导出。这样既避免了内存溢出，也提高了用户体验。 总之，针对phpExcel在导出大量数据时出现的内存溢出问题，我们可以通过采用不同...
tp把excel到入到数据库(phpexcel)
06-14
PHPExcel是一款强大的PHP库，它允许我们读取、写入以及操作多种电子表格格式，包括微软的Excel（.xls, .xlsx）和OpenOffice的Calc（.ods）等。通过这个库，我们可以方便地将Excel文件的数据提取出来，然后插入到...
reading XLS file using php-开源
06-29
要开始使用`php-excel_reader`，首先需要下载并将其解压到你的PHP项目中。如果使用Composer管理依赖，可以在`composer.json`中添加如下依赖： ``` "require": { "php-excel/php-excel_reader": "^2.26" } ``` ...
PHP Excel导入实例Demo
03-12
此外，对于写入Excel，PHPExcel也提供了类似的方法，只是方向相反，将数据写入到Excel文件中。 总的来说，“PHP Excel导入实例Demo”是一个实用的教程，它帮助开发者理解如何在Thinkphp5.0框架下有效地处理Excel...
基于PHP的EXCEL的XLS转换为JSON或XML格式
08-22
基于PHP的开源功能 将EXCEL的XLS转换为JSON或XML格式 XLS第一行必需为TITLE, 内容不能有公式(请通过选择性粘贴处理) 内有示例XLS 通过PHP服务器访问index.php即可.
python json格式写入表格,从Python将分层JSON数据写入Excel xls吗？
weixin_42318708的博客
12-24 268
I want to write some data from python to xlsx. I currently have it stored as JSON, but it doesn't matter what it is going out of Python. Here's what the JSON for a single article would look like:{'Wor...
纯JavaScript 实现JSON数据导出到Excel(支持多个Sheet页)
CharlesRan888的博客
09-20 2696
核心思想: 拿到JSON 格式的数据后,使用JS逻辑生成符合 EXCEL格式规范的XML字符串 然后转字符串内容把换成一个Blob 实例对象 最后通过 临时创建的一个A标签通过触发它的点击事件模拟浏览器文件下载功能即可。 (1) 第一步 得到JSON 格式的数据 这里以下面随意搞的模拟json数据为例进行说明(实际可以根据自己的数据做改动) { "moneytype": [ { "typeid": "t1", "name": "太平养老颐...
php 转换json 表格,将json格式转化为excel表格（详细教程）
weixin_34982726的博客
03-09 877
下面我就为大家分享一篇javascript将json格式数组下载为excel表格的方法，具有很好的参考价值，希望对大家有所帮助。实例如下：$(document).ready(function(){$('#wwo').click(function(){var data = {"title":[{"value":"A1标题"},{"value":"B1标题"}],"data":[[{"value":"...
java实现从文件中获取json，并转存到excel中
z710757293的博客
02-02 1477
昨天测试让帮忙处理一下接口返回数据，数据量太大，处理费劲???? 主要需求： 接口返回的数据是个长json，需要把其中的某些字段提取出来存到excel 需要提取的字段与数据：ID，NAME，NM_CODE，SPEC_ID 思路： 1.因为json过长，所以就先存到txt中，用fileReader和StringBuffer获取整个json字符串 2.获取到的字符串通过fastjson转换为List<Map>格式 3.把转换后的list转换成excel工作簿，通过fileOutputStream写到
json写入数据库或生成excel
分享博主日常学习和使用的一些技术
08-18 2695
通过curl爬取接口获得的数据格式为JSON,想把json数据存放到数据库中或者存放进excel表格，应该怎么做？ 【注意：这里的json格式为list里面有map [{“id”: 1, “name”:”lineuman”}, {“id”: 2, “name”:”lineuman”}]】 这让我想起了把大象装冰箱总共分几步？ 1.读取JSON字符串 2.将json转化为INSERT或upd...
php输出json到表格,PHP中把数据库查询结果输出为json格式
weixin_39864738的博客
03-22 381
header("Content-type:text/html;charset=utf-8");//字符编码设置$servername = "localhost";$username = "root";$password = "root";$dbname = "tjks";// 创建连接$con =mysqli_connect($servername, $username, $password, $...
读取JSONArray 数据件 写入到excel中
银河系天城知识宝库_技术专家蒋浩宇
12-23 886
实现效果 目录 实现效果 介绍 创建文件夹 打开文件 创建表头 写入表内容数据 完整代码 介绍 介绍 1.编写一个方法，传入JSONArray 2.如果是list数据同样道理 3.通过传入的数据进行遍历 4.创建对应的文件 5.创建对应的excel，的行 6.创建行的列内容 7.写入表头 8.写入每一个单元内容 9.校验信息 10.直接用最后的完整文件 创建文件夹 String tempFileDir = "D:/test/09874/"; ...
HTML POST提交参数给PHP并返回json，上传execl文件
a_靖的博客
05-17 4183
微信小程序开发交流qq群 173683895 承接微信小程序开发。扫码加微信。 正文： 需求：AJAX post带参数请求接口，PHP接收后存入数据库；然后返回json数据循环渲染到HTML <!DOCTYPE html> <html lang="zh"> <head> <meta charset="UTF-8"> &...
使用PHPExcel PHP类读取EXCEL数据
"该资源提供了一个PHP类，用于读取EXCEL文件，依赖于PHPExcel扩展。类中包含了一些属性用于设置文件路径、工作表、是否包含标题、读取页数和每页记录数等，同时提供了计算总行数、总列数和总页数的方法。在构造函数...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值