|
private WriteData ( int startRow, int startColumn, object data ) : |
||
| startRow | int | |
| startColumn | int | |
| data | object | |
| return | ||
/// <summary>
/// Write data to a Microsoft Excel spreadsheet. Data is written by row
/// with sublists to be written in successive rows. Rows and columns are
/// zero-indexed; for example, the value in the data list at [0,0] will
/// be written to cell A1. 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 workseet to write data to.</param>
/// <param name="startRow">Start row for writing data. Enter 0 for A, 1 for B, etc.</param>
/// <param name="startCol">
/// Start column for writing data. Enter 0 for col 1, 1 for column 2, ect.
/// </param>
/// <param name="data">Data to write to the spreadsheet.</param>
/// <returns name="data">Data written to the spreadsheet.</returns>
/// <search>office,excel,spreadsheet</search>
public static object[][] WriteToFile(string filePath, string sheetName, int startRow, int startCol, object[][] data)
{
WorkBook wb = new WorkBook(filePath);
WorkSheet ws = new WorkSheet(wb, sheetName);
ws = ws.WriteData(startRow, startCol, data);
return(ws.Data);
}
internal static object[][] WriteData(string filePath, string sheetName, int startRow, int startCol, object[][] data, bool overWrite = false, bool writeAsString = false)
{
WorkBook wb = new WorkBook(filePath);
WorkSheet ws = new WorkSheet(wb, sheetName, overWrite);
ws = ws.WriteData(startRow, startCol, data, writeAsString);
return(ws.Data);
}
public static WorkSheet WriteDataToExcelWorksheet(
WorkSheet worksheet, int startRow = 0, int startColumn = 0, object[][] data = null)
{
if (data == null)
{
return(worksheet);
}
else
{
return(worksheet.WriteData(startRow, startColumn, data));
}
}
/// <summary>
/// Write data to a Microsoft Excel spreadsheet. Data is written by row
/// with sublists to be written in successive rows. Rows and columns are
/// zero-indexed; for example, the value in the data list at [0,0] will
/// be written to cell A1. Null values and empty lists are written to Excel
/// as empty cells. 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 workseet to write data to.</param>
/// <param name="startRow">Start row for writing data. Enter 0 for A, 1 for B, etc.</param>
/// <param name="startCol">
/// Start column for writing data. Enter 0 for col 1, 1 for column 2, ect.
/// </param>
/// <param name="data">Data to write to the spreadsheet.</param>
/// <param name="overWrite"></param>
/// <returns name="data">Data written to the spreadsheet.</returns>
/// <search>office,excel,spreadsheet</search>
public static object[][] WriteToFile(string filePath, string sheetName, int startRow, int startCol, object[][] data, bool overWrite = false)
{
WorkBook wb = new WorkBook(filePath);
WorkSheet ws = new WorkSheet(wb, sheetName, overWrite);
ws = ws.WriteData(startRow, startCol, data);
return ws.Data;
}
public static WorkSheet WriteDataToExcelWorksheet(
WorkSheet worksheet, int startRow = 0, int startColumn = 0, object[][] data = null)
{
if (data == null)
return worksheet;
else
return worksheet.WriteData(startRow, startColumn, data);
}
