EXcel with VB6.0

[robinp]

Hi All,

MY Application is a web application.Client from the user system ca
upload a EXCEL file for processing at WEBSERVER.

The Requirement is when the processing of excel is going any ba
records according to busines rule if found need to be written into
new EXCEL file.

The VB componet used for it refer a EXCEL object but at serve
according to client wouldnt be any "MS OFFICE" Installed thu my progra
to generate the EXCEL obejct refernce is not working.

Is there any way by which without installing MS OFFICE at webserver
can create a EXCEL file.

THis is urgent please help.

Thanks in advance.

Regards
Robi

 

[Guest]

you can just create a comma separated file. It can be read by EXCEL. It
doesn't have to .xls file.

Kanan

 

[NickHK]

Robin,
Also, there are classes available that can write the Excel file format
directly, with limitations:
e.g.
http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=11898&ln
gWId=1

NickHK

 

[Nick Hebb]

NickHK,

That's a pretty cool link. Do you know of any components that can read
Excel files? Because unless he can open the file for processing on the
server, I think he's still in trouble.

 

[NickHK]

Nick,
I was going to ask about the opening aspect, but assumed ADO etc.

As for reading Excel files, I have nothing immediately available, but with
some work you MAY get some mileage out of the reverse of the write code in
that class.
But whilst you can write an older file format and Excel can read it, it
would be another matter for yourself to read the newer format(s) that Excel
writes.

Nick

 

[NickHK]

Nick,
Just found this, nothing in VB but should give the details of what you need
to do:
http://chicago.sourceforge.net/devel/docs/excel/

NickHK