美文网首页
ripple(xrpl) transaction query w

ripple(xrpl) transaction query w

作者: 豪威Howie | 来源:发表于2021-05-20 23:37 被阅读0次
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')

相关文章

网友评论

      本文标题:ripple(xrpl) transaction query w

      本文链接:https://www.haomeiwen.com/subject/rwjijltx.html