你好,
1.我们可以通过 GetIntersectedFilteredInRows() 方法取得过滤行,从而对列头进行操作,实现使标签连续:- private void fpSpread1_AutoFilteredColumn(object sender, FarPoint.Win.Spread.AutoFilteredColumnEventArgs e)
- {
- int[] array = this.fpSpread1_Sheet1.RowFilter.GetIntersectedFilteredInRows();
- //结合 array 重设行头标签,使导出后行号连续
- }
复制代码 2.保存列头可以通过如下方法保存:- this.fpSpread1.SaveExcel(@"E:\test.xls", FarPoint.Excel.ExcelSaveFlags.SaveAsFiltered| FarPoint.Excel.ExcelSaveFlags.SaveBothCustomRowAndColumnHeaders);
复制代码 |