Excel date format converted to text format

There are a few minor problems when you test reading Excel and modifying database data today.

1. Null pointer, read and write IO exception is very much, the data obtained is NULL

2. Read the file location and start not finding the file

3. The Read date format result is a numeric value and therefore needs to be converted to text as follows:

First, the function TEXT (cell, ' format '), such as =text (A2, ' yyy-mm-dd '), then enter, and then pull to the whole column.

Then, select Copy, Paste selectively, and select a value.

Just finished reading, null pointer, so processing the content of the empty data.

Excel date format converted to text format