linux excel转csv

最新推荐文章于 2025-07-15 23:39:50 发布

young-ming

最新推荐文章于 2025-07-15 23:39:50 发布

阅读量1w

点赞数

CC 4.0 BY-SA版权

分类专栏：其他

本文链接：https://blog.youkuaiyun.com/u011750989/article/details/52061733

其他专栏收录该内容

7 篇文章

订阅专栏

这篇博客介绍了两种在Linux环境下将Excel文件转换为CSV文件的方法：一是使用gnumeric提供的ssconvert工具，二是通过Python的xlrd和csv库自定义脚本实现转换。详细步骤包括安装相关软件和运行相应命令。

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

1、

excel自动转化为csv

yum install gnumeric

ssconvert myexcel.xlsx myexcel.csv

2、

pip install xlrd

covert_xls.py

import logging
import time
import traceback
import xlrd
import csv
import sys
import re

logging.basicConfig(level=logging.INFO, format='%(asctime)s %(message)s')


def csv_from_excel():
    xls = sys.argv[1]
    target = sys.argv[2]

    logging.info("Start converting: From '" + xls + "' to '" + target + "'. ")

    try:
        start_time = time.time()
        wb = xlrd.open_workbook(xls)
        sh = wb.sheet_by_index(0)

        csvFile = open(target, 'wb')
        wr = csv.writer(csvFile, quoting=csv.QUOTE_ALL)

        for row in xrange(sh.nrows):
            rowValues = sh.row_values(row)

            newValues = []
            for s in rowValues:
                if isinstance(s, unicode):
                    strValue = (str(s.encode("utf-8")))
                else:
                    strValue = (str(s))

                isInt = bool(re.match("^([0-9]+)\.0$", strValue))

                if isInt:
                    strValue = int(float(strValue))
                else:
                    isFloat = bool(re.match("^([0-9]+)\.([0-9]+)$", strValue))
                    isLong  = bool(re.match("^([0-9]+)\.([0-9]+)e\+([0-9]+)$", strValue))

                    if isFloat:
                        strValue = float(strValue)

                    if isLong:
                        strValue = int(float(strValue))

                newValues.append(strValue)

            wr.writerow(newValues)

        csvFile.close()

        logging.info("Finished in %s seconds", time.time() - start_time)

    except Exception as e:
        print (str(e) + " " +  traceback.format_exc())


csv_from_excel()

python covert_xls.py test.xls test.csv