Excel in C#

[Kürþat]

Hi,

What is the best and most up to date way of using excel in C# programs?

Thanks in advance

 

[Carl Ganz]

Hi,

What is the best and most up to date way of using excel in C# programs?

Thanks in advance

I'd highly recommend third-party tools like SyncFusions's XlsIO or
SoftArtisan's ExcelWriter. They can do almost everthing Excel can do
but are written as .NET assemblies and are dramatically (like 100x)
faster.

Thanks

Carl

 

[Ignacio Machin ( .NET/ C# MVP )]

Hi,

What is the best and most up to date way of using excel in C# programs?

Thanks in advance

Hi,

What s what you want to do?
To start do a search for C# excel interop and you will get plenty of
articles about it

 

[sloan]

Do you want to read or write or read+write excel?


Readonly, you can avoid interop and get an IDataReader on the file contents.



http://www.farpointspread.com/spread/?gclid=COjQ4sz7pZoCFQOIFQodcAqH9w
Check them out.

Don't reinvent the wheel these guys have created.

 

[Kürsat]

message

Hi,

What is the best and most up to date way of using excel in C# programs?

Thanks in advance

Hi,

What s what you want to do?
To start do a search for C# excel interop and you will get plenty of
articles about it

Well, I know about excel interop. I used it before and I remember strange
behavior about the technique. For example, if I remember correctly, excel
process was staying alive after we close the application keeping the file on
which I worked locked until I manually end the process using task manager.

 

[Kürsat]

Hi,

What is the best and most up to date way of using excel in C# programs?

Thanks in advance

I'd highly recommend third-party tools like SyncFusions's XlsIO or
SoftArtisan's ExcelWriter. They can do almost everthing Excel can do
but are written as .NET assemblies and are dramatically (like 100x)
faster.

Thanks Carl.

 

[Kürþat]

Do you want to read or write or read+write excel?


Readonly, you can avoid interop and get an IDataReader on the file
contents.



http://www.farpointspread.com/spread/?gclid=COjQ4sz7pZoCFQOIFQodcAqH9w
Check them out.

Don't reinvent the wheel these guys have created.

Thanks sloan, but your link points to a commercial product page. Can you
give me links points to articles and code samples about reading excel files
via IDataReader ?

 

[sloan]

http://www.google.com/search?hl=en&q=IDataReader+Excel&aq=f&oq=
?

My example is here:
http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!176.entry

Code is downloadable, run the app and pick "excel" of course.

 

[Jesse Houwing]

Hello Kürþat,

Hi,

What is the best and most up to date way of using excel in C#
programs?

Thanks in advance

Aspose also has a very nice component to do this job efficiently.

Another Question... In which context are you thinking of using Excel? In
a windows forms app? In a webapp? are you showing an embedded version of
excel, or just opening a file in excel later?

 

[Filip Krnjic]

Hi Kürþat,

You should use 3rd party component. Most 3rd party components are over
100 times faster then Office interop and they don't need your clients to
have Microsoft Excel installed on their computers for application to
work. You should try GemBox <a
href="http://www.gemboxsoftware.com/GBSpreadsheet.htm">spreadsheet
component</a> that is free for use if you need less then 150 rows.

Filip
<a gref="http://www.gemboxsoftware.com">Excel component</a>

 

[Filip Krnjic]

Hi Kürþat,

You should use 3rd party component. Most 3rd party components are over
100 times faster then Office interop and they don't need your clients to
have Microsoft Excel installed on their computers for application to
work. You should try GemBox <a
href="http://www.gemboxsoftware.com/GBSpreadsheet.htm">spreadsheet
component</a> that is free for use if you need less then 150 rows.

Filip
<a href="http://www.gemboxsoftware.com">Excel component</a>