Category: Excel
-
Post Views: 44 1. The URL URL of a column of a CSV file is now escaped after a string. Example: 2. Because it is planned to import the CSV file into WooCommerce’s products, the URL is mapped as a picture. If it is escaped, the picture is empty after importing. After deciding to deliberate, import again. 3. Select the…
-
Post Views: 54 1. The URL URL of a column of a CSV file is now escaped after a string. Example: 2. Because it is planned to import the CSV file into WooCommerce’s products, the URL is mapped as a picture. If it is escaped, the picture is empty after importing. After deciding to deliberate, import again. 3. Select the…
-
Post Views: 17 1. When filtering in an Excel, filter: Jie Meina, only the line with the end of the date is 4.30, and the subsequent row cannot be filtered successfully. Figure 1, Figure 2 2. Discovery The date is 5.1, and each column has a filter button, which feels like a new table has been opened. as shown…
-
Post Views: 9 cdbcommand cannot execute sql statement: sqlstate[HY000]: General Error: 1366 Incorrect Integer Value:Classificationfor columnBUY_CAT_IDat row 1. The SQL statement execute was: insert into `ERP_customer` (`realname`, `tel`, `address`, `spec_con`, `join_time`, `buy_cat_id`) values (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5). When importing EXCEL, if it is a null value in EXCEL, I set it to “”, it will still be converted…