public XlWorksheet(string name, XlColor tabColor, int position, XlSchema schema)
{
Name = name;
TabColor = tabColor;
Position = position;
Schema = schema;
}
public XlWorksheet AddWorksheet(string name, XlColor tabColor, XlSchema schema)
{
XlWorksheet sheet = new XlWorksheet(name, tabColor, NextSheetNumber, schema);
_worksheets.Add(sheet);
IncrementSheetNumber();
return(sheet);
}
public void ColorArgbToHexTest()
{
Color baseColor = Color.AliceBlue;
Osrs.Oncor.Excel.XlColor testColor = new Osrs.Oncor.Excel.XlColor(baseColor.ToArgb());
string expectedHex = HexValue(baseColor);
string actualHex = testColor.HtmlColor;
Assert.AreEqual(expectedHex, actualHex);
}
public void ColorHexToArgbTest()
{
Color baseColor = Color.AliceBlue;
string hexValue = HexValue(baseColor);
Osrs.Oncor.Excel.XlColor testColor = new Osrs.Oncor.Excel.XlColor(hexValue);
int expectedArgb = baseColor.ToArgb();
int actualArgb = testColor.ArgbColor;
Assert.AreEqual(expectedArgb, actualArgb);
}
private void TempAddTableData(WorksheetPart wsPart, StringValue sheetName, XlSharedStringsTable stringTable)
{
Worksheet worksheet = wsPart.Worksheet;
SheetProperties properties = worksheet.SheetProperties;
XlColor color = new XlColor(properties.TabColor.Rgb);
XlWorksheet ws = Worksheets.AddWorksheet(sheetName, color, null);
List <SheetData> data = new List <SheetData>(worksheet.Elements <SheetData>());
foreach (SheetData sheetData in data)
{
AddTableData(sheetData, ws, stringTable);
}
}
public void WorksheetFirstDefaultNameTest()
{
Color testColor = Color.OldLace;
string expectedName = "Sheet 1";
int expectedTabColor = testColor.ToArgb();
Osrs.Oncor.Excel.XlColor tabColor = new Osrs.Oncor.Excel.XlColor(expectedTabColor);
Osrs.Oncor.Excel.XlWorksheets sheets = new Osrs.Oncor.Excel.XlWorksheets();
Osrs.Oncor.Excel.XlWorksheet sheet = sheets.AddWorksheet(tabColor);
string actualName = sheet.Name;
Assert.AreEqual(expectedName, actualName);
}
public void WorksheetNameAndTabColorTest()
{
Color testColor = Color.OldLace;
string expectedName = "Sheet 1";
int expectedTabColor = testColor.ToArgb();
Osrs.Oncor.Excel.XlColor tabColor = new Osrs.Oncor.Excel.XlColor(expectedTabColor);
Osrs.Oncor.Excel.XlWorksheet sheet = new Osrs.Oncor.Excel.XlWorksheet(expectedName, tabColor, 1, null);
int actualTabColor = sheet.TabColor.ArgbColor;
Assert.AreEqual(expectedTabColor, actualTabColor);
string actualName = sheet.Name;
Assert.AreEqual(expectedName, actualName);
}
private void AddSheetTabColor(XlWorksheet worksheet, SheetProperties properties)
{
XlColor color = new XlColor(properties.TabColor.Rgb);
worksheet.TabColor = color;
}
public XlWorksheet AddWorksheet(XlColor tabColor)
{
return(AddWorksheet(DefaultName, tabColor, null));
}
