🤌 Excel / XLSX Creator

[rico.trevisan]

Create a XLSX file from a JSON.

Plugin page: 🤌 Excel / XLSX Creator Plugin | Bubble
Demo: Bubble | No-code apps
Editor: excel-creator | Bubble Editor

Built on top of the shoulders of giants

• @eli’s 1T CSV Creator: 1T - CSV Creator Plugin | Bubble
• SheetJS: sheetjs/sheetjs: 📗 SheetJS Community Edition -- Spreadsheet Data Toolkit - sheetjs - SheetJS
• AirDev’s File Downloader: File Downloader Plugin | Bubble
• YouTube tutorial: Convert JSON into Excel sheet in Node.js || Project - YouTube

If you know how to use the 1T CSV Creator, you know how to use this.

---

Instructions

1. Setup the action

This uses the operator :formatted as text on a list in Bubble. Get started by adding the JSON to XLSX (SSA) action to your workflow.

The JSON content field simply needs valid JSON and you are good to go. However, the idea is to do a search for the data you want to export and then use the :format as text operator and create your JSON in that field as shown below.

Add a comma to the Delimiter field.

When you have a field that can contain newlines, quotes, and other special characters, It’s a good idea to use the :formatted as JSON-safe operator. When using that operator, you don’t need to wrap it with double-quotes " – the operator does that already.

Sample JSON

