public void SetAnchoColumna(int indice, DoubleValue ancho)
{
uint Index = (uint)indice;
Columns cs = _workSheet.GetFirstChild <Columns>();
if (cs != null)
{
IEnumerable <Column> ic = cs.Elements <Column>().Where(r => r.Min == Index).Where(r => r.Max == Index);
if (ic.Count() > 0)
{
Column c = ic.First();
c.Width = ancho;
}
else
{
Column c = new Column()
{
Min = Index, Max = Index, Width = ancho, CustomWidth = true
};
cs.Append(c);
}
}
else
{
cs = new Columns();
Column c = new Column()
{
Min = Index, Max = Index, Width = ancho, CustomWidth = true
};
cs.Append(c);
_workSheet.InsertAfter(cs, _workSheet.GetFirstChild <SheetFormatProperties>());
}
}
protected void CrearHoja(string nombreLibro, UInt32 index)
{
WorksheetPart worksheetPart = _libro.AddNewPart <WorksheetPart>();
worksheetPart.Worksheet = new Worksheet(new SheetData());
_hojaCalculo = worksheetPart;
AdicionarHoja(nombreLibro, index);
_workSheet = _hojaCalculo.Worksheet;
_sheetData = _workSheet.GetFirstChild <SheetData>();
}