ripple(xrpl) transaction query w
2021-05-20 本文已影响0人
豪威Howie
import xrpl
import openpyxl as xl
import time
wb=xl.Workbook()
sheet=wb.active
sheet.cell(1,1).value='TransactionType'
sheet.cell(1,2).value='date'
sheet.cell(1,3).value='Amount'
sheet.cell(1,4).value='Account'
sheet.cell(1,5).value='Destination'
sheet.cell(1,6).value='Paths'
sheet.cell(1,7).value='SendMax'
sheet.cell(1,8).value='Fee'
sheet.cell(1,9).value='Flags'
sheet.cell(1,10).value='Sequence'
sheet.cell(1,11).value='SigningPubKey'
sheet.cell(1,12).value='TxnSignature'
sheet.cell(1,13).value='hash'
sheet.cell(1,14).value='inLedger'
sheet.cell(1,15).value='ledger_index'
sheet.cell(1,16).value='Memos'
test_account='rh9ENUa7G2TwfoVyoj6T4TvmCaxMFCTjCT'
from xrpl.clients import JsonRpcClient
JSON_RPC_URL = "https://s2.ripple.com:51234/"
client = JsonRpcClient(JSON_RPC_URL)
#trxs=xrpl.account.get_account_transactions(test_account,client)
trxs=xrpl.account.get_account_payment_transactions(test_account, client)
for i in range(0,len(trxs)):
sheet.cell(i+2,1).value=trxs[i]['tx'].get('TransactionType')
sheet.cell(i+2,2).value=time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(trxs[i]['tx'].get('date')+946684800))
sheet.cell(i+2,3).value=str(trxs[i]['tx'].get('Amount'))
sheet.cell(i+2,4).value=trxs[i]['tx'].get('Account')
sheet.cell(i+2,5).value=trxs[i]['tx'].get('Destination')
sheet.cell(i+2,6).value=str(trxs[i]['tx'].get('Paths'))
sheet.cell(i+2,7).value=str(trxs[i]['tx'].get('SendMax'))
sheet.cell(i+2,8).value=trxs[i]['tx'].get('Fee')
sheet.cell(i+2,9).value=trxs[i]['tx'].get('Flags')
sheet.cell(i+2,10).value=trxs[i]['tx'].get('Sequence')
sheet.cell(i+2,11).value=trxs[i]['tx'].get('SigningPubKey')
sheet.cell(i+2,12).value=trxs[i]['tx'].get('TxnSignature')
sheet.cell(i+2,13).value=trxs[i]['tx'].get('hash')
sheet.cell(i+2,14).value=trxs[i]['tx'].get('inLedger')
sheet.cell(i+2,15).value=trxs[i]['tx'].get('ledger_index')
sheet.cell(i+2,16).value=str(trxs[i]['tx'].get('Memos'))
wb.save('yejiu.xlsx')