Create excel file c# 1

[tsisher]

Hi, I am working on c# application and the requirement is when I get data from the database, I have to do few calculations and based on those business logics I have to create a new excel file and save some data on the excel file.



Solution I am after,

1) How to create an excel file within the business logic ( within the code)

2) How to add new data to the file which I have created in the first step.

Please advise.



Thanks and Regards,

ts

 

[jmeckley]

i really like carlosag's Excel Writer. for creating excel documents. it's all xml based and does not require any Office InterOp assemblies.

I use this to generate new XLS files. you will need to verify if you can open/append data with this library. I assume you can.

Jason Meckley
Programmer
Specialty Bakers, Inc.