/// <summary>
/// Set the size of a specific column in twips
/// </summary>
/// <param name="col">Column to set the width for</param>
/// <param name="width">Width of the column in twips</param>
public void SetColumnWidth(
int col,
double width)
{
if (_configuration.AutoSizeColumns && _colWidths != null && col < _colWidths.Length)
{
_colWidths[col] = C1XLBook.TwipsToPixels(width);
}
else
{
_sheet.Columns[col].Width = (int)width;
}
}
// load sheet into grid
private void LoadSheet(C1FlexGrid flex, XLSheet sheet, bool fixedCells)
{
// account for fixed cells
int frows = flex.Rows.Fixed;
int fcols = flex.Cols.Fixed;
// copy dimensions
flex.Rows.Count = sheet.Rows.Count + frows;
flex.Cols.Count = sheet.Columns.Count + fcols;
// initialize fixed cells
if (fixedCells && frows > 0 && fcols > 0)
{
flex.Styles.Fixed.TextAlign = TextAlignEnum.CenterCenter;
for (int r = 1; r < flex.Rows.Count; r++)
{
flex[r, 0] = r;
}
for (int c = 1; c < flex.Cols.Count; c++)
{
// string hdr = string.Format("{0}", (char)('A' + c - 1));
// flex[0, c] = hdr;
flex[0, c] = c;
}
}
// set default properties
flex.Font = sheet.Book.DefaultFont;
flex.Rows.DefaultSize = C1XLBook.TwipsToPixels(sheet.DefaultRowHeight);
flex.Cols.DefaultSize = C1XLBook.TwipsToPixels(sheet.DefaultColumnWidth);
// prepare to convert styles
_styles = new Hashtable();
// set row/column properties
for (int r = 0; r < sheet.Rows.Count; r++)
{
// size/visibility
Row fr = flex.Rows[r + frows];
XLRow xr = sheet.Rows[r];
if (xr.Height >= 0)
{
fr.Height = C1XLBook.TwipsToPixels(xr.Height);
}
fr.Visible = xr.Visible;
// style
CellStyle cs = StyleFromExcel(flex, xr.Style);
if (cs != null)
{
//cs.DefinedElements &= ~StyleElementFlags.TextAlign; // << need to fix the grid
fr.Style = cs;
}
}
for (int c = 0; c < sheet.Columns.Count; c++)
{
// size/visibility
Column fc = flex.Cols[c + fcols];
XLColumn xc = sheet.Columns[c];
if (xc.Width >= 0)
{
fc.Width = C1XLBook.TwipsToPixels(xc.Width);
}
fc.Visible = xc.Visible;
// style
CellStyle cs = StyleFromExcel(flex, xc.Style);
if (cs != null)
{
//cs.DefinedElements &= ~StyleElementFlags.TextAlign; // << need to fix the grid
fc.Style = cs;
}
}
// load cells
for (int r = 0; r < sheet.Rows.Count; r++)
{
for (int c = 0; c < sheet.Columns.Count; c++)
{
// get cell
XLCell cell = sheet.GetCell(r, c);
if (cell == null)
{
continue;
}
// apply content
flex[r + frows, c + fcols] = cell.Value;
// apply style
CellStyle cs = StyleFromExcel(flex, cell.Style);
if (cs != null)
{
flex.SetCellStyle(r + frows, c + fcols, cs);
}
}
}
}