linux xls转csv

sudo apt-get install libreoffice-calc  # 安装LibreOffice Calc
ssconvert input.xls output.csv          # 转换XLS到CSV

import pandas as pd

# 读取XLS文件
xls = pd.ExcelFile('input.xls')

# 将每个工作表转换为CSV
for sheet_name in xls.sheet_names:
    df = pd.read_excel(xls, sheet_name=sheet_name)
    df.to_csv(f'{sheet_name}.csv', index=False)

use Spreadsheet::ParseExcel;
use Text::CSV;

my $parser   = Spreadsheet::ParseExcel->new();
my $workbook = $parser->parse('input.xls');

my $csv = Text::CSV->new({ binary => 1 });

foreach my $worksheet ($workbook->worksheets()) {
    my ($row_min, $row_max) = $worksheet->row_range();
    my ($col_min, $col_max) = $worksheet->col_range();

    open(my $fh, '>', 'output.csv') or die "Could not open 'output.csv' $!";

    for my $row ($row_min .. $row_max) {
        my @data;
        for my $col ($col_min .. $col_max) {
            push @data, $worksheet->get_cell($row, $col)->value();
        }
        $csv->print($fh, \@data);
    }

    close $fh;
}

df.to_csv('output.csv', index=False, encoding='utf-8')

df.to_csv('output.csv', index=False, quoting=csv.QUOTE_ALL)