protected internal ExcelDefinedNames(ExcelWorksheets worksheets, XmlDocument worksheetsXml) { _worksheets = worksheets; _worsheetsXml = worksheetsXml; _definedNames = worksheetsXml.SelectSingleNode("//d:definedNames", _worksheets.NsManager); }
public void Dispose() { if (this.SharedStrings != null) { this.SharedStrings.Clear(); this.SharedStrings = null; } if (this.SharedStringsList != null) { this.SharedStringsList.Clear(); this.SharedStringsList = null; } this._vba = null; if (this._worksheets != null) { this._worksheets.Dispose(); this._worksheets = null; } this.Package = null; this._properties = null; if (this._formulaParser != null) { this._formulaParser.Dispose(); this._formulaParser = null; } }
public void Dispose() { _sharedStrings.Clear(); _sharedStringsList.Clear(); _sharedStrings = null; _sharedStringsList = null; _vba = null; _worksheets.Dispose(); _package = null; _worksheets = null; _properties = null; _formulaParser = null; }
public void Dispose() { _sharedStrings.Clear(); _sharedStringsList.Clear(); _sharedStrings = null; _sharedStringsList = null; _vba = null; if (_worksheets != null) { _worksheets.Dispose(); _worksheets = null; } _package = null; _properties = null; if (_formulaParser != null) { _formulaParser.Dispose(); _formulaParser = null; } }
private void SetDownCount(ExcelWorksheets ews, url_struct result_st) { //get sheet for (int i = 0; i < ews.Count; i++) { int sheet_idx = i + 1; ExcelWorksheet ew = ews[sheet_idx]; //Console.WriteLine(ews[sheet_idx].Name + "==SetDownCount==" + result_st.sheet_name + _after_name); if (ew.Name.Equals(result_st.sheet_name + _after_name)) { //Console.WriteLine("==SetDownCount Equal== " + ews[sheet_idx].Name); int start_row = 0; //得到起始行 start_row = GetDataHead(ew, ew.Name); if (start_row == 0) { return; } //游戏名对照 for (int j = start_row; j < ew.Dimension.Rows; j++) { int now_j = j + 1; if (ew.Cells[now_j, 2].Text.Equals(result_st.game_name)) { int col_offset = 0; for (int m = 0; m < platform_list.Count; m++) { if (result_st.platform.Equals(platform_list[m])) { col_offset = m; } } ew.Cells[now_j, col_offset + 5].Value = result_st.count; //Console.WriteLine("==SetDownCount==" + result_st.game_name + " Platform::" + result_st.platform + " Content::" + result_st.count); return; } } } } }
public void SetUp() { if (File.Exists(Filename)) { File.Delete(Filename); } package = new ExcelPackage(new FileInfo(Filename)); doc = package.Workbook.Worksheets; }
void IDisposable.Dispose() { ((IDisposable)_worksheets).Dispose(); _worksheets = null; }