Articles in this section

Test import data as table from Excel and Sheet

ZD1

 

 

From Excel

Order ID Product Category Amount Date Country
1 Carrots Vegetables $4,270 01-06-12 United States
2 Broccoli Vegetables $8,239 01-07-12 United Kingdom
3 Banana Fruit $617 01-08-12 United States
4 Banana Fruit $8,384 01-10-12 Canada
5 Beans Vegetables $2,626 01-10-12 Germany
6 Orange Fruit $3,610 01-11-12 United States
7 Broccoli Vegetables $9,062 01-11-12 Australia
8 Banana Fruit $6,906 16/1/2012 New Zealand
9 Apple Fruit $2,417 16/1/2012 France
10 Apple Fruit $7,431 16/1/2012 Canada
11 Banana Fruit $8,250 16/1/2012 Germany
12 Broccoli Vegetables $7,012 18/1/2012 United States
13 Carrots Vegetables $1,903 20/1/2012 Germany
14 Broccoli Vegetables $2,824 22/1/2012 Canada
15 Apple Fruit $6,946 24/1/2012 France
16 Banana Fruit $2,320 27/1/2012 United Kingdom

From Sheet

Order ID Product Category Amount Date Country
1 Carrots Vegetables $4,270 01-06-12 United States
2 Broccoli Vegetables $8,239 01-07-12 United Kingdom
3 Banana Fruit $617 01-08-12 United States
4 Banana Fruit $8,384 01-10-12 Canada
5 Beans Vegetables $2,626 01-10-12 Germany
6 Orange Fruit $3,610 01-11-12 United States
7 Broccoli Vegetables $9,062 01-11-12 Australia
8 Banana Fruit $6,906 16/1/2012 New Zealand
9 Apple Fruit $2,417 16/1/2012 France
10 Apple Fruit $7,431 16/1/2012 Canada
11 Banana Fruit $8,250 16/1/2012 Germany
12 Broccoli Vegetables $7,012 18/1/2012 United States
13 Carrots Vegetables $1,903 20/1/2012 Germany
14 Broccoli Vegetables $2,824 22/1/2012 Canada
15 Apple Fruit $6,946 24/1/2012 France
16 Banana Fruit $2,320 27/1/2012 United Kingdom

 

After edit

Order ID Product Category Amount Date Country
1 Carrots Vegetables $4,270 01-06-12 United States
2 Broccoli Vegetables $8,239 01-07-12 United Kingdom
3 Banana Fruit $617 01-08-12 United States
4 Banana Fruit $8,384 01-10-12 Canada
5 Beans Vegetables $2,626 01-10-12 Germany
6 Orange Fruit $3,610 01-11-12 United States
7 Broccoli Vegetables $9,062 01-11-12 Australia
8 Banana Fruit $6,906 16/1/2012 New Zealand
9 Apple Fruit $2,417 16/1/2012 France
10 Apple Fruit $7,431 16/1/2012 Canada
11 Banana Fruit $8,250 16/1/2012 Germany
12 Broccoli Vegetables $7,012 18/1/2012 United States
13 Carrots Vegetables $1,903 20/1/2012 Germany
14 Broccoli Vegetables $2,824 22/1/2012 Canada
15 Apple Fruit $6,946 24/1/2012 France
16 Banana Fruit $2,320 27/1/2012 United Kingdom

 

 Save As จาก Excel เป็น HTML ก่อน

Order ID Product Category Amount Date Country
1 Carrots Vegetables $4,270 01-06-12 United States
2 Broccoli Vegetables $8,239 01-07-12 United Kingdom
3 Banana Fruit $617 01-08-12 United States
4 Banana Fruit $8,384 01-10-12 Canada
5 Beans Vegetables $2,626 01-10-12 Germany
6 Orange Fruit $3,610 01-11-12 United States
7 Broccoli Vegetables $9,062 01-11-12 Australia
8 Banana Fruit $6,906 16/1/2012 New Zealand
9 Apple Fruit $2,417 16/1/2012 France
10 Apple Fruit $7,431 16/1/2012 Canada
11 Banana Fruit $8,250 16/1/2012 Germany
12 Broccoli Vegetables $7,012 18/1/2012 United States
13 Carrots Vegetables $1,903 20/1/2012 Germany
14 Broccoli Vegetables $2,824 22/1/2012 Canada
15 Apple Fruit $6,946 24/1/2012 France
16 Banana Fruit $2,320 27/1/2012 United Kingdom

 

สร้างตารางใหม่เอง

           
           
           
           
           
           
           
           
           

 

 

Comments

3 comments

Date Votes

Please sign in to leave a comment.

Powered by Zendesk