Untitled

 avatar
unknown
python
2 years ago
908 B
7
Indexable
import sqlite3
import csv

# Replace 'your_realm_file.realm' with the actual Realm file name
realm_file = 'your_realm_file.realm'

# Replace 'your_table_name' with the actual table name
table_name = 'your_table_name'

# Connect to SQLite (Realm files can be treated as SQLite databases)
connection = sqlite3.connect(realm_file)
cursor = connection.cursor()

# Fetch data from the SQLite table
cursor.execute('SELECT * FROM {}'.format(table_name))
data = cursor.fetchall()

# Replace 'output.csv' with the desired CSV file name
csv_file = 'output.csv'

# Write data to a CSV file
with open(csv_file, 'w', newline='') as csvfile:
    csv_writer = csv.writer(csvfile)
    # Write header
    csv_writer.writerow([description[0] for description in cursor.description])
    # Write data
    csv_writer.writerows(data)

print('Data exported to {}'.format(csv_file))

# Close the SQLite connection
connection.close()
Editor is loading...
Leave a Comment