/// <summary>設定文件表尾</summary> private void SetDocumentFooter(RowTemplateConfig config) { int _num; int _sheetIndex; HSSFSheet _sourceSheet; _num = config.RowIndexStart; _sheetIndex = config.SheetIndex; _sourceSheet = this._workBook.GetSheetAt(_sheetIndex) as HSSFSheet; while (_num <= config.RowIndexEnd) { this.CopyRow(_sourceSheet, _num); _num = _num + 1; this.SetFormula(); } }
/// <summary>設定資料列內容</summary> /// <param name="config">資料列範本設定物件</param> /// <param name="action">執行方法委派</param> private void SetRow(RowTemplateConfig config, Action action) { int _num; int _sheetIndex; HSSFSheet _sourceSheet; _num = config.RowIndexStart; _sheetIndex = config.SheetIndex; _sourceSheet = this._workBook.GetSheetAt(_sheetIndex) as HSSFSheet; while (_num <= config.RowIndexEnd) { this.CopyRow(_sourceSheet, _num); action(); _num = _num + 1; } }