471,086 Members | 1,365 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,086 software developers and data experts.

Read and write to Excel and Word on client

I'm converting a VB6/SQL Server application to a web application. I need to
read data to and from Excel and Word. I'm not allowed to install Excel and
Word on the server, only on the client. Is there a way to use client side
scripts to read from and write to Excel/Word files?

Any suggestions are appreciated
Thanks,
polarbear
Mar 1 '06 #1
2 2442
Doing so would require significant changes regarding security (for example
putting the site in the trusted sites list). Is this an intranet ?

Another option would be let the user upload Office documents saved under the
XML format (or whatever you can read server side wihtout the application).

Still another one would be to have the user use a macro that posts the
needed information to your web site (are they supposed to use a template
file ? )...

For Excel only, a last one would be to use the file as a data source and use
an ADO provider to read its content

The big picture may help...

--
Patrice

"polabear" <po******@spitzbergen.com> a écrit dans le message de
news:6C**********************************@microsof t.com...
I'm converting a VB6/SQL Server application to a web application. I need to read data to and from Excel and Word. I'm not allowed to install Excel and
Word on the server, only on the client. Is there a way to use client side
scripts to read from and write to Excel/Word files?

Any suggestions are appreciated
Thanks,
polarbear

Mar 1 '06 #2
Thanks for the quick reply.

This is an intranet site with only 5 - 10 users.

Would that make things easier?

Thanks,
--
polarbear
"Patrice" wrote:
Doing so would require significant changes regarding security (for example
putting the site in the trusted sites list). Is this an intranet ?

Another option would be let the user upload Office documents saved under the
XML format (or whatever you can read server side wihtout the application).

Still another one would be to have the user use a macro that posts the
needed information to your web site (are they supposed to use a template
file ? )...

For Excel only, a last one would be to use the file as a data source and use
an ADO provider to read its content

The big picture may help...

--
Patrice

"polabear" <po******@spitzbergen.com> a écrit dans le message de
news:6C**********************************@microsof t.com...
I'm converting a VB6/SQL Server application to a web application. I need

to
read data to and from Excel and Word. I'm not allowed to install Excel and
Word on the server, only on the client. Is there a way to use client side
scripts to read from and write to Excel/Word files?

Any suggestions are appreciated
Thanks,
polarbear


Mar 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Juan Sanchez | last post: by
reply views Thread by Zed | last post: by
1 post views Thread by Bernd Muent | last post: by
2 posts views Thread by Harry Simpson | last post: by
4 posts views Thread by naiya | last post: by
6 posts views Thread by Mark Rae | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.