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

Groups > comp.lang.javascript > #28311 > unrolled thread

read excel file using java script

Back to article view | Back to comp.lang.javascript

Contents

  read excel file using java script Shankara Subramanian <hs.shankarasubramanian@gmail.com> - 2015-07-06 22:25 -0700
    Re: read excel file using java script Hans-Georg Michna <hans-georgNoEmailPlease@michna.com> - 2015-07-07 09:01 +0200
    Re: read excel file using java script "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2015-07-07 12:09 +0200
    Re: read excel file using java script "Michael Haufe (TNO)" <tno@thenewobjective.com> - 2015-07-07 06:35 -0700
      Re: read excel file using java script JJ <jj4public@vfemail.net> - 2015-07-07 23:08 +0700

#28311 — read excel file using java script

any one suggest a way to read the excel file from a java script code..  (should not use any html)

[toc] | [next] | [standalone]

#28313

On Mon, 6 Jul 2015 22:25:02 -0700 (PDT), Shankara Subramanian
wrote:

>any one suggest a way to read the excel file from a java script code..  (should not use any html)

You would have to rewrite a good part of Excel in JavaScript. A
couple of years of work, perhaps?

It may be easier just to pick strings from the Excel file, but
you would not get the whole structure that way.

The easiest way would be to export the data from Excel in a
format that is much easier to handle, such as TXT, PRN, or CSV.

Hans-Georg

[toc] | [prev] | [next] | [standalone]

#28314

Shankara Subramanian <hs.shankarasubramanian@gmail.com> wrote on 07 Jul
2015 in comp.lang.javascript: 

> any one suggest a way to read the excel file from a java script code.. 
> (should not use any html) 

"java script" != "javascript"

Why this "(should not use any html)"?

A school assignment?

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

[toc] | [prev] | [next] | [standalone]

#28318

On Tuesday, July 7, 2015 at 12:25:14 AM UTC-5, Shankara Subramanian wrote:
> any one suggest a way to read the excel file from a java script code..  (should not use any html)

That would depend on where the ECMAScript variant is running.

If you are running this in classic ASP or in WSH (JScript), then there is an API available through:

var excel = new ActiveXObject("Excel.Application");

If you are running this in a webpage that is NOT an *.hta file, then you would need to be more creative. Newer versions of Excel files *.xslx are zipped files that contain a number of resources including an XML representation of the document. 

Therefore you could unzip the *.xlsx file, modify its resources and then zip it back up.

if you are on Node.js or another environment I don't know what is available but the unzipping tactic would work there as well.

[toc] | [prev] | [next] | [standalone]

#28320

On Tue, 7 Jul 2015 06:35:20 -0700 (PDT), Michael Haufe (TNO) wrote:
> 
> If you are running this in classic ASP or in WSH (JScript), then there is
> an API available through: 
> 
> var excel = new ActiveXObject("Excel.Application"); 

Assuming that the system has Microsoft Excel installed.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.javascript

csiph-web