close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 14 years ago

Last modified 13 years ago

#1214 accepted enhancement

xls::ReadSeriesByCol fails when the date is with date format

Reported by: Jorge Owned by: Jorge
Priority: normal Milestone: Mantainance
Component: Excel API Version: 2.0.1
Severity: normal Keywords:
Cc:

Description

The ex1.xls attached could not be read using ReadSeriesByCol.
While the ex1.1.xls attached can be read.

The difference is that ex1.xls has the dates in text format while ex1.1.xls has the dates with date format.

#Require TolExcel;

TolExcel::@WorkBook xls = TolExcel::@WorkBook::Open("/tmp/ex1.xls");
Real xls::ActivateWS(1);
Set xls::ReadSeriesByCol( 1, 1, 12, 2, W, "%d-%m-%Y" );

Attachments (2)

ex1.xls​ (7.0 KB) - added by Jorge 14 years ago.
ex1.1.xls​ (7.0 KB) - added by Jorge 14 years ago.

Download all attachments as: .zip

Change History (5)

Changed 14 years ago by Jorge

Attachment: ex1.xls​ added

Changed 14 years ago by Jorge

Attachment: ex1.1.xls​ added

comment:1 Changed 14 years ago by Jorge

Status: new → accepted

We can guess the data type of the date column in order to provide the correct column's type when calling ReadRange which read the dates.

comment:2 Changed 13 years ago by Jorge

(In [4603]) refs #1297, remove worksheet

refs #1214, improved Date format detection when reading Serie

comment:3 Changed 13 years ago by Víctor de Buen Remiro

(In [4606]) refs #1297, refs #1214

Note: See TracTickets for help on using tickets.