Export data to Excel - follow formatting of Date fields?

ideas
1

Idea

What I wanted to achieve?

  1. I created screen in Origam application to display reporting data
  2. I want to allow users simply Export to Excel to create the report what they need
  3. I would like the excel data would like as it is designed on the screen

What difficulties I see?

  1. Date fields are formatted on the screen in dd.MM.yyyy format, but in Excel there they are displayed as dd.MM.yyyy HH:mm
  2. The width of columns is not set to align with data

Questions

  1. Is it possible to adjust code that dates in Excel would follow the formatting defined in screen section model (custom Date format)? At this moment, I use “workaround” that I format the data into Text fields with expected formatting and it works fine. So no big deal at this moment.
  2. Is it possible to force Excel to adjust column width? Or to somehow follow columns’ width set on the screen? It is not big deal to adjust columns width as user but if it is possible to tell excel how to width data, it would be nice for end users.
2

I think NPOI supports all of this. So it is technically possible.