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?