{
"Sale Date": "This Sales's Order Date",
"Sale ID":"This Sales's Order ID",
"Items":[This Sales's Items: formatted as JSON-safe],
"Region":This Sales's Region's Name: formatted as JSON-safe
}

If you want to export a nested list, simply add square brackets around the value as shown in the Items value in the JSON sample.

2. Saving the file

To save the file use 1T - CSV Creator’s (1T - CSV Creator Plugin | Bubble) save file.

See the demo page for more info

3. Downloading the file

Use the Download file action from AirDev’s File Downloader (File Downloader Plugin | Bubble)

[kazimdgoni]

This is going to be very helpful for everyone. Thank you for the plugin.

[michaelriedler]

Incredible work! I wonder if I could save step one as an Excel file to bubble’s database? Looking to turn a JSON into an Excel sheet I can display to the user using Air Document Viewer Plugin | Bubble

Edit: I already made it work, sorry for the bother. Just opened your page excel-creator | Bubble Editor and copied the steps so good

[michaelriedler]

Two more questions - no rush at all - got it working

1. It seems to create the file in view-only mode, is there a way to change that?

2. Thought of doing the same for google sheets?

Thank either way, great plugin!

[tylerboodman]

Hey @rico.trevisan , is there a way we could define the width of the columns on the exported sheet? Maybe we provide a list of numbers like 200,300,100 (so column 1 is 200px, column 2 is 300px, etc)

Very useful and simple plugin either way

[dev113]

Is it possible to create multiple tabs in the XLSX file with this plugin?

[rico.trevisan]

Not yet. You’re not the first one to request this and I need to do that for an app so I’ll do this soon. I’m on a bit of a pre-holidays rush and then I’ll get on it in September.

[dev113]

Great, looking forward to it! And enjoy your vacation

[benjamin7]

Hi @rico.trevisan
Thanks for the plugin - does it support multiple sheets on the same Excel file now?

[rico.trevisan]

Finally got around to working on the multisheet export. I’m looking for a couple of beta testers. Drop me a DM with your app’s name and I’ll slip you a copy.

[sxtn.digital]

Hi @rico.trevisan,

First of all, thanks for creating an excellent plugin!

Initially, I was a bit intimidated by all the Node.js tutorials. However, after watching the YouTube link and installing the xlsx package in Visual Studio, I realized it was a plug-and-play solution. Haha!

Now, to my issue…

I have successfully installed the plugin and can generate .xlsx files. It works perfectly. However, when using the @AirDev downloader to open the file, I get the following error:

“Cannot open the file because the file format or file extension is not valid.”

The strange thing is, if I download it from the backend using “bubble.fileManager,” it works fine. Also, if I open the corrupted file in Google Sheets, it works without any issues.

I’ve been working on this for over 18 hours straight and can’t figure it out. I’m running out of time to publish my new update, and I rely on this function to generate payroll data that my users send to the accounting office.

I would greatly appreciate any pointers on how to solve this.

Thank you!

How i have setted it up:

API_xlsx_creator

Workflow: run_xlsx_creator

1. Serche for things
2. Generate a JSON array with the :format as text
   
   
3. Run API workflow
   
   

**INPUT JSON & RESULT base64**

{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “1”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “105”,
“Sats”: “220”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “16”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “4.75”,
“Sats”: “115”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “7”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “87.25”,
“Sats”: “191”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “20”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “47.75”,
“Sats”: “191”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “21”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “14.75”,
“Sats”: “110”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “2”,
“Art”: “1”,
“Kommentar”: “”,
“Antall”: “1”,
“Sats”: “50000”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “2”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “115.75”,
“Sats”: “215”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “3”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “151”,
“Sats”: “215”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “6”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “90.25”,
“Sats”: “191”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “8”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “47.5”,
“Sats”: “191”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “22”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “13”,
“Sats”: “150”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “12”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “17.25”,
“Sats”: “155”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “14”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “10”,
“Sats”: “115”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “10”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “7.25”,
“Sats”: “191”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “24”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “24.75”,
“Sats”: “191”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “19”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “9”,
“Sats”: “115”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “13”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “9”,
“Sats”: “208”,
“Projekt”: “”
},{
“År”: “2024”,
“Måned”: “06”,
“Ansattnummer”: “4”,
“Art”: “2”,
“Kommentar”: “”,
“Antall”: “2”,
“Sats”: “208”,
“Projekt”: “”

BASE64

UEsDBBQAAAAAAAAAAACkAYS4tQIAALUCAAAaAAAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHM8P3htbCB2ZXJzaW9uPSIxLjAiIGVuY29kaW5nPSJVVEYtOCIgc3RhbmRhbG9uZT0ieWVzIj8+DQo8UmVsYXRpb25zaGlwcyB4bWxucz0iaHR0cDovL3NjaGVtYXMub3BlbnhtbGZvcm1hdHMub3JnL3BhY2thZ2UvMjAwNi9yZWxhdGlvbnNoaXBzIj48UmVsYXRpb25zaGlwIElkPSJySWQxIiBUeXBlPSJodHRwOi8vc2NoZW1hcy5vcGVueG1sZm9ybWF0cy5vcmcvb2ZmaWNlRG9jdW1lbnQvMjAwNi9yZWxhdGlvbnNoaXBzL3dvcmtzaGVldCIgVGFyZ2V0PSJ3b3Jrc2hlZXRzL3NoZWV0MS54bWwiLz48UmVsYXRpb25zaGlwIElkPSJySWQyIiBUeXBlPSJodHRwOi8vc2NoZW1hcy5vcGVueG1sZm9ybWF0cy5vcmcvb2ZmaWNlRG9jdW1lbnQvMjAwNi9yZWxhdGlvbnNoaXBzL3RoZW1lIiBUYXJnZXQ9InRoZW1lL3RoZW1lMS54bWwiLz48UmVsYXRpb25zaGlwIElkPSJySWQzIiBUeXBlPSJodHRwOi8vc2NoZW1hcy5vcGVueG1sZm9ybWF0cy5vcmcvb2ZmaWNlRG9jdW1lbnQvMjAwNi9yZWxhdGlvbnNoaXBzL3N0eWxlcyIgVGFyZ2V0PSJzdHlsZXMueG1sIi8+PFJlbGF0aW9uc2hpcCBJZD0icklkNCIgVHlwZT0iaHR0cDovL3NjaGVtYXMub3BlbnhtbGZvcm1hdHMub3JnL29mZmljZURvY3VtZW50LzIwMDYvcmVsYXRpb25zaGlwcy9zaGVldE1ldGFkYXRhIiBUYXJnZXQ9Im1ldGFkYXRhLnhtbCIvPjwvUmVsYXRpb25zaGlwcz5QSwMEFAAAAAAAAAAAADAPiGveHQAA3h0AABMAAAB4bC90aGVtZS90aGVtZTEueG1sPD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/Pg0KPGE6dGhlbWUgeG1sbnM6YT0iaHR0cDovL3NjaGVtYXMub3BlbnhtbGZvcm1hdHMub3JnL2RyYXdpbmdtbC8yMDA2L21haW4iIG5hbWU9Ik9mZmljZSBUaGVtZSI+PGE6dGhlbWVFbGVtZW50cz48YTpjbHJTY2hlbWUgbmFtZT0iT2ZmaWNlIj48YTpkazE+PGE6c3lzQ2xyIHZhbD0id2luZG93VGV4dCIgbGFzdENscj0iMDAwMDAwIi8+PC9hOmRrMT48YTpsdDE+PGE6c3lzQ2xyIHZhbD0id2luZG93IiBsYXN0Q2xyPSJGRkZGRkYiLz48L2E6bHQxPjxhOmRrMj48YTpzcmdiQ2xyIHZhbD0iMUY0OTdEIi8+PC9hOmRrMj48YTpsdDI+PGE6c3JnYkNsciB2YWw9IkVFRUNFMSIvPjwvYTpsdDI+PGE6YWNjZW50MT48YTpzcmdiQ2xyIHZhbD0iNEY4MUJEIi8+PC9hOmFjY2VudDE+PGE6YWNjZW50Mj48YTpzcmdiQ2xyIHZhbD0iQzA1MDREIi8+PC9hOmFjY2VudDI+PGE6YWNjZW50Mz48YTpzcmdiQ2xyIHZhbD0iOUJCQjU5Ii8+PC9hOmFjY2VudDM+PGE6YWNjZW50ND48YTpzcmdiQ2xyIHZhbD0iODA2NEEyIi8+PC9hOmFjY2VudDQ+PGE6YWNjZW50NT48YTpzcmdiQ2xyIHZhbD0iNEJBQ0M2Ii8+PC9hOmFjY2VudDU+PGE6YWNjZW50Nj48YTpzcmdiQ2xyIHZhbD0iRjc5NjQ2Ii8+PC9hOmFjY2VudDY+PGE6aGxpbms+PGE6c3JnYkNsciB2YWw9IjAwMDBGRiIvPjwvYTpobGluaz48YTpmb2xIbGluaz48YTpzcmdiQ2xyIHZhbD0iODAwMDgwIi8+PC9hOmZvbEhsaW5rPjwvYTpjbHJTY2hlbWU+PGE6Zm9udFNjaGVtZSBuYW1lPSJPZmZpY2UiPjxhOm1ham9yRm9udD48YTpsYXRpbiB0eXBlZmFjZT0iQ2FtYnJpYSIvPjxhOmVhIHR5cGVmYWNlPSIiLz48YTpjcyB0eXBlZmFjZT0iIi8+PGE6Zm9udCBzY3JpcHQ9IkpwYW4iIHR5cGVmYWNlPSLvvK3vvLMg77yw44K044K344OD44KvIi8+PGE6Zm9udCBzY3JpcHQ9IkhhbmciIHR5cGVmYWNlPSLrp5HsnYAg6rOg65SVIi8+PGE6Zm9udCBzY3JpcHQ9IkhhbnMiIHR5cGVmYWNlPSLlrovkvZMiLz48YTpmb250IHNjcmlwdD0iSGFudCIgdHlwZWZhY2U9IuaWsOe0sOaYjumrlCIvPjxhOmZvbnQgc2NyaXB0PSJBcmFiIiB0eXBlZmFjZT0iVGltZXMgTmV3IFJvbWFuIi8+PGE6Zm9udCBzY3JpcHQ9IkhlYnIiIHR5cGVmYWNlPSJUaW1lcyBOZXcgUm9tYW4iLz48YTpmb250IHNjcmlwdD0iVGhhaSIgdHlwZWZhY2U9IlRhaG9tYSIvPjxhOmZvbnQgc2NyaXB0PSJFdGhpIiB0eXBlZmFjZT0iTnlhbGEiLz48YTpmb250IHNjcmlwdD0iQmVuZyIgdHlwZWZhY2U9IlZyaW5kYSIvPjxhOmZvbnQgc2NyaXB0PSJHdWpyIiB0eXBlZmFjZT0iU2hydXRpIi8+PGE6Zm9udCBzY3JpcHQ9IktobXIiIHR5cGVmYWNlPSJNb29sQm9yYW4iLz48YTpmb250IHNjcmlwdD0iS25kYSIgdHlwZWZhY2U9IlR1bmdhIi8+PGE6Zm9udCBzY3JpcHQ9Ikd1cnUiIHR5cGVmYWNlPSJSYWF2aSIvPjxhOmZvbnQgc2NyaXB0PSJDYW5zIiB0eXBlZmFjZT0iRXVwaGVtaWEiLz48YTpmb250IHNjcmlwdD0iQ2hlciIgdHlwZWZhY2U9IlBsYW50YWdlbmV0IENoZXJva2VlIi8+PGE6Zm9udCBzY3JpcHQ9IllpaWkiIHR5cGVmYWNlPSJNaWNyb3NvZnQgWWkgQmFpdGkiLz48YTpmb250IHNjcmlwdD0iVGlidCIgdHlwZWZhY2U9Ik1pY3Jvc29mdCBIaW1hbGF5YSIvPjxhOmZvbnQgc2NyaXB0PSJUaGFhIiB0eXBlZmFjZT0iTVYgQm9saSIvPjxhOmZvbnQgc2NyaXB0PSJEZXZhIiB0eXBlZmFjZT0iTWFuZ2FsIi8+PGE6Zm9udCBzY3JpcHQ9IlRlbHUiIHR5cGVmYWNlPSJHYXV0YW1pIi8+PGE6Zm9udCBzY3JpcHQ9IlRhbWwiIHR5cGVmYWNlPSJMYXRoYSIvPjxhOmZvbnQgc2NyaXB0PSJTeXJjIiB0eXBlZmFjZT0iRXN0cmFuZ2VsbyBFZGVzc2EiLz48YTpmb250IHNjcmlwdD0iT3J5YSIgdHlwZWZhY2U9IkthbGluZ2EiLz48YTpmb250IHNjcmlwdD0iTWx5bSIgdHlwZWZhY2U9IkthcnRpa2EiLz48YTpmb250IHNjcmlwdD0iTGFvbyIgdHlwZWZhY2U9IkRva0NoYW1wYSIvPjxhOmZvbnQgc2NyaXB0PSJTaW5oIiB0eXBlZmFjZT0iSXNrb29sYSBQb3RhIi8+PGE6Zm9udCBzY3JpcHQ9Ik1vbmciIHR5cGVmYWNlPSJNb25nb2xpYW4gQmFpdGkiLz48YTpmb250IHNjcmlwdD0iVmlldCIgdHlwZWZhY2U9IlRpbWVzIE5ldyBSb21hbiIvPjxhOmZvbnQgc2NyaXB0PSJVaWdoIiB0eXBlZmFjZT0iTWljcm9zb2Z0IFVpZ2h1ciIvPjxhOmZvbnQgc2NyaXB0PSJHZW9yIiB0eXBlZmFjZT0iU3lsZmFlbiIvPjwvYTptYWpvckZvbnQ+PGE6bWlub3JGb250PjxhOmxhdGluIHR5cGVmYWNlPSJDYWxpYnJpIi8+PGE6ZWEgdHlwZWZhY2U9IiIvPjxhOmNzIHR5cGVmYWNlPSIiLz48YTpmb250IHNjcmlwdD0iSnBhbiIgdHlwZWZhY2U9Iu+8re+8syDvvLDjgrTjgrfjg4Pjgq8iLz48YTpmb250IHNjcmlwdD0iSGFuZyIgdHlwZWZhY2U9IuunkeydgCDqs6DrlJUiLz48YTpmb250IHNjcmlwdD0iSGFucyIgdHlwZWZhY2U9IuWui+S9kyIvPjxhOmZvbnQgc2NyaXB0PSJIYW50IiB0eXBlZmFjZT0i5paw57Sw5piO6auUIi8+PGE6Zm9udCBzY3JpcHQ9IkFyYWIiIHR5cGVmYWNlPSJBcmlhbCIvPjxhOmZvbnQgc2NyaXB0PSJIZWJyIiB0eXBlZmFjZT0iQXJpYWwiLz48YTpmb250IHNjcmlwdD0iVGhhaSIgdHlwZWZhY2U9IlRhaG9tYSIvPjxhOmZvbnQgc2NyaXB0PSJFdGhpIiB0eXBlZmFjZT0iTnlhbGEiLz48YTpmb250IHNjcmlwdD0iQmVuZyIgdHlwZWZhY2U9IlZyaW5kYSIvPjxhOmZvbnQgc2NyaXB0PSJHdWpyIiB0eXBlZmFjZT0iU2hydXRpIi8+PGE6Zm9udCBzY3JpcHQ9IktobXIiIHR5cGVmYWNlPSJEYXVuUGVuaCIvPjxhOmZvbnQgc2NyaXB0PSJLbmRhIiB0eXBlZmFjZT0iVHVuZ2EiLz48YTpmb250IHNjcmlwdD0iR3VydSIgdHlwZWZhY2U9IlJhYXZpIi8+PGE6Zm9udCBzY3JpcHQ9IkNhbnMiIHR5cGVmYWNlPSJFdXBoZW1pYSIvPjxhOmZvbnQgc2NyaXB0PSJDaGVyIiB0eXBlZmFjZT0iUGxhbnRhZ2VuZXQgQ2hlcm9rZWUiLz48YTpmb250IHNjcmlwdD0iWWlpaSIgdHlwZWZhY2U9Ik1pY3Jvc29mdCBZaSBCYWl0aSIvPjxhOmZvbnQgc2NyaXB0PSJUaWJ0IiB0eXBlZmFjZT0iTWljcm9zb2Z0IEhpbWFsYXlhIi8+PGE6Zm9udCBzY3JpcHQ9IlRoYWEiIHR5cGVmYWNlPSJNViBCb2xpIi8+PGE6Zm9udCBzY3JpcHQ9IkRldmEiIHR5cGVmYWNlPSJNYW5nYWwiLz48YTpmb250IHNjcmlwdD0iVGVsdSIgdHlwZWZhY2U9IkdhdXRhbWkiLz48YTpmb250IHNjcmlwdD0iVGFtbCIgdHlwZWZhY2U9IkxhdGhhIi8+PGE6Zm9udCBzY3JpcHQ9IlN5cmMiIHR5cGVmYWNlPSJFc3RyYW5nZWxvIEVkZXNzYSIvPjxhOmZvbnQgc2NyaXB0PSJPcnlhIiB0eXBlZmFjZT0iS2FsaW5nYSIvPjxhOmZvbnQgc2NyaXB0PSJNbHltIiB0eXBlZmFjZT0iS2FydGlrYSIvPjxhOmZvbnQgc2NyaXB0PSJMYW9vIiB0eXBlZmFjZT0iRG9rQ2hhbXBhIi8+PGE6Zm9udCBzY3JpcHQ9IlNpbmgiIHR5cGVmYWNlPSJJc2tvb2xhIFBvdGEiLz48YTpmb250IHNjcmlwdD0iTW9uZyIgdHlwZWZhY2U9Ik1vbmdvbGlhbiBCYWl0aSIvPjxhOmZvbnQgc2NyaXB0PSJWaWV0IiB0eXBlZmFjZT0iQXJpYWwiLz48YTpmb250IHNjcmlwdD0iVWlnaCIgdHlwZWZhY2U9Ik1pY3Jvc29mdCBVaWdodXIiLz48YTpmb250IHNjcmlwdD0iR2VvciIgdHlwZWZhY2U9IlN5bGZhZW4iLz48L2E6bWlub3JGb250PjwvYTpmb250U2NoZW1lPjxhOmZtdFNjaGVtZSBuYW1lPSJPZmZpY2UiPjxhOmZpbGxTdHlsZUxzdD48YTpzb2xpZEZpbGw+PGE6c2NoZW1lQ2xyIHZhbD0icGhDbHIiLz48L2E6c29saWRGaWxsPjxhOmdyYWRGaWxsIHJvdFdpdGhTaGFwZT0iMSI+PGE6Z3NMc3Q+PGE6Z3MgcG9zPSIwIj48YTpzY2hlbWVDbHIgdmFsPSJwaENsciI+PGE6dGludCB2YWw9IjUwMDAwIi8+PGE6c2F0TW9kIHZhbD0iMzAwMDAwIi8+PC9hOnNjaGVtZUNscj48L2E6Z3M+PGE6Z3MgcG9zPSIzNTAwMCI+PGE6c2NoZW1lQ2xyIHZhbD0icGhDbHIiPjxhOnRpbnQgdmFsPSIzNzAwMCIvPjxhOnNhdE1vZCB2YWw9IjMwMDAwMCIvPjwvYTpzY2hlbWVDbHI+PC9hOmdzPjxhOmdzIHBvcz0iMTAwMDAwIj48YTpzY2hlbWVDbHIgdmFsPSJwaENsciI+PGE6dGludCB2YWw9IjE1MDAwIi8+PGE6c2F0TW9kIHZhbD0iMzUwMDAwIi8+PC9hOnNjaGVtZUNscj48L2E6Z3M+PC9hOmdzTHN0PjxhOmxpbiBhbmc9IjE2MjAwMDAwIiBzY2FsZWQ9IjEiLz48L2E6Z3JhZEZpbGw+PGE6Z3JhZEZpbGwgcm90V2l0aFNoYXBlPSIxIj48YTpnc0xzdD48YTpncyBwb3M9IjAiPjxhOnNjaGVtZUNsciB2YWw9InBoQ2xyIj48YTp0aW50IHZhbD0iMTAwMDAwIi8+PGE6c2hhZGUgdmFsPSIxMDAwMDAiLz48YTpzYXRNb2QgdmFsPSIxMzAwMDAiLz48L2E6c2NoZW1lQ2xyPjwvYTpncz48YTpncyBwb3M9IjEwMDAwMCI+PGE6c2NoZW1lQ2xyIHZhbD0icGhDbHIiPjxhOnRpbnQgdmFsPSI1MDAwMCIvPjxhOnNoYWRlIHZhbD0iMTAwMDAwIi8+PGE6c2F0TW9kIHZhbD0iMzUwMDAwIi8+PC9hOnNjaGVtZUNscj48L2E6Z3M+PC9hOmdzTHN0PjxhOmxpbiBhbmc9IjE2MjAwMDAwIiBzY2FsZWQ9IjAiLz48L2E6Z3JhZEZpbGw+PC9hOmZpbGxTdHlsZUxzdD48YTpsblN0eWxlTHN0PjxhOmxuIHc9Ijk1MjUiIGNhcD0iZmxhdCIgY21wZD0ic25nIiBhbGduPSJjdHIiPjxhOnNvbGlkRmlsbD48YTpzY2hlbWVDbHIgdmFsPSJwaENsciI+PGE6c2hhZGUgdmFsPSI5NTAwMCIvPjxhOnNhdE1vZCB2YWw9IjEwNTAwMCIvPjwvYTpzY2hlbWVDbHI+PC9hOnNvbGlkRmlsbD48YTpwcnN0RGFzaCB2YWw9InNvbGlkIi8+PC9hOmxuPjxhOmxuIHc9IjI1NDAwIiBjYXA9ImZsYXQiIGNtcGQ9InNuZyIgYWxnbj0iY3RyIj48YTpzb2xpZEZpbGw+PGE6c2NoZW1lQ2xyIHZhbD0icGhDbHIiLz48L2E6c29saWRGaWxsPjxhOnByc3REYXNoIHZhbD0ic29saWQiLz48L2E6bG4+PGE6bG4gdz0iMzgxMDAiIGNhcD0iZmxhdCIgY21wZD0ic25nIiBhbGduPSJjdHIiPjxhOnNvbGlkRmlsbD48YTpzY2hlbWVDbHIgdmFsPSJwaENsciIvPjwvYTpzb2xpZEZpbGw+PGE6cHJzdERhc2ggdmFsPSJzb2xpZCIvPjwvYTpsbj48L2E6bG5TdHlsZUxzdD48YTplZmZlY3RTdHlsZUxzdD48YTplZmZlY3RTdHlsZT48YTplZmZlY3RMc3Q+PGE6b3V0ZXJTaGR3IGJsdXJSYWQ9IjQwMDAwIiBkaXN0PSIyMDAwMCIgZGlyPSI1NDAwMDAwIiByb3RXaXRoU2hhcGU9IjAiPjxhOnNyZ2JDbHIgdmFsPSIwMDAwMDAiPjxhOmFscGhhIHZhbD0iMzgwMDAiLz48L2E6c3JnYkNscj48L2E6b3V0ZXJTaGR3PjwvYTplZmZlY3RMc3Q+PC9hOmVmZmVjdFN0eWxlPjxhOmVmZmVjdFN0eWxlPjxhOmVmZmVjdExzdD48YTpvdXRlclNoZHcgYmx1clJhZD0iNDAwMDAiIGRpc3Q9IjIzMDAwIiBkaXI9IjU0MDAwMDAiIHJvdFdpdGhTaGFwZT0iMCI+PGE6c3JnYkNsciB2YWw9IjAwMDAwMCI+PGE6YWxwaGEgdmFsPSIzNTAwMCIvPjwvYTpzcmdiQ2xyPjwvYTpvdXRlclNoZHc+PC9hOmVmZmVjdExzdD48L2E6ZWZmZWN0U3R5bGU+PGE6ZWZmZWN0U3R5bGU+PGE6ZWZmZWN0THN0PjxhOm91dGVyU2hkdyBibHVyUmFkPSI0MDAwMCIgZGlzdD0iMjMwMDAiIGRpcj0iNTQwMDAwMCIgcm90V2l0aFNoYXBlPSIwIj48YTpzcmdiQ2xyIHZhbD0iMDAwMDAwIj48YTphbHBoYSB2YWw9IjM1MDAwIi8+PC9hOnNyZ2JDbHI+PC9hOm91dGVyU2hkdz48L2E6ZWZmZWN0THN0PjxhOnNjZW5lM2Q+PGE6Y2FtZXJhIHByc3Q9Im9ydGhvZ3JhcGhpY0Zyb250Ij48YTpyb3QgbGF0PSIwIiBsb249IjAiIHJldj0iMCIvPjwvYTpjYW1lcmE+PGE6bGlnaHRSaWcgcmlnPSJ0aHJlZVB0IiBkaXI9InQiPjxhOnJvdCBsYXQ9IjAiIGxvbj0iMCIgcmV2PSIxMjAwMDAwIi8+PC9hOmxpZ2h0UmlnPjwvYTpzY2VuZTNkPjxhOnNwM2Q+PGE6YmV2ZWxUIHc9IjYzNTAwIiBoPSIyNTQwMCIvPjwvYTpzcDNkPjwvYTplZmZlY3RTdHlsZT48L2E6ZWZmZWN0U3R5bGVMc3Q+PGE6YmdGaWxsU3R5bGVMc3Q+PGE6c29saWRGaWxsPjxhOnNjaGVtZUNsciB2YWw9InBoQ2xyIi8+PC9hOnNvbGlkRmlsbD48YTpncmFkRmlsbCByb3RXaXRoU2hhcGU9IjEiPjxhOmdzTHN0PjxhOmdzIHBvcz0iMCI+PGE6c2NoZW1lQ2xyIHZhbD0icGhDbHIiPjxhOnRpbnQgdmFsPSI0MDAwMCIvPjxhOnNhdE1vZCB2YWw9IjM1MDAwMCIvPjwvYTpzY2hlbWVDbHI+PC9hOmdzPjxhOmdzIHBvcz0iNDAwMDAiPjxhOnNjaGVtZUNsciB2YWw9InBoQ2xyIj48YTp0aW50IHZhbD0iNDUwMDAiLz48YTpzaGFkZSB2YWw9Ijk5MDAwIi8+PGE6c2F0TW9kIHZhbD0iMzUwMDAwIi8+PC9hOnNjaGVtZUNscj48L2E6Z3M+PGE6Z3MgcG9zPSIxMDAwMDAiPjxhOnNjaGVtZUNsciB2YWw9InBoQ2xyIj48YTpzaGFkZSB2YWw9IjIwMDAwIi8+PGE6c2F0TW9kIHZhbD0iMjU1MDAwIi8+PC9hOnNjaGVtZUNscj48L2E6Z3M+PC9hOmdzTHN0PjxhOnBhdGggcGF0aD0iY2lyY2xlIj48YTpmaWxsVG9SZWN0IGw9IjUwMDAwIiB0PSItODAwMDAiIHI9IjUwMDAwIiBiPSIxODAwMDAiLz48L2E6cGF0aD48L2E6Z3JhZEZpbGw+PGE6Z3JhZEZpbGwgcm90V2l0aFNoYXBlPSIxIj48YTpnc0xzdD48YTpncyBwb3M9IjAiPjxhOnNjaGVtZUNsciB2YWw9InBoQ2xyIj48YTp0aW50IHZhbD0iODAwMDAiLz48YTpzYXRNb2QgdmFsPSIzMDAwMDAiLz48L2E6c2NoZW1lQ2xyPjwvYTpncz48YTpncyBwb3M9 [truncated, was 27908]
}

Front end: airDev downloader

URL to file:
https://2c7b72955cb81ec1a99b821510a561cb.cdn.bubble.io/f1721808625179x843928011772459500/Payroll.xlsx?_gl=1*891pf*_gcl_au*ODIwNDE1NjI0LjE3MTkyMTI1MjY.*_ga*NzE3NDIxNTI1LjE2OTU3MTI5MDY.*_ga_BFPVR2DEE2*MTcyMTgxMTQzMC4yMTAuMS4xNzIxODEyOTI1LjYwLjAuMA…

[sxtn.digital]

Solved

JSON to XLSX with airDev downloader: file format or file extension is not valid

Slow respone today, could be the vacation times But im thankful for beeing pushed to find the sulotion myself. Always the best way to learn So just for closing this post, this was break true. 18h in I find the most simple solutions… Why no just ask GPT and let the machines take care of my hustle…To just share some “in my point of veiw” totaly revolutionast exåerience. I have created a document with all restriktions and limitations regarding the toolbox plugin …

[dennisv24]

Hi all,

I have a small problem, when exporting a excel file…

I want the export a list of data, I added “format as JSON-safe” behind the text field, but only when in add this the file seems to have a problem it’s 3B and when opening the file I get this error;

“Excel cannot open the file ’my_file (2).xlsx’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.”

This is only when I add the “format as JSON-safe” operator behind the text field… I do have text that are using newlines, qoutes and special characters.

Anyone suggestions?

[rico.trevisan]

My hunch is that one of these fields has a character that is breaking the JSON.

@dennisv24

When you use :formatted as JSON-safe, you don’t need the quotes around it. Also, make sure you set defaults to everything – JSON no-likey null. I think the JSON-safe operator takes care of that, but for the belt-and-suspenders approach, I append :defaulting to "".

So,

{
  ...
  "Message": This Logbook's LogText:formatted as JSON-safe,
  ...
}

Also, what does This Logbook's ReportUser return? The actual object? Just the ID? Might be worthwhile to paste this entire expression on a page so you can visually troubleshoot the output.