Скачать с ютуб How to read data from an excel file with C# using Microsoft.Office.Interop.Excel в хорошем качестве

How to read data from an excel file with C# using Microsoft.Office.Interop.Excel

How to read data from an excel file with C# using Microsoft.Office.Interop.Excel Code: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.IO; using System.Runtime.InteropServices; using Excel = Microsoft.Office.Interop.Excel; namespace readExcelThroughExcelApp { internal class Program { static void Main(string[] args) { Excel.Application excelApp = new Excel.Application(); Excel.Workbook excelWB = excelApp.Workbooks.Open(@"C:\Users\AZHAR PC\Desktop\vbscript\sample.xlsx"); Excel._Worksheet excelWS = excelWB.Sheets[1]; Excel.Range excelRange = excelWS.UsedRange; int rowCount = excelRange.Rows.Count; int columnCount = excelRange.Columns.Count; for(int i = 1; i = rowCount; i++) { for(int j=1;j =columnCount; j++) { if (excelRange.Cells[i, j] != null) { Console.Write(excelRange.Cells[i, j].Value2.ToString()+" "); } } } Console.ReadKey(); Marshal.ReleaseComObject(excelWS); Marshal.ReleaseComObject(excelRange); excelWB.Close(); Marshal.ReleaseComObject(excelWB); excelApp.Quit(); Marshal.ReleaseComObject(excelApp); } } } Chapters: 0:00 - Introduction to the video 0:24 - Procedure to read data from excel 10:16 - End tags and subscription to the channel My second Channel: WrestleTalkByAzhar -    / wrestletalkbyazhar   Follow Insta:   / kingazharjamal     / fari_digi   One Card App Link to Apply: https://1cardapp.page.link/88LF Cred App Link to Apply: https://app.cred.club/spQx/ud86uunq Next Steps : --------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------- Must Watch Playlists ► 1. Javascript -    • Javascript Factory   ► 2. Puppetter -    • Puppeteer   ► 3. Cypress -    • Cypress   ► 4. Tech works -    • Видео   ► 5. Vbscript Basics To Advanced -    • VBScript Part 1 -  Features Advantage...   ► 6. Jmeter -    • Jmeter Tutorials   ► 7. Excel -    • Videos On Excel   ► 8. Appium -    • Appium   ► 9. Shares -    • Shares   ► 10. Javascript Interview Questions -   • Javascript Interview Questions   ► 11. C# Tutorials -    • C# Factory   ► 12. HTML & CSS -    • HTML & CSS   ► 13. Browser Console -    • Browser Console   ► 14. JSON -    • Videos on Json   ► 15. Specflow -    • Specflow Tutorials   ► 16. MongoDB -    • MongoDB Tutorials   ► 17. Postman -    • Postman   ► 18. Python -    • Python   --------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------- #excel #csharp #csharptutorial