怎么快速将 打印出的数组 转到wps 的表格中

文章概述了2022年12月的几笔交易记录,涉及商品如帽子、袜子等在沃尔玛平台上的销售、购买、调整情况,以及配送服务和价格信息。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Array
(
    [0] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => 2022_12_17_90569
            [5] => 12/16/2022
            [6] => Sale
            [7] => Purchase
            [8] => 200010832347181
            [9] => 5
            [10] => 108735069882169
            [11] => 1
            [12] => 15.99
            [13] => Product Price
            [14] => 1
            [15] => 
            [16] => 
            [17] => USXJ-012-MH-1-WFS
            [18] => 08593249563471
            [19] => Senker 3 Pacs Winter Beanie Hat Scarf and Touch Screen Gloves Set for Men Women
            [20] => 2038356
            [21] => PA
            [22] => Saylorsburg
            [23] => 18353
            [24] => Apparel & Accessories
            [25] => Hat  Scarf & Glove Sets
            [26] => BSE-57-8.0
            [27] => Marketplace expedited
            [28] => Walmart-fulfilled(WFS)
            [29] => Delivery
            [30] => 
            [31] => 
            [32] => 
            [33] => 
        )

    [1] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => 2022_12_14_1142524
            [5] => 12/13/2022
            [6] => Sale
            [7] => Purchase
            [8] => 200010789734501
            [9] => 1
            [10] => 108734760225512
            [11] => 1
            [12] => 17.99
            [13] => Product Price
            [14] => 1
            [15] => 
            [16] => 
            [17] => USXJ-002-KNEE-1-WFS
            [18] => 08593249562887
            [19] => Loritta 6 Pairs Womens Thigh High Socks Over the Knee High Socks Style a
            [20] => 2038710
            [21] => OH
            [22] => Berlin Heights
            [23] => 44814
            [24] => Apparel & Accessories
            [25] => Socks
            [26] => BSE-57-8.0
            [27] => Marketplace expedited
            [28] => Walmart-fulfilled(WFS)
            [29] => Delivery
            [30] => 
            [31] => 
            [32] => 
            [33] => 
        )

    [2] => Array
        (
            [0] => 
            [1] => 
            [2] => 
            [3] => 
            [4] => 2022_12_14_1246730
            [5] => 12/13/2022
            [6] => Sale
            [7] => Purchase
            [8] => 200010789376794
            [9] => 1
            [10] => 108734862811386
            [11] => 1
            [12] => 11.69
            [13] => Product Price
            [14] => 1
            [15] => 
            [16] => 
            [17] => USXJ-004-WWS-5-WFS
            [18] => 08593249563167
            [19] => Loritta 5 Pairs Womens Socks Wool Socks Cashmere Thick Knit Warm Winter Socks for Women Gifts
            [20] => 2038356
            [21] => CA
            [22] => San Luis Obispo
            [23] => 93405
            [24] => Apparel & Accessories
            [25] => Socks
            [26] => BSE-57-8.0
            [27] => Marketplace expedited
            [28] => Walmart-fulfilled(WFS)
            [29] => Delivery
            [30] => 
            [31] => 
            [32] => 
            [33] => 
        )

Transaction TypeCustomer Order #Purchase Order #Ship QtyPartner Item Id
Adjustment200010832347181108735069882169USXJ-012-MH-1-WFS
Sale2000108323471811087350698821691USXJ-012-MH-1-WFS
Sale2000108323471811087350698821691USXJ-012-MH-1-WFS
Sale2000107897345011087347602255121USXJ-002-KNEE-1-WFS
Sale2000107897345011087347602255121USXJ-002-KNEE-1-WFS
Sale2000107897345011087347602255121USXJ-002-KNEE-1-WFS
Sale2000107897345011087347602255121USXJ-002-KNEE-1-WFS
Adjustment200010789734501108734760225512USXJ-002-KNEE-1-WFS
Sale2000107893767941087348628113861USXJ-004-WWS-5-WFS
Sale2000107893767941087348628113861USXJ-004-WWS-5-WFS
Sale2000107893767941087348628113861USXJ-004-WWS-5-WFS
Sale2000107893767941087348628113861USXJ-004-WWS-5-WFS
Adjustment200010789376794108734862811386USXJ-004-WWS-5-WFS
Sale2000107884755551087348623122781USXJ-007-FS-3-WFS
Sale2000107884755551087348623122781USXJ-007-FS-3-WFS
Sale2000107884755551087348623122781USXJ-007-FS-3-WFS
Sale2000107884755551087348623122781USXJ-007-FS-3-WFS
Adjustment200010788475555108734862312278USXJ-007-FS-3-WFS
Adjustment200010787593709108735173876307USXJ-010-WH-1-WFS
Sale2000107875937091087351738763071USXJ-010-WH-1-WFS
Sale2000107875937091087351738763071USXJ-010-WH-1-WFS
Sale2000107875937091087351738763071USXJ-010-WH-1-WFS
Sale2000107875937091087351738763071USXJ-010-WH-1-WFS
Adjustment200010787436744108734448272705USXJ-002-KNEE-3-WFS

代码:

        $header = [

            'Period Start Date',

            'Period End Date',

            'Total Payable',

            'Currency',

            'Transaction Key',

            'Transaction Posted Timestamp',

            'Transaction Type',

            'Transaction Description',

            'Customer Order #',

            'Customer Order line #',

            'Purchase Order #',

            'Purchase Order line #',

            'Amount',

            'Amount Type',

            'Ship Qty',

            'Commission Rate',

            'Transaction Reason Description',

            'Partner Item Id',

            'Partner GTIN',

            'Partner Item Name',

            'Product Tax Code',

            'Ship to State',

            'Ship to City',

            'Ship to Zipcode',

            'Contract Category',

            'Product Type',

            'Commission Rule',

            'Shipping Method',

            'Fulfillment Type',

            'Fulfillment Details',

            'Original Commission',

            'Commission Incentive Program',

            'Commission Saving',

            'Customer Promo Type',

            'Campaign Id'

        ];

       

        $file = 'data.csv'; // 保存的文件名

       

        $handle = fopen($file, 'w');

       

        // 写入表头

        fputcsv($handle, $header);

       

        // 写入数据行

        foreach ($diffDataOne as $row) {

            fputcsv($handle, $row);

        }

       

        fclose($handle);

       

        // 下载文件

        header('Content-Type: text/csv');

        header('Content-Disposition: attachment; filename=' . $file);

        readfile($file);

       

        // 删除临时文件

        unlink($file);

        exit;

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值