How to work with excel file in C#

pavan machavarapu

7y1.8kVisual Basic .NET

How to work with excel file in C# without having the excel software in my PC how to read and modified that file

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://www.youtube.com/watch?v=lsv7rAsvYuA
0
Sapna Girish7y ago
You can try Spire.XLS to read and edit Excel files. It doesn't rely on MS Excel.

https://www.e-iceblue.com/Introduce/excel-for-net-introduce.html
0
Jignesh Kumar7y ago
Hi Pavan,

Please find below link for read and write operation with Excel
https://www.c-sharpcorner.com/article/create-update-delete-and-reading-the-excel-file-in-c-sharp/
0
Laxmidhar Sahoo7y ago
With the variable xlWorksheet can read and by save as can write.
Microsoft.Office.Interop.Excel.Application xlApp;
           Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
           Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
           Microsoft.Office.Interop.Excel.Range range;

           string str;
           int rCnt = 0;
           int cCnt = 0;
           string excelpath = fname;
           xlApp = new Microsoft.Office.Interop.Excel.Application();
           xlWorkBook = xlApp.Workbooks.Open(@excelpath, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
           xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
+1
Sanwar Ranwa7y ago
Hello Pavan

Please check these and try to implement in your code

https://www.youtube.com/watch?v=lsv7rAsvYuA

https://www.youtube.com/watch?v=TjaBWsEmbT8

https://coderwall.com/p/app3ya/read-excel-file-in-c

https://support.microsoft.com/en-in/help/302084/how-to-automate-microsoft-excel-from-microsoft-visual-c-net
0