EXcel with VB6.0
 

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

--
robin
-----------------------------------------------------------------------
robinp's Profile: http://www.excelforum.com/member.php...fo&userid=2744
View this thread: http://www.excelforum.com/showthread.php?threadid=46952

EXcel with VB6.0
 

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

Kanan

"robinp" wrote:


Hi All,

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

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

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

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

THis is urgent please help.

Thanks in advance.

Regards
Robin


--
robinp
------------------------------------------------------------------------
robinp's Profile: http://www.excelforum.com/member.php...o&userid=27442
View this thread: http://www.excelforum.com/showthread...hreadid=469525

EXcel with VB6.0
 

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...odeId=11898&ln
gWId=1

NickHK

"robinp" wrote in
message ...

Hi All,

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

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

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

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

THis is urgent please help.

Thanks in advance.

Regards
Robin


--
robinp
------------------------------------------------------------------------
robinp's Profile:
http://www.excelforum.com/member.php...o&userid=27442
View this thread: http://www.excelforum.com/showthread...hreadid=469525

EXcel with VB6.0
 

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.

----
Nick Hebb
BreezeTree Software
http://www.breezetree.com

EXcel with VB6.0
 

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


"Nick Hebb" wrote in message
oups.com...
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.

----
Nick Hebb
BreezeTree Software
http://www.breezetree.com

EXcel with VB6.0
 

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

"Nick Hebb" wrote in message
oups.com...
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.

----
Nick Hebb
BreezeTree Software
http://www.breezetree.com