blockNumber view

Column Type Required

result

String

No

Examples

SELECT * FROM blobBaseFee
sql

Microsoft Excel

  1. In the Excel Data tab, choose Get Data > From Other Source > Blank Query (or New Query > From Other Source > Blank Query for older versions of Excel).

  2. In the Power Query Editor formula bar, enter:

    = Odbc.Query("dsn=Ethereum", "SELECT * FROM blockNumber")

    replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.

  3. Press the tick button.

  4. In the Query Settings > Properties > Name field, enter:

    blockNumber
  5. Choose Close and Load.

  6. Optionally, to convert the hexadecimal value to a decimal value, enter the following formula in another cell:

    = HEX2DEC(RIGHT(blockNumber,(LEN(blockNumber)-2)))