Example #1
0
 // AJM GJL 130608 Merge Cells
 void WriteMergeCells(XmlTextWriter xtw, StringCache MC)
 {
     foreach (string mc in MC)
     {
         xtw.WriteStartElement("mergeCell");
         xtw.WriteAttributeString("ref", mc);
         xtw.WriteEndElement();
     }
 }
Example #2
0
        internal ExcelValet()
        {
            _Sheets      = new List <SheetInfo>();
            _Grid        = null;
            _StringCache = new StringCache();
            _BorderCache = new StringCache();
            _FontCache   = new StringCache();
            _FillCache   = new StringCache();
            // work around so that the first 2 fill caches matches what Excel chooses for them
            _FillCache.GetIndex("<fill><patternFill patternType=\"none\"/></fill>");    //index 0
            _FillCache.GetIndex("<fill><patternFill patternType=\"gray125\"/></fill>"); //index 1

            _StyleCache    = new StringCache();
            _StyleXfsCache = new StringCache();
            _DefaultStyle  = new StyleInfo();                   // use this when no style is specified

            GetStyleIndex(_DefaultStyle);                       // populates the default style entries as 0
            ZipWrap.Init();                                     // intialize the zip utility (doesn't hurt to do if already done)
        }