php - 导入时如何删除csv文件单元格中字符串后的空格
问题描述
我有一个文件 test.xml,我试图上传它,但在第一行 model_no 在字符串后面有一些空格,这将使我的单元格值为空,如何在读取代码 img 中的数据时将其删除:https://i.stack.imgur.com/eYQdH.png
$errors = [];
$importData = Excel::load($request->file('filename')->getRealPath(), function ($reader) use (&$errors) {
$headerRow = $reader->first()->keys()->toArray();
print_r($reader->toArray());
if (!in_array("model_no", $headerRow)) {
$errors[] = 'Column model_no does not exists';
}
if (!in_array("price", $headerRow)) {
$errors[] = 'Column price does not exists';
}
if (!in_array("qty", $headerRow)) {
$errors[] = 'Column qty does not exists';
}
return $errors;
})->get()->toArray();
$reader->toArray() 这会给我的结果是
Array(
[0] => Array
(
[company_id] => 1
[category] => BMS
[product_type] => single
[manufacturer] => 98
[products] =>
[model_no] =>
[price] => 43200
[units] => nos
[max_discount] => 45
[tax] => 18
[hsn_code] => 998732
[weight] => 1
[qty] => 0
[min_qty] => 0
[enable_disable] => 1
[warranty] => 0
)
);
作曲家.json 文件
{
"name": "laravel/laravel",
"description": "The Laravel Framework.",
"keywords": ["framework", "laravel"],
"license": "MIT",
"type": "project",
"require": {
"php": "^7.1.3",
"barryvdh/laravel-dompdf": "^0.8.4",
"daltcore/lara-pdf-merger": "^2.0",
"davejamesmiller/laravel-breadcrumbs": "^5.0",
"fideloper/proxy": "^4.0",
"intervention/image": "^2.4",
"laravel/framework": "5.6.*",
"laravel/tinker": "^1.0",
"laravelcollective/html": "^5.6",
"maatwebsite/excel": "~2.1.0",
"mpdf/mpdf": "^7.1",
"ntwindia/ntwindia": "^1.0",
"unisharp/laravel-filemanager": "~1.8"
},
"require-dev": {
"filp/whoops": "^2.0",
"fzaninotto/faker": "^1.4",
"mockery/mockery": "^1.0",
"nunomaduro/collision": "^2.0",
"phpunit/phpunit": "^7.0"
},
"autoload": {
"classmap": [
"database/seeds",
"database/factories"
],
"psr-4": {
"App\\": "app/"
}
},
"autoload-dev": {
"psr-4": {
"Tests\\": "tests/"
}
},
"extra": {
"laravel": {
"dont-discover": [
]
}
},
"scripts": {
"post-root-package-install": [
"@php -r \"file_exists('.env') || copy('.env.example', '.env');\""
],
"post-create-project-cmd": [
"@php artisan key:generate"
],
"post-autoload-dump": [
"Illuminate\\Foundation\\ComposerScripts::postAutoloadDump",
"@php artisan package:discover"
]
},
"config": {
"preferred-install": "dist",
"sort-packages": true,
"optimize-autoloader": true
},
"minimum-stability": "dev",
"prefer-stable": true
}
解决方案
推荐阅读
- angular - 角 http 订阅被 CORS 策略阻止
- excel - EXCEL VBA:查找代码以重命名具有指定名称的指定工作表,均基于单元格值
- java - Android 应用程序链接不适用于实际的 android 设备浏览器
- angular - 如何解决声纳问题“更新或重构此功能,使其实现不会重复第 xxx 行的那个”
- php - Laravel 中间件限制对不需要的功能的访问
- php - 无法使用 php 脚本
- flutter - 如何修复构建函数返回 null。?
- php - php docker如何使用file_get_contents来获取自己域的结果
- javascript - 如何将json数据传递给Angular中的Class变量?
- julia - Julia 中是否有估计边际均值或边际效应的软件包?