Exemple #1
0
        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();
        }
Exemple #2
0
        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();
        }
Exemple #3
0
        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();
        }
Exemple #4
0
 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();
 }
Exemple #5
0
 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();
 }
Exemple #6
0
 internal void SaveToXlsx(TOpenXmlWriter DataStream)
 {
     DataStream.WriteStartElement("worksheetSource");
     SaveAttsToXlsx(DataStream);
     DataStream.WriteEndElement();
 }