我使用xls2csv二进制文件在我的linux red hat机器中将XLS文档转换为CSV，
在某些情况下，XLS文档在单词前或单词后有空格
XLS文件示例（word3右侧有一个空格）
word1 word2 "word3 "
word1 word2 "word3 "
word1 word2 "word3 "
在我运行xls2csv之后
作为：
xls2csv -x "1252spreadsheet.xls" -b WINDOWS-1252 -c "ut8csvfile.csv" -a UTF-8 )
我注意到csv文档中的word3和XLS中的word3有相同的空间（“word3”）
请建议如何配置xls2csv二进制文件以禁用空格？??？从XLS文档，所以我将得到没有空格的CSV？
从XLS2CSV手册页：
man xls2csv
XLS2CSV(1) User Contributed Perl Documentation XLS2CSV(1)
NAME
xls2csv - A script that recodes a spreadsheetâs charset and saves as CSV.
DESCRIPTION
This script will recode a spreadsheet into a different character set and output the recoded data as a csv file.
The script came about after many headaches from dealing with Excel spreadsheets from clients that were being
received in various character sets.
OPTIONS
-x : filename of the source spreadsheet
-b : the character set the source spreadsheet is in (before)
-c : the filename to save the generated csv file as
-a : the character set the csv file should be converted to (after)
-q : quiet mode
-s : print a list of supported character sets
-h : print help message
-v : get version information
-W : list worksheets in the spreadsheet specified by -x
-w : specify the worksheet name to convert (defaults to the first worksheet)
-n : specify the worksheet number to convert (you cannot use this option with -w)
-f : force the worsheet to be fully parsed. This disables the feature that skips rows when the first cell is blk
最佳答案
我觉得你用错工具了。也许您应该编写一个脚本，使用Spreadsheet：：ParseExcel读取/分析xls文件，然后应用所需的任何字段重新格式化。完成后，使用Text：：CSV XS输出CSV数据。
编辑：我本想把它作为一个评论，但我想它也可以作为一个答案。