How to set Locale for POI Event API
I am using Apache POI Event API to process large volume of records in XLSX sheet. Here is the reference to do so. However i am facing difficulty with date columns. My date column in XLSX sheet is formatted as 'dd-mm-yyyy' with Locale as US and getting the value with the format as 'mm-dd-yy'. If i change the Locale to UK, then i am getting the value as in expected format.
So, is there any way to change the Locale of XLSX while processing it? Or is there any alternative to get rid of it?