Writing to Excel without installation of MS Excel
-
Dear all, Is there a way to create excel files and write data into excel files using C#, without the installation of MS Excel on the computer? Thanks in advance.
There are some components out there (for example XLSReadWriteII.NET) but which versions of excel file format they support (and they are all different) is another matter. If you are talking about creating the file and writing into it, why not use a CSV file, which is simple to create, simple to amend, and any flavour of excel can read them.
All those who believe in psycho kinesis, raise my hand.
-
There are some components out there (for example XLSReadWriteII.NET) but which versions of excel file format they support (and they are all different) is another matter. If you are talking about creating the file and writing into it, why not use a CSV file, which is simple to create, simple to amend, and any flavour of excel can read them.
All those who believe in psycho kinesis, raise my hand.
-
I can't use csv, it most be xls. What about using the oledb? with oledb u can also easly read and write excel, bud do you need then MS Excel for this?
Haven't tried it myself, but this says YES YOU DO[^] which makes sense to me. Have you considered farming the excel stuff to a server which does have excel loaded (I assume it is the cost that stops you installing on all machines)?
All those who believe in psycho kinesis, raise my hand.
-
Dear all, Is there a way to create excel files and write data into excel files using C#, without the installation of MS Excel on the computer? Thanks in advance.
-
Dear all, Is there a way to create excel files and write data into excel files using C#, without the installation of MS Excel on the computer? Thanks in advance.
NPOI[^] will do this, open source too :-D
Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Why are you using VB6? Do you hate yourself? (Christian Graus)