important : Fill Excel File using C#

Question

Hello everybody. I m trying to fill excel file from c# more than one month
I know here is experienced people who can give me some useful advices.
So... There is .xls international Form in it is lots of columns rows and texts. I want to program c# app which can insert values in current place. for example insert 239 USD in 27, K (this is a address of excel forms cell)
Does it possible?
What is your advice?
If it easier way to use html or something another?
i need step by step tutorials or book or something
It is very very important for me
Thanks

Roy S · Answer

You could use excel automation but personally I would use gembox.Spreadsheet . It's faster less memory consuming and you don't have to have excel installed (same goes for those who are going to use it). For the gembox.spreadsheet: 1) Download the installer and install it. 2) Go to visual studio and in the solution explorer right-click references and choose 'add reference' 3) under the tab 'browse' browse to 'C:\Program Files\GemBox Software\GemBox.Spreadsheet Free 3.3\Bin\ NET30 \GemBox.Spreadsheet.dll' ( NET30 meaning the .net framework you're using (I assume 30 is also for 3.5) ) 4) Press ok 5) Add 'using GemBox.Spreadsheet;' to the rest of the 'using...'s 6) Write your code to create fill in and save an excel file (see example). Example: //create a new excelfile with a worksheet in it ExcelFile ef = new ExcelFile(); ExcelWorksheet ws = ef.Worksheets.Add(Name); //fill the cells with something ws.Cells[0 0].Value = test; ws.Cells[1 0].Value = hello; //save as xls try { //@ in front of text => ignore special characters like \ ef.SaveXls(@C:\excelFile.xls); } catch (Exception ex) { //something went wrong (file is in use or whatever Console.WriteLine(ex.ToString()); }