Wednesday, 15 May 2013

EPPlus: Importing data from excel file into PDF shows wrong date format -



EPPlus: Importing data from excel file into PDF shows wrong date format -

i reading info xlsx file using epplus , then, converting pdf using migradoc. date fields show double values.

for e.g. : 2014-06-17 19.25.14 becomes 41807.8091898148 in pdf.

_book = _package.workbook; _sheet = _book.worksheets[1]; table _table; (int row = 5; row <= end.row; row++) { row _row = _table.addrow(); ((int col = 1; col <= end.column; col++) _row.cells[col - 1].addparagraph(_sheet.cells[row, col].value.tostring()); } _pdfrenderer.renderdocument();

how right it?

excel pdf epplus migradoc

No comments:

Post a Comment