private WriteData ( int startRow, int startColumn, object data ) : |
||
startRow | int | |
startColumn | int | |
data | object | |
Результат |
/// <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); }