ExcelReadExcel Method
Reads a xlsx file and returns a list of lists of cells (one list of cells per row)
Namespace: PCBI.Automation.IOAssembly: PCB-Investigator (in PCB-Investigator.exe) Version: 0
public static List<List<ExcelCell>> ReadExcel(
IFileData xlsxFile,
int sheetID,
out string sheetName,
out string error,
out int totalSheetCount
)
Public Shared Function ReadExcel (
xlsxFile As IFileData,
sheetID As Integer,
<OutAttribute> ByRef sheetName As String,
<OutAttribute> ByRef error As String,
<OutAttribute> ByRef totalSheetCount As Integer
) As List(Of List(Of ExcelCell))
public:
static List<List<ExcelCell^>^>^ ReadExcel(
IFileData^ xlsxFile,
int sheetID,
[OutAttribute] String^% sheetName,
[OutAttribute] String^% error,
[OutAttribute] int% totalSheetCount
)
static member ReadExcel :
xlsxFile : IFileData *
sheetID : int *
sheetName : string byref *
error : string byref *
totalSheetCount : int byref -> List<List<ExcelCell>>
- xlsxFile IFileData
- XLSX File to read
- sheetID Int32
- Index of the sheet (zero based)
- sheetName String
- Returns the name of this sheet or empty
- error String
- Returns the error information if funtion fails
- totalSheetCount Int32
- Returns number of sheets in the file
ListListExcelCellList of lists of cells