Convert to File XLSX - Position Data

Questions
, ,
1

Hello.

Is there a way to convert JSON to XLSX but place the data to specific rows and columns?

For example i have a json with 4 keys and i want to place them in an xlsx as 4 columns starting from position C3 to F3 for the headers and the data from 4C spanning to 4F, 5C → 5F and so on.

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

hello @Mulen

Well… it’s possible, but will be totally unclear to explain how it goes :sweat_smile:

An example is below. You can set the padding in the first 2 rows of the Code node

It uses a special syntax to create a table by inserting an empty cells

4

@barn4k Thanks for the reply and the example but it is a lot difficult to maintain something like this for me when my coding knowledge is very limited :frowning:

I think i will open a Feature Request.