View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Excel automation on server

Hi Bagger,

My question is what is the bare minimum that I need to install in order to
get the capability to read/write Excel 2003 documents? I don't want to put a
full installation of Excel on the server if it can be avoided. Is there
another way? Will it be any different with Excel 2007?


There is a Java tool that allows you to read and write Excel binary files.
Google for J-excel api.
I've also read about a .NET tool that is capable of the same, but I lost the
reference to it.

Alternatively, if you have VBScript capabilities on your site you could use
VBScript and ADO to extract data from Excel files. IIRC it can even write data
back into Excel, as long as it is in table format.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com