Deprecated: Creation of dynamic property WP_Block::$attributes is deprecated in /home/reshajt1/public_html/wp-includes/class-wp-block.php on line 179

Deprecated: Creation of dynamic property WP_Block::$attributes is deprecated in /home/reshajt1/public_html/wp-includes/class-wp-block.php on line 179

Deprecated: Implicit conversion from float 1793081225.442239 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Creation of dynamic property IRP_HTMLContext::$isParentTable is deprecated in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/html/HTMLContext.php on line 53

Deprecated: Implicit conversion from float 1793081225.442656 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.442726 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.442784 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.442846 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.442896 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443002 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443055 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443105 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443156 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443211 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443271 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443331 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443378 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443418 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443458 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443496 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443558 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443604 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443644 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443689 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443742 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443791 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443851 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.443901 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444142 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444211 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444272 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.44432 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444365 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444409 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444457 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444497 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444535 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.44457 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444611 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444665 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444713 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444758 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444802 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444888 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.444954 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445003 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445046 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445091 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445139 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445202 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.44526 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445304 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445348 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445397 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445462 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445524 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445571 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445615 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445652 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445699 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445758 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.44583 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.44589 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445939 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.445983 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.44603 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446095 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446152 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.4462 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446251 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446295 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446339 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446383 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446426 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446462 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446508 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446558 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.44661 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446653 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446707 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446754 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446798 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446856 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446901 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446948 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.446999 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447046 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447089 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447133 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.44718 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447223 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447275 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447319 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447364 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447415 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447468 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447512 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447561 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447608 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447665 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.447723 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.448654 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.449367 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Deprecated: Implicit conversion from float 1793081225.449851 to int loses precision in /home/reshajt1/public_html/wp-content/plugins/intelly-related-posts/includes/classes/utils/Logger.php on line 93

Selamat datang di blog saya. Kali ini saya akan membagikan tutorial bagaimana cara untuk import file xlsx untuk masuk ke query sql kita. kita membutuhkan 2 module yang di butuhkan untuk membuat script tersebut yaitu :

• xlrd
• mysqldb

Disini saya mempunyai sebuah file dengan format xls dengan nama “Test.xls”. Berikut isi file tersebut :

Jangan lupa membuat Database dengan Table yang sesuai dengan file nya. Seperti ini :

Nah sekarang kita buat script untuk bisa konek ke database kita. disini saya menggunakan mysql sebagai databasenya, jadi saya menggunakan module MySQLdb sebagai connector nya. jika anda menggunakan database lain, anda bisa mencari module database connector nya.

import MySQLdb as sql

db = sql.connect(host="localhost", user="root",passwd="123", db="excel")

curs = db.cursor()

query = """ INSERT INTO belajar(id,nama,kelas,alamat) VALUES (%s,%s,%s,%s)"""

Kemudian untuk mengimport file xls nya kalian harus menambahkan module xlrd. xlrd hanya bisa menggunakan file dengan exstensi ‘.xls’ saja. Anda tidak bisa import file seperti ‘.xlsx’,’.csv’ atau file excel lainnya.

import xlrd

book = xlrd.open_workbook("Test.xls") #nama file xls nya
sheet = open.sheet_by_name('Test') #nama sheet excel

Nah, tinggal kita gabungin terus pake looping buat masukin datanya. Untuk full script nya bisa di lihat disini atau mendownload nya via github :

import xlrd
import MySQLdb as sql

# SQL
db = sql.connect(host="localhost", user="root",passwd="toor", db="excel")

curs = db.cursor()

query = """ INSERT INTO belajar(id,nama,kelas,alamat) VALUES (%s,%s,%s,%s)"""

# XLS File
book = xlrd.open_workbook("Test.xls") #nama file xls nya
sheet = book.sheet_by_name('Test') #nama sheet excel

#Execute

for n in range(1,sheet.nrows):
		id		= sheet.cell(n,0).value
		nama		= sheet.cell(n,1).value
		kelas		= sheet.cell(n,2).value
		alamat		= sheet.cell(n,3).value

		values = (id,nama,kelas,alamat)

		curs.execute(query,values)

curs.close
db.commit()

print("Anda telah berhasil Import !!!")

Silahkan jika anda ingin mendownload source Code nya. Bisa di ambil di akun saya.

https://github.com/ReshaJTama/xlstosql

Anda dapat mengunjungi source tutorial ini di

https://mherman.org/blog/import-data-from-excel-into-mysql-using-python/

Tagged excel, mysql, python