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
Loading
Roy SPosted Nov 7, 2010, 12:49 PM
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: