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)); }