| private GetData ( bool convertToString = false ) : object[][] | ||
| convertToString | bool | |
| return | object[][] | |
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>
/// <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);
}