How to use MS Excel in .net without installing Excel
-
Hi I'm using MS Excel sheets in my Application, for this purpose MS Excel should be installed at the server. Now I wana use Execl App in my project but without installing the Excel at my machine (server). how can I do this?
Regards, Qaiser Nadeem
-
Hi I'm using MS Excel sheets in my Application, for this purpose MS Excel should be installed at the server. Now I wana use Execl App in my project but without installing the Excel at my machine (server). how can I do this?
Regards, Qaiser Nadeem
You really can't, unless you fancy writing your own code that understands the full excel file format.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
Hi I'm using MS Excel sheets in my Application, for this purpose MS Excel should be installed at the server. Now I wana use Execl App in my project but without installing the Excel at my machine (server). how can I do this?
Regards, Qaiser Nadeem
If you don't have Excel installed in your machine then it would not also be in COM components by using EXCEL COM only you can manipulate Excel. I think its not possible to use without Excel. Whats the problem for installing the excel in your machine ? -- modified at 2:13 Friday 21st September, 2007
Thanks and Regards Sandeep If If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "
-
Hi I'm using MS Excel sheets in my Application, for this purpose MS Excel should be installed at the server. Now I wana use Execl App in my project but without installing the Excel at my machine (server). how can I do this?
Regards, Qaiser Nadeem
Actually, you can use Excel files without having Excel installed. You can manipulate it's data through ADO. Now this only allows you to manipulate the data and doesn't allow you to actually automate Excel. Example of how to connect to a Excel file.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties="Excel 8.0;HDR=YES;"
For more information, check here: http://support.microsoft.com/kb/316934[^]