Component:HSSF\XSSF import xls or xlsx i want "2022\02\02" import to db. normal:2022\02\02 insert sucessed. but insert "1111111111111111111111111111" sucessful too.that convert date sucessful. i want date as String,but i get datestyle is 'yyyy\M\d' use dataformatter to be 'M\d'. i want read data cell as String,as same as my written things . i want: '2022\01\01' i read is '2022\01\01'(String) now: '2022\01\01' read is 'xx\xx'(dataformater) now '1111111111111' read is 'xx\xx'(dataformater) now '2022\01\01' (getCellDate) successful but not '11111111111' getCellDate sucessful too...
Hi Puguoan, I'm afraid this is not a good way to get coding advice. There is possibly a language barrier but I don't really understand what you are looking for. By far the best way to get through language barriers is for you to provide a reproducible code example - so that other users can try to work with the issue you are seeing. This web site is really for reporting bugs. I really think that https://stackoverflow.com/ is a much better place to start. Be aware that Stackoverflow requires some effort on your part and users there are not happy to get vague questions. https://stackoverflow.com/help/how-to-ask - I think this article is a good read for anyone who is asking questions or raising issues.
getCellDate(): xls/xlsx file cell value = "1111111111111111" i read file,use getCellDate() get value.that is date type. --- DataFormatter: cell = "2022/02/02" or "11111111111" i try use DataFormatter.formatCellValue(cell),that print 'MM/yy'. i want only get yyyy/MM/dd date or String class value. thanks stackoverflow seach all no methed.