How to read the number of valid rows or the maximum number of valid columns of excel in C #
This article mainly explains "how to read the effective number of rows or the maximum number of valid columns of excel by C#". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to read the number of valid rows or the maximum number of valid columns of excel by C#"!
Using System
Using System.Collections.Generic
Using System.Linq
Using System.Text
Using NPOI.SS.UserModel
Using NPOI.HSSF.UserModel
Using System.IO
Namespace www.xinduofen.cn
{
Class NpoiOperateExcel
{
/ / /
/ / read the number of valid rows or the maximum number of valid columns of a worksheet in an excel file
/ / /
/ / represents the address saved in the excel table, including "file name .xls"
/ represents the index location of the sheet table to be read
/ / the number of valid rows read for true, and the maximum number of valid columns read for false
/ / the return value "not-1" indicates that the read was successful, otherwise it failed.
Public static int rowORcolAllCount (string save_address, int sheet_number, Boolean readFlag) / / read all the data of the corresponding worksheet in the excel table
{
Int rowORcolCnt =-1 position / initialize to-1
FileStream readfile = null
Try
{
/ / if the input parameter is valid
If (! string.IsNullOrEmpty (save_address) & & sheet_number > 0)
{
Readfile = new FileStream (save_address, FileMode.Open, FileAccess.Read)
HSSFWorkbook hssfworkbook = new HSSFWorkbook (readfile)
ISheet sheet = hssfworkbook.GetSheetAt (sheet_number-1)
If (sheet! = null)
{
If (readFlag) / / if you need to read 'valid rows'
{
RowORcolCnt = number of valid rows in sheet.LastRowNum+1;// (the number of valid rows read by NPOI does not include column headers, so add 1)
}
Else
{/ / if you need to read the maximum number of valid columns
For (int rowCnt = sheet.FirstRowNum; rowCnt rowORcolCnt)
{
RowORcolCnt = row.LastCellNum
}
}
}
}
}
}
Catch (Exception)
{
Console.WriteLine ("NpoiOperateExcel.rowOrColumnAllCount method generated an exception!")
}
Finally
{
If (readfile! = null) {readfile.Close ();}
}
Return rowORcolCnt
}
}
}
At this point, I believe you have a deeper understanding of "how to read the effective number of rows or the maximum number of valid columns of excel by C#". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!
