NeoSheet

#1 · November 7, 2025, 9:19 am

In neoSheetInit there are options Data array JSON or variable and Column definitions JSON or variable. I wonder what these means.

In jsspreadsheet documentations data is a javascript array and Column is javascipt array of objects.

So what is the right syntax of JSON in neoSheetInit in these two options in neoSheet?

#2 · November 8, 2025, 8:55 am

@kajanken please check the attached sample app.
It's unfinished but I hope it will let you start working with neoSheet and understand easily how it works.

Regards.

Uploaded files:

You need to login to have access to uploads.

kajanken has reacted to this post.

#3 · November 12, 2025, 12:33 pm

I'm wondering if it's possible to import from a comma separated CSV-file? I would also like to use commas instead of tabs when exporting to CSV. Is that possible?

Thanks very much!
Joerg

#4 · November 12, 2025, 8:10 pm

@joerg as neoSheet allows an Array as the input data, you can create that Array from any data file, including a CSV.
Check neoSQL plugin to manage different data sources.
Regards.

#5 · November 13, 2025, 9:33 am

Thanks Luis! Also for the tip about neoSQL. That's very useful!
Kind regards,
Joerg

#6 · November 13, 2025, 2:13 pm

Please could you give an example, how an array should look like, when using "neoSheetSetData"? Sorry, couldn't figure it out...

Thanks very much!!
Joerg

#7 · November 14, 2025, 8:35 pm

@joerg remember you can always use Consolelog [ArrayName] to show in the Console the Array data structure.

In this case (my sample app) it looks like this:

[
  [
    "Crayons Crayola only (No Rose Art)",
    2,
    5.01,
    0.01,
    "=B1*C1*(1-D1)"
  ],
  [
    "Colored Pencils Crayola only",
    2,
    4.41,
    0.02,
    "=B2*C2*(1-D2)"
  ],
  [
    "Expo Dry-erase Markers Wide",
    4,
    3,
    0.1,
    "=B3*C3*(1-D3)"
  ],
  [
    "Index Cards Unlined",
    3,
    6,
    0.03,
    "=B4*C4*(1-D4)"
  ],
  [
    "Tissues",
    10,
    1.9,
    0.01,
    "=B5*C5*(1-D5)"
  ],
  [
    "Ziploc Sandwich-size Bags",
    5,
    1,
    0.01,
    "=B6*C6*(1-D6)"
  ],
  [
    "Thin Markers Crayola only",
    2,
    3,
    0.02,
    "=B7*C7*(1-D7)"
  ],
  [
    "Highlighter",
    4,
    1.2,
    0.01,
    "=B8*C8*(1-D8)"
  ],
  [
    "Total",
    "=SUM(B1:B8)",
    "=ROUND(SUM(C1:C8), 2)",
    "",
    "=SUM(E1:E8)"
  ]
]

Regards.

#8 · November 17, 2025, 9:29 am

oh I see! Yes, the consolelog feature is very useful. Thanks Luis for taking the time!
Kind regards,
Joerg

luishp has reacted to this post.

NeoSheet - Forum

NeoSheet