private void ExportOptions(XmlWriter writer) { writer.WriteStartElement("", "WorksheetOptions", "urn:schemas-microsoft-com:office:excel"); PrintOptions.Export(writer); writer.WriteElementString("Selected", ""); if (TabColor != -1) { writer.WriteElementString("TabColor", TabColor.ToString(CultureInfo.InvariantCulture)); } if (FreezeLeftColumns > 0 || FreezeTopRows > 0) { writer.WriteElementString("FreezePanes", ""); writer.WriteElementString("FrozenNoSplit", ""); if (FreezeTopRows > 0) { writer.WriteElementString("SplitHorizontal", FreezeTopRows.ToString(CultureInfo.InvariantCulture)); writer.WriteElementString("TopRowBottomPane", FreezeTopRows.ToString(CultureInfo.InvariantCulture)); } if (FreezeLeftColumns > 0) { writer.WriteElementString("SplitVertical", FreezeLeftColumns.ToString(CultureInfo.InvariantCulture)); writer.WriteElementString("LeftColumnRightPane", FreezeLeftColumns.ToString(CultureInfo.InvariantCulture)); } WritePanes(writer); } writer.WriteEndElement(); }
internal List <string> CellInNamedRanges(Cell cell) { List <string> ranges = new List <string>(); PrintOptions po = cell.ParentRow.ParentSheet.PrintOptions; if (po.PrintTitles) { int cellRowIndex = cell.ParentRow.RowIndex + 1; int cellColIndex = cell.CellIndex + 1; if (cellRowIndex >= po.TopPrintRow && cellRowIndex <= po.BottomPrintRow) { ranges.Add("Print_Titles"); } else { if (cellColIndex >= po.LeftPrintCol && cellColIndex <= po.RightPrintCol) { ranges.Add("Print_Titles"); } } } foreach (NamedRange nr in NamedRanges) { if (nr.Range.Contains(cell)) { ranges.Add(nr.Name); } } return(ranges); }
internal Worksheet(ExcelXmlWorkbook parent) { if (parent == null) { throw new ArgumentNullException("parent"); } ParentBook = parent; PrintOptions = new PrintOptions(); PrintOptions.Layout = PageLayout.None; PrintOptions.Orientation = PageOrientation.None; _Rows = new List <Row>(); _Columns = new List <Column>(); _MergedCells = new List <Range>(); TabColor = -1; PrintOptions.FitHeight = 1; PrintOptions.FitWidth = 1; PrintOptions.Scale = 100; PrintOptions.ResetMargins(); }