A few people have asked for the code I use to interact with Excel so I have decided to post some of the methods here.
You will need to make a reference to Microsoft.Office.Interop.Excel for this code to compile properly.
My Excel Framework Methods
My Excel Framework Methods
You do not have the required permissions to view the files attached to this post.
If this or any response has helped you, please reply to the thread stating that it worked so other people with a similar issue will know how you fixed your issue!
Ciege...
Ciege...
Re: My Excel Framework Methods
Hi Ciege
Which version of Excel are supported with your framework?
I had similar goal and re-used nice and free library called NPOI which provides great possibilities to read/write excel file (including such amazing features as formatting, comments for cells, hyperlinks, reading cashed formula results and so on and so on).
If you need something more then just read string data or write string data to excel file - I would recommend everybody to spend 5-10 minutes and check NPOI (first result from google search) library
-re
Pavlo
Which version of Excel are supported with your framework?
I had similar goal and re-used nice and free library called NPOI which provides great possibilities to read/write excel file (including such amazing features as formatting, comments for cells, hyperlinks, reading cashed formula results and so on and so on).
If you need something more then just read string data or write string data to excel file - I would recommend everybody to spend 5-10 minutes and check NPOI (first result from google search) library
-re
Pavlo
Re: My Excel Framework Methods
I use V12, but the methods should work for most any modern version of Excel.
If this or any response has helped you, please reply to the thread stating that it worked so other people with a similar issue will know how you fixed your issue!
Ciege...
Ciege...
Re: My Excel Framework Methods
Hiya,
We used the NPOI library for excel interaction
http://npoi.codeplex.com/
It only support .XLS format - but has the added advantage that is doesnt need Excel installed on the PC
Clayton
We used the NPOI library for excel interaction
http://npoi.codeplex.com/
It only support .XLS format - but has the added advantage that is doesnt need Excel installed on the PC
Clayton
Re: My Excel Framework Methods
Some of our developers have been experimenting with EP Plus. It's released under the LGPL and does not require MS Office on the system.
EP Plus: http://epplus.codeplex.com/
It only appears to create XLSX files (Excel 2007 formats), though. It requires .Net Framwork 3.5 or higher.
It's based upon the older ExcelPackage project (http://excelpackage.codeplex.com/).
Does anyone have any experience using either of these in comparison to NPOI?
EP Plus: http://epplus.codeplex.com/
It only appears to create XLSX files (Excel 2007 formats), though. It requires .Net Framwork 3.5 or higher.
It's based upon the older ExcelPackage project (http://excelpackage.codeplex.com/).
Does anyone have any experience using either of these in comparison to NPOI?
