public void SetColumnsWidths(double[] colWidths)
{
var colName = "A";
foreach (var width in colWidths)
{
_writer.SetColumnWidth(colName, width);
colName = SpreadsheetReader.GetColumnName(colName, 1);
}
}
public void WriteCellFormatted(string column, int row, string value, SpreadsheetStyle style = null,
int colSpan = 0)
{
WriteCell(column, row, value, style);
if (colSpan > 0)
{
var endCell = SpreadsheetReader.GetColumnName(column, colSpan - 1) + row;
_writer.MergeCells(column + row, endCell);
}
}
public void WriteRow(string column, int row, List <string> values, SpreadsheetStyle style = null)
{
var startCell = column + row;
_writer.PasteValues(startCell, values, CellValues.String);
if (style != null)
{
var endCell = SpreadsheetReader.GetColumnName(column, values.Count - 1) + row;
_writer.SetStyle(style, startCell, endCell);
}
}
public void WriteOptions()
{
var column = "Y";
foreach (var o in _options)
{
_writer.WriteCell(column, 1, o.OptionName, _headerStyle);
foreach (var ov in o.RowValues)
{
_writer.WriteCell(column, ov.RowIndex, ov.Value);
}
column = SpreadsheetReader.GetColumnName(column, 1);
}
}
protected string GetNextColumn(string colname)
{
return(SpreadsheetReader.GetColumnName(colname, 1));
}