How to get count of column from excel sheet

Question

Hello members, Hope you are doing good!! can any one guide me on How to get count of numbers column from excel sheet using C#

Jay Krishna Reddy · Answer

using Excel = Microsoft.Office.Interop.Excel; Excel.Application xlApp = null ; Excel.Workbook wb = null ; Excel.Worksheet worksheet = null ; int lastUsedRow = 0; int lastUsedColumn = 0; string srcFile = @ "Path to your XLSX file" ; xlApp = new Excel.ApplicationClass(); xlApp.Visible = false ; wb = xlApp.Workbooks.Open(srcFile, 0, false , 5, "" , "" , false , Excel.XlPlatform.xlWindows, "" , true , false , 0, true , false , false ); worksheet = (Excel.Worksheet)wb.Worksheets[1]; Excel.Range range // Find the last real row lastUsedRow = worksheet.Cells.Find( "*" ,System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, Excel.XlSearchOrder.xlByRows,Excel.XlSearchDirection.xlPrevious, false ,System.Reflection.Missing.Value,System.Reflection.Missing.Value).Row; // Find the last real column lastUsedColumn = worksheet.Cells.Find( "*" , System.Reflection.Missing.Value, System.Reflection.Missing.Value,System.Reflection.Missing.Value, Excel.XlSearchOrder.xlByColumns,Excel.XlSearchDirection.xlPrevious, false ,System.Reflection.Missing.Value,System.Reflection.Missing.Value).Column; xlApp.Workbooks.Close(); xlApp.Quit(); Marshal.ReleaseComObject(worksheet); Marshal.ReleaseComObject(wb); Marshal.ReleaseComObject(xlApp); Hope this helps you...

Leon D · Answer

You can use Free Spire.XLS library to easiy get the number of columns in an Excel sheet. At first, search and install free spire.xls via nuget. Second, use the following code to get the number of columns in a sheet. Workbook workbook = new Workbook(); workbook.LoadFromFile( "test.xlsx" ); Worksheet sheet = workbook.Worksheets[0]; int columnCount = sheet.Columns.Count();

Jay Krishna Reddy · Answer

Just hover on the Word press CTRL + . it will show dependencies to install.

Yogesh Vedpathak · Answer

Hi Jay Thanks for quick reply there are so many dependencies need to be installed could you please mentioned that ?

Darshan Shah · Answer

Also you can use NPoi library to get the column count and many other options to play.

How to get count of column from excel sheet

Answers (5)