Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.javascript > #35590

Re: Script in a Spreadsheet - how?

Show all headers | View raw

Dr J R Stockton <J.R.Stockton@physics.org> wrote on 11 Sep 2018 in 
comp.lang.javascript:

> On Tuesday, September 11, 2018 at 10:03:27 AM UTC+1, Evertjan. wrote:
>> Dr J R Stockton wrote on 11 Sep 2018 in comp.lang.javascript:
>> 
>> > Script in a Spreadsheet - how?
>> > ...
> 
>> I would manipulate a .csv file,
>> as that can easily be scripted by FileSystemObject coding in JS.
>> 
>> [Or, more standard, use VBA in Excel.]
> 
> But that does not answer the question - I want to know how
> to insert or connect the code, and how to address an entry.
> I don't want to address the File System, other than by
> opening and saving the sheet.  I want to edit in the sheet.

Nonsense, John.

A [closed] spreadsheet is a file.

You can edit a closed [by your spreadsheet viewer] spreadsheet by 
manipulating the file, and that can be done with JS using FileSystemObject,
run the js in cscript or wscript.

Storing the spreadsheet as an .csv makes that much easier than storing it as 
an .xlsx, as you do not need to know the specs of excel files.   

> It seems likely that an example in any combination of sheet
> and language would help sufficiently.

Not so, a spreadsheet is just a concept, they need to be available in the 
form of a file or other memory-form to be manipulated.

Just like a language needs an execution engine to be useful,
and such engine need to have access to the factual spreadsheet.
What engine did you have in mind for your JS-code?

-- 
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Back to comp.lang.javascript | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 01:31 -0700
  Re: Script in a Spreadsheet - how? "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2018-09-11 11:03 +0200
    Re: Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 03:19 -0700
      Re: Script in a Spreadsheet - how? "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2018-09-11 14:17 +0200
        Re: Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 05:54 -0700
  Re: Script in a Spreadsheet - how? Julio Di Egidio <julio@diegidio.name> - 2018-09-11 03:41 -0700
    Re: Script in a Spreadsheet - how? "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2018-09-11 14:22 +0200
      Re: Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 06:31 -0700
    Re: Script in a Spreadsheet - how? Ben Bacarisse <ben.usenet@bsb.me.uk> - 2018-09-11 15:46 +0100
      Re: Script in a Spreadsheet - how? Dr J R Stockton <J.R.Stockton@physics.org> - 2018-09-11 11:06 -0700

csiph-web