文章分類／Infragistics
本篇講述如何為您正在使用的每種格式或設置製作一份副本。
// 範例 // 從第一個參數，copy 至第二個參數 private void copy(Worksheet from, Worksheet to) { //表示設定 //GridLine 顯示 to.DisplayOptions.ShowGridlines = from.DisplayOptions.ShowGridlines; //印刷設定 //印刷大小設定 to.PrintOptions.PaperSize = from.PrintOptions.PaperSize; //印刷方向設定 to.PrintOptions.Orientation = from.PrintOptions.Orientation; //四邊留白設定 to.PrintOptions.TopMargin = from.PrintOptions.TopMargin; to.PrintOptions.BottomMargin = from.PrintOptions.BottomMargin; to.PrintOptions.RightMargin = from.PrintOptions.RightMargin; to.PrintOptions.LeftMargin = from.PrintOptions.LeftMargin; to.PrintOptions.HeaderMargin = from.PrintOptions.HeaderMargin; to.PrintOptions.FooterMargin = from.PrintOptions.FooterMargin; / for (int j = 0; j < from.PrintOptions.HorizontalPageBreaks.Count; j++) { to.PrintOptions.HorizontalPageBreaks.Add(to.PrintOptions.HorizontalPageBreaks[j]); } for (int k = 0; k < from.PrintOptions.VerticalPageBreaks.Count; k++) { to.PrintOptions.VerticalPageBreaks.Add(to.PrintOptions.VerticalPageBreaks[k]); } foreach (WorksheetRow row in from.Rows) { // 行高 to.Rows[row.Index].Height = row.Height; foreach (WorksheetCell cell in row.Cells) { // 欄寬 to.Columns[cell.ColumnIndex].Width = from.Columns[cell.ColumnIndex].Width; if (cell.Formula != null) { // 公式 Apply to.Rows[row.Index].Cells[cell.ColumnIndex].ApplyFormula(cell.Formula.ToString()); } else { // copy 值 to.Rows[row.Index].Cells[cell.ColumnIndex].Value = cell.Value; } // 格式 Copy to.Rows[row.Index].Cells[cell.ColumnIndex].CellFormat.SetFormatting(cell.CellFormat); to.Rows[row.Index].Cells[cell.ColumnIndex].CellFormat.TopBorderStyle = cell.GetResolvedCellFormat().TopBorderStyle; to.Rows[row.Index].Cells[cell.ColumnIndex].CellFormat.BottomBorderStyle = cell.GetResolvedCellFormat().BottomBorderStyle; to.Rows[row.Index].Cells[cell.ColumnIndex].CellFormat.LeftBorderStyle = cell.GetResolvedCellFormat().LeftBorderStyle; to.Rows[row.Index].Cells[cell.ColumnIndex].CellFormat.RightBorderStyle = cell.GetResolvedCellFormat().RightBorderStyle; } } //欄位合併 foreach (var m in from.MergedCellsRegions) { to.MergedCellsRegions.Add(m.FirstRow, m.FirstColumn, m.LastRow, m.LastColumn); to.MergedCellsRegions[to.MergedCellsRegions.Count - 1].CellFormat.SetFormatting(m.CellFormat); } }