static private ReadExcelFile ( string path ) : |
||
path | string | |
Résultat |
public static object[][] ReadFromFile(FileInfo file, string sheetName, bool readAsStrings = false, bool showExcel = true) { object[][] data; if (!showExcel) { ExcelInterop.ShowOnStartup = false; } WorkBook wb = WorkBook.ReadExcelFile(file.FullName); WorkSheet ws = wb.GetWorksheetByName(sheetName); if (readAsStrings) { data = ws.GetData(true); } else { data = ws.Data; } if (!showExcel) { wb.CloseHidden(); ExcelInterop.ShowOnStartup = true; } return(data); }
/// <summary> /// Read data from a Microsoft Excel spreadsheet. Data is read by row and /// returned in a series of lists by row. Rows and columns are zero-indexed; /// for example, the value in cell A1 will appear in the data list at [0,0]. /// This node requires Microsoft Excel to be installed. /// </summary> /// <param name="file">File representing the Microsoft Excel spreadsheet.</param> /// <param name="sheetName">Name of the worksheet containing the data.</param> /// <returns name="data">Rows of data from the Excel worksheet.</returns> /// <search>office,excel,spreadsheet</search> public static object[][] ReadFromFile(FileInfo file, string sheetName) { WorkBook wb = WorkBook.ReadExcelFile(file.FullName); WorkSheet ws = wb.GetWorksheetByName(sheetName); return(ws.Data); }
/// <summary> /// Read data from a Microsoft Excel spreadsheet. Data is read by row and /// returned in a series of lists by row. Rows and columns are zero-indexed; /// for example, the value in cell A1 will appear in the data list at [0,0]. /// This node requires Microsoft Excel to be installed. /// </summary> /// <param name="filePath">File path to the Microsoft Excel spreadsheet.</param> /// <param name="sheetName">Name of the worksheet containing the data.</param> /// <returns name="data">Rows of data from the Excel worksheet.</returns> /// <search>office,excel,spreadsheet</search> public static object[][] Read(string filePath, string sheetName) { WorkBook wb = WorkBook.ReadExcelFile(filePath); WorkSheet ws = wb.GetWorksheetByName(sheetName); return(ws.Data); }
/// <summary> /// Read data from a Microsoft Excel spreadsheet. Data is read by row and /// returned in a series of lists by row. Rows and columns are zero-indexed; /// for example, the value in cell A1 will appear in the data list at [0,0]. /// This node requires Microsoft Excel to be installed. /// </summary> /// <param name="file">File representing the Microsoft Excel spreadsheet.</param> /// <param name="sheetName">Name of the worksheet containing the data.</param> /// <param name="readAsStrings">toggle to switch between reading Excel file as strings only or not</param> /// <returns name="data">Rows of data from the Excel worksheet.</returns> /// <search>office,excel,spreadsheet,ifequalreturnindex</search> public static object[][] ReadFromFile(FileInfo file, string sheetName, bool readAsStrings = false) { WorkBook wb = WorkBook.ReadExcelFile(file.FullName); WorkSheet ws = wb.GetWorksheetByName(sheetName); if (readAsStrings) { return(ws.GetData(true)); } return(ws.Data); }
public static WorkBook ReadExcelFile(string file) { return(WorkBook.ReadExcelFile(file)); }
public static WorkBook ReadExcelFile(FileInfo file) { return(WorkBook.ReadExcelFile(file.FullName)); }
public static WorkBook ReadExcelFile(string path) { return(WorkBook.ReadExcelFile(path)); }