internal void SaveToXlsx(TOpenXmlWriter DataStream, string DocName, bool IsCache) { if (Attributes == null) { return; } DataStream.WriteStartDocument(DocName, true); foreach (TXlsxAttribute att in Attributes) { if (att.Namespace != "http://www.w3.org/2000/xmlns/") { if (att.Name == "cacheId") { DataStream.WriteAtt("cacheId", CacheId); } else { DataStream.WriteAttRaw(att.Namespace, att.Name, att.Value); } } } if (IsCache) { DataStream.WriteAtt("refreshOnLoad", true); DataStream.WriteAtt("upgradeOnRefresh", true); } foreach (TXlsxPivotRecord rec in FRecords) { rec.SaveToXlsx(DataStream); } DataStream.WriteEndDocument(); }
internal override void SaveToXlsx(TOpenXmlWriter DataStream) { DataStream.WriteStartElement("location"); DataStream.WriteAttAsRange("ref", Refe, true); DataStream.WriteAtt("firstHeaderRow", firstHeaderRow); DataStream.WriteAtt("firstDataRow", firstDataRow); DataStream.WriteAtt("firstDataCol", firstDataCol); DataStream.WriteAtt("rowPageCount", rowPageCount, 0); DataStream.WriteAtt("colPageCount", colPageCount, 0); DataStream.WriteEndElement(); }
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904) { if (ErrFlag == 0) { DataStream.WriteAtt("t", "b"); DataStream.WriteElement("v", BoolErr == 1); } else { DataStream.WriteAtt("t", "e"); DataStream.WriteElement("v", TFormulaMessages.ErrString(ErrCodeToFlxFormulaErrorValue(BoolErr))); } }
internal override void SaveToXlsx(TOpenXmlWriter DataStream) { DataStream.WriteStartElement("cacheSource"); DataStream.WriteAtt("type", SourceType); if (ConnectionId > 0) { DataStream.WriteAtt("connectionId", ConnectionId, 0); } if (WorksheetSource != null) { WorksheetSource.SaveToXlsx(DataStream); } if (Consolidation != null) { Consolidation.SaveToXlsx(DataStream); } DataStream.WriteFutureStorage(FutureStorage); DataStream.WriteEndElement(); }
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904) { TxBaseRecord MySelf = new TxBaseRecord(Id, Data); int MyOfs = 6; TExcelString XS = new TExcelString(TStrLenLength.is16bits, ref MySelf, ref MyOfs); DataStream.WriteAtt("t", "inlineStr"); DataStream.WriteStartElement("is"); DataStream.WriteRichText(XS, CellList.Workbook); DataStream.WriteEndElement(); }
internal void SaveToXlsx(TOpenXmlWriter DataStream) { DataStream.WriteStartElement("consolidation"); DataStream.WriteAtt("autoPage", AutoPage); if (!String.IsNullOrEmpty(Pages)) { DataStream.WriteRaw(Pages); } if (RangeSets.Count > 0) { DataStream.WriteStartElement("rangeSets"); DataStream.WriteAtt("count", RangeSets.Count); foreach (TRangeSet r in RangeSets) { r.SaveToXlsx(DataStream); } DataStream.WriteEndElement(); } DataStream.WriteEndElement(); }
internal void SaveToXlsx(TOpenXmlWriter DataStream) { DataStream.WriteStartElement("rangeSet"); for (int i = 0; i < ix.Length; i++) { if (ix[i] >= 0) { DataStream.WriteAtt("i" + (i + 1).ToString(CultureInfo.InvariantCulture), ix[i]); } } if (Source != null) { Source.SaveAttsToXlsx(DataStream); } DataStream.WriteEndElement(); }
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904) { DataStream.WriteAtt("t", "s"); DataStream.WriteElement("v", PosInTable); }
internal void SaveAttsToXlsx(TOpenXmlWriter DataStream) { DataStream.WriteAttAsRange("ref", Refe, true); DataStream.WriteAtt("name", Name); DataStream.WriteAtt("sheet", Sheet); }