public static void CopyCellStyle(Worksheet worksheet, string column1, int row1, string column2, int row2)
{
var cell1 = CellHelper.GetCell(worksheet, column1, row1);
var cell2 = CellHelper.GetCell(worksheet, column2, row2);
cell2.StyleIndex = cell1.StyleIndex;
}
public static void CopyCellStyle(Worksheet worksheet, string column1, int row1, Cell cell)
{
var cellFrom = CellHelper.GetCell(worksheet, column1, row1);
cell.StyleIndex = cellFrom.StyleIndex;
}
public static void MergeTwoCells(Worksheet worksheet, string cell1Name, string cell2Name)
{
if (worksheet == null || string.IsNullOrEmpty(cell1Name) || string.IsNullOrEmpty(cell2Name))
{
return;
}
// Добавить код на случай объедения более двух ячеек
CellHelper.CreateSpreadsheetCellIfNotExist(worksheet, cell1Name);
CellHelper.CreateSpreadsheetCellIfNotExist(worksheet, cell2Name);
MergeCells mergeCells;
if (worksheet.Elements <MergeCells>().Count() > 0)
{
mergeCells = worksheet.Elements <MergeCells>().First();
}
else
{
mergeCells = new MergeCells();
// Insert a MergeCells object into the specified position.
if (worksheet.Elements <CustomSheetView>().Count() > 0)
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <CustomSheetView>().First());
}
else if (worksheet.Elements <DataConsolidate>().Count() > 0)
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <DataConsolidate>().First());
}
else if (worksheet.Elements <SortState>().Count() > 0)
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <SortState>().First());
}
else if (worksheet.Elements <AutoFilter>().Count() > 0)
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <AutoFilter>().First());
}
else if (worksheet.Elements <Scenarios>().Count() > 0)
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <Scenarios>().First());
}
else if (worksheet.Elements <ProtectedRanges>().Count() > 0)
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <ProtectedRanges>().First());
}
else if (worksheet.Elements <SheetProtection>().Count() > 0)
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <SheetProtection>().First());
}
else if (worksheet.Elements <SheetCalculationProperties>().Count() > 0)
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <SheetCalculationProperties>().First());
}
else
{
worksheet.InsertAfter(mergeCells, worksheet.Elements <SheetData>().First());
}
}
// Create the merged cell and append it to the MergeCells collection.
MergeCell mergeCell = new MergeCell()
{
Reference = new StringValue(cell1Name + ":" + cell2Name)
};
mergeCells.Append(mergeCell);
worksheet.Save();
}