View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Generate Excel files on server

How complex is the content? Are there multiple sheets, formulae etc ?
If you can get a handle on the format then you can write out the
content as xml and XL 2K(?)+ should be able to open it.

If it's just a straight tabular format on one sheet then you could try
writing it out an an HTML table and giving it an xls extension.

Otherwise look at a component to do the creation:
http://officewriter.softartisans.com...writer-37.aspx
is a good one I think (but haven't used it myself)

Tim


"David" wrote in message
...
Hello,
I want to create a C# application running on a Windows 2003 server.

This application retrieves data from a database, performs some
modifications then creates an Excel file on a shared folder on the
server. Then at any time, users on the network can get the file to see
the formatted data.

There is no web involved. It is a service running on the server that

creates periodically the Excel file.

Is there a way to do that without having Excel installed on the

server?

Thanks,
David.