Using VBscript to change an Excel spreadsheet without Excel Application

[chris.kernaghan]

Hi,

I have created a VBscript to format an Excel spreadsheet, but when I go
to execute it on the server that has the database from which the data
is extracted, I get an error as the server does not have Excel
installed on it.

Is there ANY way to get around this without having to install Excel,
inventive answers are more than welcome.

TIA

Chris aka BoobBoo

 

[Harlan Grove]

I have created a VBscript to format an Excel spreadsheet, but when I go
to execute it on the server that has the database from which the data
is extracted, I get an error as the server does not have Excel
installed on it.

Is there ANY way to get around this without having to install Excel,
inventive answers are more than welcome.

Maybe not using VBScript. There are Perl modules that can write Excel .XLS
files without using Excel. Good luck translating them to VBScript.

 

[McKirahan]

Hi,

I have created a VBscript to format an Excel spreadsheet, but when I go
to execute it on the server that has the database from which the data
is extracted, I get an error as the server does not have Excel
installed on it.

Is there ANY way to get around this without having to install Excel,
inventive answers are more than welcome.

TIA

Chris aka BoobBoo

If the client has MS-Excel installed and the use Internet Explorer and
they'll permit a Security Violation, you could use VBScript on the
client-side. Or look into HTML Application (HTA).

 

[Joe Fawcett]

Hi,

I have created a VBscript to format an Excel spreadsheet, but when I go
to execute it on the server that has the database from which the data
is extracted, I get an error as the server does not have Excel
installed on it.

Is there ANY way to get around this without having to install Excel,
inventive answers are more than welcome.

TIA

Chris aka BoobBoo

With traditional BIFF files (the format used by Excel) you're basically
manipulating a binary file, so in theory it's possible using the
adodb.stream object, but you'd need a very good knowledge of the format.
If you're able to store the files as XML, as used in the the last two
versions of Excel, then it's more feasible as you can maniplulate the DOM or
use XSLT.