Grid的使用-表格编辑器.doc

using System;using System.Collections.Generic;using System.ComponentModel;using System.Drawing;using System.Data;using System.Linq;using System.Text;using System.Windows.Forms;using System.Drawing.Text;using System.Collections;using FlexCell;namespace Demo public partial class UserControl1 : UserControl /点击按钮之后改变的背景色 Color c1 = Color.FromArgb(194, 224, 255); public UserControl1() InitializeComponent(); private void UserControl1_Load(object sender, EventArgs e) /初始化字体和文字大小默认值 FontFamily fonts = FontFamily.Families; for (int i = 0; i fonts.Length; i+) toolStripComboBox1.Items.Add(fontsi.Name); toolStripComboBox1.SelectedText = 宋体; toolStripComboBox2.SelectedText = 10; / / 新建按钮点击事件 / / / private void toolStripButton1_Click(object sender, EventArgs e) grid1.NewFile(); grid1.DisplayRowNumber = true; grid1.Rows=20; grid1.Cols=10; / / 初始化Grid / / / private void grid1_Load(object sender, EventArgs e) grid1.NewFile(); grid1.DisplayRowNumber = true; grid1.Rows = 25; /grid1.Range(1, 1, grid1.Rows-1, grid1.Cols-1).Font = new Font(宋体, 10); / / 保存按钮事件 / / / private void toolStripButton3_Click(object sender, EventArgs e) if (grid1.ExportToExcel() MessageBox.Show(保存成功!); / / 打开文件事件 / / / private void toolStripButton2_Click(object sender, EventArgs e) string curr = System.IO.Directory.GetCurrentDirectory(); grid1.OpenFile(); / / 单元格剪切 / / / private void toolStripButton6_Click(object sender, EventArgs e) grid1.Selection.CutData(); / / 复制 / / / private void toolStripButton7_Click(object sender, EventArgs e) grid1.Selection.CopyData(); / / 粘贴 / / / private void toolStripButton8_Click(object sender, EventArgs e) grid1.Selection.PasteData(); / / 合并单元格 / / / private void 合并单元格_Click(object sender, EventArgs e) grid1.Selection.Merge(); / / 拆分单元格 / / / private void toolStripButton10_Click(object sender, EventArgs e) grid1.Selection.MergeCells = false; / / 页面大小设置 / / / private void toolStripButton16_Click(object sender, EventArgs e) Message message = new Message(grid1); /message.MdiParent = new Form1(); message.Show(); / / 打印预览 / / / private void toolStripButton5_Click(object sender, EventArgs e) grid1.PrintPreview(); / / 打印 / / / private void toolStripButton4_Click(object sender, EventArgs e) grid1.Print(); / / 获取所选单元格 / / private Cell select_Cell() int col = grid1.Selection.FirstCol; int row = grid1.Selection.FirstRow; return grid1.Cell(row,col); / / 获取点击的单元格的字体格式 / / / bool fBold;/存放字体是否加粗的变量 bool fItalic;/存放字体是否是斜体的变量 float fSize = 0;/存放字体大小 string fName;/存放字体名称 bool fUnder;/存放字体是否有下划线 FontStyle fStyle; private void grid1_Click(object Sender, EventArgs e) Font f = select_Cell().Font; fStyle = f.Style; fName = f.Name; fBold = f.Bold; fItalic = f.Italic; fSize = f.Size; fUnder = f.Underline; toolStripComboBox1.Text = fName; toolStripComboBox2.Text = fSize.ToString(); /Enum.Parse(typeof(FontStyle),fStyle)将一个字符串转换成枚举 if (fBold) toolStripButton13.BackColor = c1; else toolStripButton13.BackColor = Color.FromKnownColor(KnownColor.Control); if (fItalic) toolStripButton14.BackColor = c1; else toolStripButton14.BackColor = Color.FromKnownColor(KnownColor.Control); if (fUnder) toolStripButton15.BackColor = c1; else toolStripButton15.BackColor = Color.FromKnownColor(KnownColor.Control); / / 字体加粗 / / / private void toolStripButton13_Click(object sender, EventArgs e) int c = toolStripButton13.BackColor.ToArgb(); int b =c1.ToArgb(); if (c = b) toolStripButton13.BackColor = Color.FromKnownColor(KnownColor.Control); grid1.Selection.FontBold = false; return; toolStripButton13.BackColor = c1; grid1.Selection.FontBold = true; / / 斜体字 / / / private void toolStripButton14_Click(object sender, EventArgs e) int c = toolStripButton14.BackColor.ToArgb(); if (c = c1.ToArgb() toolStripButton14.BackColor = Color.FromKnownColor(KnownColor.Control); grid1.Selection.FontItalic = false; return; toolStripButton14.BackColor = c1; grid1.Selection.FontItalic = true; / / 下划线 / / / private void toolStripButton15_Click(object sender, EventArgs e) int c = toolStripButton15.BackColor.ToArgb(); if (c = c1.ToArgb() toolStripButton15.BackColor = Color.FromKnownColor(KnownColor.Control); grid1.Selection.FontUnderline = false; return; toolStripButton15.BackColor = c1; grid1.Selection.FontUnderline = true; /if (fStyle = FontStyle.Bold) / / fStyle.ToString().Contains(Bold); / / / 找到单元格 / / private FlexCell.Range selectionRange() int fRow = grid1.Selection.FirstRow; int fCol = grid1.Selection.FirstCol; int lRow = grid1.Selection.LastRow; int lCol = grid1.Selection.LastCol; return grid1.Range(fRow, fCol, lRow, lCol); / / 字体格式改变 / / / private void toolStripComboBox1_SelectedIndexChanged(object sender, EventArgs e) selectionRange().Font = new Font(toolStripComboBox1.Text, fl