Xls2csv: invalid date cell syntax

Question

I formats dates with the command line option -f% Y-% m-% d or even% d-% b-% y

but each date is issued four years and one day earlier than the input date

for example, the date 01.06.2012after parsing without the -f option appears as 2016-06-02 toying with -f gives the same result

What is the reason? Are there any workarounds besides hard code and subtraction back 4 years and 1 day?

I use xls2csv (according to VB Wagner, it comes with the debian catdoc package) and switching to another parser can be a very expensive option

+5

jonny Jun 20 '12 at 6:08

2 answers

Ωmega · Answer 1 · 2012-06-22T17:26:43+0000

The xls2csv service is a Perl application that uses a library Spreadsheet::ParseExcel.

, :

, , , Excel, - .

Christophe deleuze · Answer 2 · 2012-09-25T15:06:04+0000

It works. By the way, there are two programs called xls2csv, we are talking about one of the catdoc package, and not in the Perl program.