How to work with excel file in C#

Question

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

Laxmidhar Sahoo · Answer

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, "	" , false , false , 0, true , 1, 0); xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you https://www.youtube.com/watch?v=lsv7rAsvYuA

Sapna Girish · Answer

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

Jignesh Kumar · Answer

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/

Sanwar Ranwa · Answer

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