bigfunctions > json2excel

json2excel

Signature

json2excel(data)

Description

Dump data to excel file encoded as a base64 string.

This function is useful to combine with send_mail if you want to send an excel file to some people.

Examples

EUUSeurope-west1

select bigfunctions.eu.json2excel(json '[{"col1": "row1", "col2": 1}, {"col1": "row2", "col2": 2}]')

select bigfunctions.us.json2excel(json '[{"col1": "row1", "col2": 1}, {"col1": "row2", "col2": 2}]')

select bigfunctions.europe_west1.json2excel(json '[{"col1": "row1", "col2": 1}, {"col1": "row2", "col2": 2}]')

+------------------+
| excel_base64     |
+------------------+
| UEsDBBQAAAAAA... |
+------------------+