Unoconv Example $ unoconv -format xls example.csv
Gnumeric_Excel:excel_biff8 | MS Excel™ 97/2000/XP Gnumeric_Excel:excel_biff7 | MS Excel™ 5.0/95 Gnumeric_Excel:xlsx | ECMA 376 1st edition (2006) You can list all supported output file formats via: $ ssconvert -list-exporters You can check the files via file: $ file example.csvĮxample.csv: ASCII text, with CRLF line terminatorsĮxample.xls: Composite Document File V2 Document, Little Endian, Os: Windows, Version 4.10,Ĭode page: 1252, Create Time/Date: Tue Sep 30 20:23:18 2014 Where the first ssconvert call creates a MS Excel 2007/2010 file and the second an old school Excel 2007 one. SSConvert Example $ echo -e 'surname,name,age\nCarlo,Smith,23\nJohn,Doe,46\nJane,Doe,69\nSarah,Meyer,23\n' \ Print "Text::CSV_XS parse() failed on argument: ", $err, "\n" įor automatically converting CSV files to XLS/XLSX ones you can also use ssconvert (which comes with Gnumeric) or unoconv (which uses LibreOffice). My $worksheet = $workbook->add_worksheet() My $workbook = Spreadsheet::WriteExcel->new( $ARGV ) Open( CSVFILE, $ARGV ) or die "$ARGV: $!" # reverse('©'), March 2001, John McNamara, strict ĭie("Usage: csv2xls csvfile.txt newfile.xls\n") # part of H.Merijn Brand's Text::CSV_XS module distro. # text file to Excel I recommend the more rigorous csv2xls program that is # For converting a CSV or Tab separated or any other type of delimited # NOTE: This is only a simple conversion utility for illustrative purposes. # The program uses Text::CSV_XS to parse the CSV. # This is more or less an non-op since Excel can read CSV files. # Simple program to convert a CSV comma-separated value file to an Excel file. # Example of how to use the WriteExcel module Please advice how to find this script? or other advice to convert CSV to XLS on Linux machine #!/usr/bin/perl -w So I want to find other alternative that convert CSV to XLS file So I need to find some other alternative for this Perl scriptįirst customer have Linux red-hat machine version 5.XĪnd I want to find some bash/ksh/sh/awk scripts that can do the job the same as the perl script do In order to run this Perl script, and actually I cant because the Linux machine is customer machine ( not allow to install modules ) The problem is that I need to install on customer Linux machine many Perl modules The following Perl script can convert CSV file to XLS file
0 kommentar(er)
