- VSTO
- Spire.XLS
- Download Sample Code
using NPOI.HSSF.Util;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace NPOI
{
class Program
{
static void Main(string[] args)
{
//Create workbook
IWorkbook workbook = new XSSFWorkbook();
ISheet sheet = workbook.CreateSheet("MySheet");
//Create cell and set its value
ICell cell = sheet.CreateRow(1).CreateCell(3);
cell.SetCellValue("Spire");
//Create style
ICellStyle style = workbook.CreateCellStyle();
//Set border style
style.BorderBottom = BorderStyle.Double;
style.BottomBorderColor = HSSFColor.Yellow.Index;
//Set font style
IFont font = workbook.CreateFont();
font.Color = HSSFColor.Red.Index;
font.FontName = "Arial";
font.FontHeight = 13;
font.IsItalic = true;
style.SetFont(font);
//Set background color
style.FillBackgroundColor = IndexedColors.Black.Index;
style.FillPattern = FillPattern.SolidForeground;
//Apply the style
cell.CellStyle = style;
//Save the file
FileStream file = File.Create("CellStyle.xlsx");
workbook.Write(file);
file.Close();
//Launch the file
System.Diagnostics.Process.Start("CellStyle.xlsx");
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Xls;
using System.Drawing;
namespace Spire.XLS
{
class Program
{
static void Main(string[] args)
{
//Create workbook
Workbook workbook = new Workbook();
Worksheet sheet = workbook.CreateEmptySheet("MySheet");
//Get the cell and set its text
CellRange range = sheet.Range["C3"];
range.Text="Spire";
//Create style
CellStyle style = workbook.Styles.Add("MyStyle");
//Set background color
style.Color = Color.Black;
style.FillPattern = ExcelPatternType.Solid;
//Set border style
style.Borders.Color = Color.Yellow;
style.Borders.LineStyle = LineStyleType.Thin;
style.Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
style.Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
//Set font style
style.Font.FontName = "Arial";
style.Font.IsItalic=true;
style.Font.Color = Color.Red;
style.Font.Size = 13;
//Apply the style
range.CellStyleName = style.Name;
//Save and Launch
workbook.SaveToFile("CellStyle.xlsx", ExcelVersion.Version2013);
System.Diagnostics.Process.Start("CellStyle.xlsx");
}
}
}
