Interop lib Excel automation using c#

Help Activities
, ,
1

Hi guys
I need your help to learn interop library in c# how to create excel ,read,write, delete sheet and file, filter data etc. can you please share any complete guide I have looked into internet but found complete information with step by step tutorial or content.
also I have confuse about excel other libraries which is best and easy to use.
I am facing one problem while working on excel in dot net it’s always show read only when I try to open that even I have close workbook and aplication (xlapps.quit)

2

Not sure if you already saw this source, but here there are some examples directly from Microsoft on how to create/manipulate excel files using interop

https://learn.microsoft.com/en-us/dotnet/csharp/advanced-topics/interop/how-to-access-office-interop-objects

1 Like
3

Can you please help me with some more thread I need to understand complete operation which we can perform in Excel using c#

4

Hi @Aleem_Khan ,

Have you see this seri
Hope it can help you
regards,

5

I want to use in console apps

6

Hi
Please help me for more information appreciate you.