Mark Slater

Mark Slater

  • NA
  • 1
  • 0

CReating an Excel spreadsheet File without opening Excel

May 20 2008 4:40 AM

I've read a couple of articles about using C# to open and read an Excel spreadsheet by opening a spreadsheet via the code. Is there a way of writing a Excel file without having to open the spreadsheet.

We have a requirement to read a set of data from a database, put this into an excel spreadsheet so that the data can be used our Marketing department. The database sits at our external hosting site and the current process is to create a comma delimited file, import it into Excel, format and save. All a bit clunky and MANUAL!

I would like to set up a scheduled process, that can run automomously, as abackground process without opening an Excel form. Can this be done?


Answers (1)