1

perl : date from excel(.xlsx) not printed properly(format is changed)

view story
linux-howto

http://www.unix.com – I am trying to convert xlsx sheet to a csv file. In .xlsx file there a cell with date Code: Mon 08/27/12 while reading this cell using Spreadsheet::XLSX, the output is display with numeric value i.e., 41148. from Spreadsheet::XLSX module : Code: use Text::Iconv;  my $converter = Text::Iconv -> new ("utf-8", "windows-1251");    # Text::Iconv is not really required.  # This can be any object with the convert method. Or nothing.  use Spreadsheet::XLSX;    my $excel = Spreadsheet::XLSX -> new ('bandwidth-wan.xlsx', $co (HowTos)