public LoadFromText(ExcelRangeBase range, string text, LoadFromTextParams parameters) { _range = range; _worksheet = range.Worksheet; _text = text; if (parameters.Format == null) { _format = new ExcelTextFormat(); } else { _format = parameters.Format; } }
/// <summary> /// Loads a CSV text into a range starting from the top left cell. /// </summary> /// <param name="Text">The Text</param> /// <param name="Format">Information how to load the text</param> /// <returns>The range containing the data</returns> public ExcelRangeBase LoadFromText(string Text, ExcelTextFormat Format) { if (string.IsNullOrEmpty(Text)) { var r = _worksheet.Cells[_fromRow, _fromCol]; r.Value = ""; return(r); } var parameters = new LoadFromTextParams { Format = Format }; var func = new LoadFromText(this, Text, parameters); return(func.Load()); }