excelJSTest01.mjs

import ExcelJS from 'exceljs';
import fetch from 'node-fetch'

// function getData() {
//   const response = await fetch('https://ghibliapi.herokuapp.com/films')
//   const data = await response.json()
// }


const rowValues = [];
// rowValues[9] = new Date();

const response = await fetch('https://openapi.debank.com/v1/user/total_balance?id=0x3a0a36c16136d0eef403b049917b98dbac3f4463')
const data = await response.json()
var networth = data.total_usd_value
console.log('TOT :' + networth)
var networthBsc = data.chain_list[1].usd_value
var networthFantom = data.chain_list[4].usd_value
var networthAvax = data.chain_list[7].usd_value
console.log('BSC :' + networthBsc)
console.log('AVAX :' + networthAvax)
console.log('FTM :' + networthFantom)


rowValues[1] = new Date();
rowValues[2] = networth;
rowValues[3] = networthBsc;
rowValues[7] = networthFantom;
rowValues[10] = networthAvax;



const response2 = await fetch('https://openapi.debank.com/v1/user/complex_protocol_list?id=0x3a0a36c16136d0eef403b049917b98dbac3f4463&chain_id=bsc')
const data2 = await response2.json()
//var networthBscBeefyStatik = data2[0].portfolio_item_list[0].stats.net_usd_value
var networthBscBeefyOasis = data2[0].portfolio_item_list[0].stats.net_usd_value
// var networthBscKalmar = data2[1].portfolio_item_list[0].stats.net_usd_value
//console.log('BeefyStatic :' + networthBscBeefyStatik)
console.log('BeefyOasis :' + networthBscBeefyOasis)
// console.log('Kalmar :' + networthBscKalmar)

//rowValues[4] = networthBscBeefyStatik;
rowValues[5] = networthBscBeefyOasis;

const response5 = await fetch('https://openapi.debank.com/v1/user/token?id=0x3a0a36c16136d0eef403b049917b98dbac3f4463&chain_id=bsc&token_id=0xc146b7cdbaff065090077151d391f4c96aa09e0c')
const data5 = await response5.json()
var networthBscMCC = data5.price * data5.amount;
console.log('BscMCC : '+ networthBscMCC)

rowValues[6] = networthBscMCC;

const response3 = await fetch('https://openapi.debank.com/v1/user/complex_protocol_list?id=0x3a0a36c16136d0eef403b049917b98dbac3f4463&chain_id=ftm')
const data3 = await response3.json()
var networthFTMBeefyTomb = data3[0].portfolio_item_list[0].stats.net_usd_value
console.log('BeefyTomb :' + networthFTMBeefyTomb)

rowValues[8] = networthFTMBeefyTomb;

const response6 = await fetch('https://openapi.debank.com/v1/user/token?id=0x3a0a36c16136d0eef403b049917b98dbac3f4463&chain_id=ftm&token_id=0xa231d452e4bca86672fd6109de94688d1e17aae5')
const data6 = await response6.json()
var networthFtmSCC = data6.price * data6.amount;
console.log('FtmSCC : '+ networthFtmSCC)

rowValues[9] = networthFtmSCC;

const response4 = await fetch('https://openapi.debank.com/v1/user/complex_protocol_list?id=0x3a0a36c16136d0eef403b049917b98dbac3f4463&chain_id=avax')
const data4 = await response4.json()
//var networthAvaxImpermaxUstUsdc = data4[1].portfolio_item_list[0].stats.net_usd_value
var networthAvaxBooFinanceLP = data4[0].portfolio_item_list[0].stats.net_usd_value
var networthAvaxBooFinanceStaked = data4[0].portfolio_item_list[1].stats.net_usd_value
//console.log('ImpermaxUSTUSDC :' + networthAvaxImpermaxUstUsdc)
console.log('BooFinanceAvax :' + networthAvaxBooFinanceLP)
console.log('BooFinanceStaked :' + networthAvaxBooFinanceStaked)


//rowValues[14] = networthAvaxBeefyUstUsdc;
rowValues[13] = networthAvaxBooFinanceLP;
rowValues[14] = networthAvaxBooFinanceStaked;


const workbook = new ExcelJS.Workbook();
await workbook.xlsx.readFile('./PortCrypto02.xlsx')
var worksheet = workbook.getWorksheet('Foglio1');

var lastRow = worksheet.lastRow;
// console.log(lastRow.number)
// var getRowInsert = worksheet.getRow(++(lastRow.number));
// var date = Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy")
var today = new Date();
var date = today.getDate() + '/' + (today.getMonth() + 1) + '/' + today.getFullYear();
worksheet.addRow(rowValues).commit();
workbook.xlsx.writeFile('./PortCrypto02.xlsx');