void Load() { fast_zip = new FastZip(); xml_shared_strings = new XmlFun(); xml_sheets = new List<XmlFun>(); xml_workbook = new XmlFun(); xml_wb_rels = new XmlFun(); shared_strings = new Dictionary<int, string>(); Worksheets = new List<Worksheet>(); }
private void SaveSharedStrings() { string inner_xml_header = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>"+ "<sst xmlns=\"http://schemas.openxmlformats.org/spreadsheetml/2006/main\" count=\"100000\" uniqueCount=\"99000\">"; string inner_xml_footer = "</sst>"; string strgs = String.Empty; foreach ( KeyValuePair<int,string> sh_str in shared_strings ) { strgs += "<si><t>"+sh_str.Value+"</t></si>"; } if ( xml_shared_strings == null ) xml_shared_strings = new AmusingXml.XmlFun(); xml_shared_strings.Document.InnerXml = inner_xml_header + strgs + inner_xml_footer; xml_shared_strings.SaveDocument(temp_path+"\\xl\\sharedStrings.xml"); }
private void CloseDC() { try { Worksheets.Clear(); xml_sheets.Clear(); shared_strings.Clear(); xml_workbook = null; xml_wb_rels = null; xml_shared_strings = null; GC.Collect(); GC.WaitForPendingFinalizers(); } catch ( Exception ex ) { throw new FastXcelException( "Error closing a document", ex ); } }