xlconnect icon indicating copy to clipboard operation
xlconnect copied to clipboard

Allow specifying time zone for dates when importing

Open martinstuder opened this issue 10 years ago • 0 comments

"I just discovered your package XLConnect and find it very useful. Before, I used read.xls() from package gdata, but the columns containing dates were imported in unpredictable manner and I had to do some work to convert to valid dates.

Your package does this automatically, which is wonderful. I just wish we could tive a time zone when calling your functions to import Excel sheets. I keep my computers doing data acquisition to standard time in summer (i.e. I do not switch to advanced summer time) for various reasons, and they import in advanced time with readWorksheetFromFile(). I sometimes receive data from colleagues in diverse locations and I cannot specify the appropriate time zone for those occasions either.

I manage after importing, but then it is hardly more straightforward than using gdata."

martinstuder avatar Oct 04 '14 11:10 martinstuder