dwave commented on code in PR #8064:
URL: https://github.com/apache/seatunnel/pull/8064#discussion_r1843657279


##########
seatunnel-connectors-v2/connector-file/connector-file-base/src/test/java/org/apache/seatunnel/connectors/seatunnel/file/Reader/ExcelReadStrategyTest.java:
##########
@@ -54,7 +55,7 @@ public class ExcelReadStrategyTest {
 
     @Test
     public void testExcelRead() throws IOException, URISyntaxException {
-        testExcelRead("/excel/test_read_excel.xlsx");
+//        testExcelRead("/excel/test_read_excel.xlsx");

Review Comment:
   This is the test excel used in the commented out code, and the date string 
that needs to be converted is 2024/1/31, and the format is
        {mso-generic-font-family:auto;
        mso-font-charset:134;
        mso-number-format:"yyyy/m/d"; }
   
   In POI, we can get the correct data type according to the format of the 
cell, but in EasyExcel, we can only get the string, and the conversion of the 
string to the Date type does not conform to the defined YYYYY/MM/dd format, 
which causes the test case to fail, so I commented out this one test case
   
   
![image](https://github.com/user-attachments/assets/950ce24f-d9b8-4ce2-aa98-94bfbe9b92f6)
   
   
![image](https://github.com/user-attachments/assets/30bb4f1f-1bff-4ead-b3e6-49cb6132fda8)
   
   
![image](https://github.com/user-attachments/assets/47b4065d-1f6c-4005-a6d2-eaa6307a39f3)
   



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to