public partial class frmSheetHelperTest : Form
{
Xls.Application xlsApp;
Xls.Workbook book;
public frmSheetHelperTest()
{
InitializeComponent();
this.txtFilePath.ReadOnly = true;
this.btn打开.Enabled = false;
this.btnLoad.Enabled = false;
this.btnUnload.Enabled = false;
this.tabControl1.Enabled = false;
this.FormClosing += frmSheetHelperTest_FormClosing;
this.num起始行.Minimum = 0;
this.num起始列.Minimum = 0;
this.num起始行.Maximum = (decimal)Math.Pow(2, 20) - 1; // office2007 最大行号是2的20次方
this.num起始列.Maximum = (decimal)Math.Pow(2, 14) - 1; // office2007 最大列号是2的14次方
#region 行列操作_控件初始化
this.num行列号.Minimum = 1;
this.num行列号.Maximum = (decimal)Math.Pow(2, 20);
this.num行列号CopyTo.Minimum = 1;
this.num行列号CopyTo.Maximum = (decimal)Math.Pow(2, 20);
#endregion
#region 单元格操作_控件初始化
this.txt单元格填充填充_文本内容.Text = "Excel单元格文本内容填充示例";
this.num单元格填充_行号.Minimum = 1;
this.num单元格填充_列号.Minimum = 1;
this.num单元格填充_行号.Maximum = (decimal)Math.Pow(2, 20); // office2007 最大行号是2的20次方
this.num单元格填充_列号.Maximum = (decimal)Math.Pow(2, 14); // office2007 最大列号是2的14次方
#endregion
#region 样式设置_控件初始化
this.cbb边框样式.DataSource = Enum.GetNames(typeof(Xls.XlLineStyle));
List<string> bordersIndexList = new List<string>();
bordersIndexList.Add(string.Empty);
bordersIndexList.AddRange(Enum.GetNames(typeof(Xls.XlBordersIndex)));
this.cbbBordersIndex.DataSource = bordersIndexList;
this.cbbHAlign.DataSource = Enum.GetNames(typeof(Xls.XlHAlign));
this.cbbVAlign.DataSource = Enum.GetNames(typeof(Xls.XlVAlign));
#endregion
}
void frmSheetHelperTest_FormClosing(object sender, FormClosingEventArgs e)
{
if (xlsApp != null)
{
xlsApp.Workbooks.Close();
xlsApp.Quit();
}
}
private void btn浏览_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog dg = new OpenFileDialog();
dg.Filter = "Excel文件|*.xls;*.xlsx|所有文件|*.*";
dg.Multiselect = false;
if (dg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.txtFilePath.Text = dg.FileName;
this.btn打开.Enabled = true;
this.btnLoad.Enabled = true;
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn打开_Click(object sender, EventArgs e)
{
try
{
if (this.txtFilePath.Text.Length > 0)
{
System.Diagnostics.Process.Start(this.txtFilePath.Text);
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
cbbSheets.Items.Clear();
tabControl1.Enabled = false;
string path = this.txtFilePath.Text;
if (File.Exists(path))
{
if (xlsApp == null)
{
xlsApp = new Xls.Application();
}
try
{
book = xlsApp.Workbooks.Open(path);
}
catch (Exception ex)
{
Alert(ex.Message);
xlsApp.Workbooks.Close();
xlsApp.Quit();
return;
}
for (int i = 1; i <= book.Sheets.Count; i++)
{
Xls.Worksheet sheet = book.Worksheets[i];
cbbSheets.Items.Add(sheet.Name);
}
if (cbbSheets.Items.Count > 0)
{
cbbSheets.SelectedIndex = 0;
tabControl1.Enabled = true;
}
this.btnUnload.Enabled = true;
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnUnload_Click(object sender, EventArgs e)
{
try
{
if (xlsApp != null)
{
xlsApp.Workbooks.Close();
xlsApp.Quit();
}
cbbSheets.Items.Clear();
tabControl1.Enabled = false;
this.btnUnload.Enabled = false;
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void Alert(string msg)
{
MessageBox.Show(msg);
}
private SheetHelper GetSheetHelper()
{
SheetHelper st = new SheetHelper(book.Worksheets[cbbSheets.SelectedIndex + 1],
(int)this.num起始行.Value, (int)this.num起始列.Value);
return st;
}
#region 行列操作
private void btn拷贝行_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.CopyRow((int)this.num行列号.Value, (int)this.num行列号CopyTo.Value);
book.Save();
Alert("拷贝行完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn拷贝列_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.CopyCol((int)this.num行列号.Value, (int)this.num行列号CopyTo.Value);
book.Save();
Alert("拷贝列完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn删除行_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.DeleteRow((int)this.num行列号.Value, (int)this.num删除插入数量.Value);
book.Save();
Alert("删除行完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn删除列_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.DeleteCol((int)this.num行列号.Value, (int)this.num删除插入数量.Value);
book.Save();
Alert("删除列完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn插入行_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.InsertRow((int)this.num行列号.Value, (int)this.num删除插入数量.Value, ckb插入拷贝.Checked);
book.Save();
Alert("插入行完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn插入列_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.InsertCol((int)this.num行列号.Value, (int)this.num删除插入数量.Value, ckb插入拷贝.Checked);
book.Save();
Alert("插入列完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn设置行高_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.SetRowHeight((int)this.num行列号.Value, (int)this.num高宽.Value);
book.Save();
Alert("设置行高完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn设置列宽_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.SetColWidth((int)this.num行列号.Value, (int)this.num高宽.Value);
book.Save();
Alert("设置列宽完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn自适应行高_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.AutoFitRow((int)this.num行列号.Value);
book.Save();
Alert("自适应行高完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn自适应列宽_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.AutoFitCol((int)this.num行列号.Value);
book.Save();
Alert("自适应列宽完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
#endregion
#region 单元格操作
private void btn单元格填充_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.SetValue((int)this.num单元格填充_行号.Value, (int)this.num单元格填充_列号.Value,
this.txt单元格填充填充_文本内容.Text);
book.Save();
Alert("单元格填充完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn单元格合并_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.Marge((int)this.num单元格合并_行1.Value, (int)this.num单元格合并_列1.Value,
(int)this.num单元格合并_行2.Value, (int)this.num单元格合并_列2.Value);
book.Save();
Alert("单元格合并完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btn单元格合并_解除_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
st.UnMarge((int)this.num单元格合并_行1.Value, (int)this.num单元格合并_列1.Value,
(int)this.num单元格合并_行2.Value, (int)this.num单元格合并_列2.Value);
book.Save();
Alert("单元格合并解除完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
#endregion
#region 样式设置
private void pnlColor_Click(object sender, EventArgs e)
{
try
{
this.colorDialog1.Color = pnlColor.BackColor;
if (this.colorDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
pnlColor.BackColor = this.colorDialog1.Color;
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private Xls.Range GetRangeToSetStyle(SheetHelper st)
{
Xls.Range rg = st.GetRange((int)num样式设置_行1.Value, (int)num样式设置_列1.Value, (int)num样式设置_行2.Value, (int)num样式设置_列2.Value);
return rg;
}
private void btn边框设置_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
Xls.Range rg = GetRangeToSetStyle(st);
Xls.XlLineStyle lineStyle;
if (Enum.TryParse<Xls.XlLineStyle>(cbb边框样式.Text, out lineStyle))
{
if (string.IsNullOrEmpty(cbbBordersIndex.Text))
{
st.SetBorders(rg, pnlColor.BackColor, lineStyle, num边框粗细.Value);
}
else
{
Xls.XlBordersIndex bordersIndex;
if (Enum.TryParse<Xls.XlBordersIndex>(cbbBordersIndex.Text, out bordersIndex))
{
st.SetBorders(rg, pnlColor.BackColor, lineStyle, num边框粗细.Value, bordersIndex);
}
}
book.Save();
Alert("边框设置完毕。");
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnSetBordersToInside_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
Xls.Range rg = GetRangeToSetStyle(st);
Xls.XlLineStyle lineStyle;
if (Enum.TryParse<Xls.XlLineStyle>(cbb边框样式.Text, out lineStyle))
{
st.SetBordersToInside(rg, pnlColor.BackColor, lineStyle, num边框粗细.Value);
book.Save();
Alert("边框设置完毕。");
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnSetBordersToOutside_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
Xls.Range rg = GetRangeToSetStyle(st);
Xls.XlLineStyle lineStyle;
if (Enum.TryParse<Xls.XlLineStyle>(cbb边框样式.Text, out lineStyle))
{
st.SetBordersToOutside(rg, pnlColor.BackColor, lineStyle, num边框粗细.Value);
book.Save();
Alert("边框设置完毕。");
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnSetBordersToDiagonal_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
Xls.Range rg = GetRangeToSetStyle(st);
Xls.XlLineStyle lineStyle;
if (Enum.TryParse<Xls.XlLineStyle>(cbb边框样式.Text, out lineStyle))
{
st.SetBordersToDiagonal(rg, pnlColor.BackColor, lineStyle, num边框粗细.Value);
book.Save();
Alert("边框设置完毕。");
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void lnk选择Font_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
try
{
fontDialog1.Font = lnk选择Font.Font;
if (fontDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
lnk选择Font.Font = fontDialog1.Font;
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnSetFont_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
Xls.Range rg = GetRangeToSetStyle(st);
st.SetFont(rg, lnk选择Font.Font.Size, lnk选择Font.Font.Bold, lnk选择Font.Font.Underline, pnlColor.BackColor);
book.Save();
Alert("字体样式设置完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnSetHAlign_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
Xls.Range rg = GetRangeToSetStyle(st);
Xls.XlHAlign hAlign;
if (Enum.TryParse<Xls.XlHAlign>(this.cbbHAlign.Text, out hAlign))
{
st.SetHAlign(rg, hAlign);
book.Save();
Alert("水平对齐方式设置完毕。");
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnSetVAlign_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
Xls.Range rg = GetRangeToSetStyle(st);
Xls.XlVAlign vAlign;
if (Enum.TryParse<Xls.XlVAlign>(this.cbbVAlign.Text, out vAlign))
{
st.SetVAlign(rg, vAlign);
book.Save();
Alert("垂直对齐方式设置完毕。");
}
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
private void btnWrapText_Click(object sender, EventArgs e)
{
try
{
SheetHelper st = GetSheetHelper();
Xls.Range rg = GetRangeToSetStyle(st);
st.SetWrapText(rg, ckbWrapText.Checked);
book.Save();
Alert("自动换行设置完毕。");
}
catch (Exception ex)
{
Alert(ex.Message);
}
}
#endregion
}
// [Designer]
partial class frmSheetHelperTest
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.txtFilePath = new System.Windows.Forms.TextBox();
this.btn打开 = new System.Windows.Forms.Button();
this.label1 = new System.Windows.Forms.Label();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.ckb插入拷贝 = new System.Windows.Forms.CheckBox();
this.btn自适应列宽 = new System.Windows.Forms.Button();
this.btn设置列宽 = new System.Windows.Forms.Button();
this.btn拷贝列 = new System.Windows.Forms.Button();
this.btn删除列 = new System.Windows.Forms.Button();
this.btn插入列 = new System.Windows.Forms.Button();
this.btn拷贝行 = new System.Windows.Forms.Button();
this.btn删除行 = new System.Windows.Forms.Button();
this.btn自适应行高 = new System.Windows.Forms.Button();
this.btn设置行高 = new System.Windows.Forms.Button();
this.btn插入行 = new System.Windows.Forms.Button();
this.num高宽 = new System.Windows.Forms.NumericUpDown();
this.label8 = new System.Windows.Forms.Label();
this.num删除插入数量 = new System.Windows.Forms.NumericUpDown();
this.label10 = new System.Windows.Forms.Label();
this.num行列号CopyTo = new System.Windows.Forms.NumericUpDown();
this.label13 = new System.Windows.Forms.Label();
this.num行列号 = new System.Windows.Forms.NumericUpDown();
this.label9 = new System.Windows.Forms.Label();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.btn单元格合并_解除 = new System.Windows.Forms.Button();
this.btn单元格合并 = new System.Windows.Forms.Button();
this.num单元格合并_列2 = new System.Windows.Forms.NumericUpDown();
this.num单元格合并_列1 = new System.Windows.Forms.NumericUpDown();
this.num单元格合并_行2 = new System.Windows.Forms.NumericUpDown();
this.label7 = new System.Windows.Forms.Label();
this.num单元格合并_行1 = new System.Windows.Forms.NumericUpDown();
this.label6 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.btn单元格填充 = new System.Windows.Forms.Button();
this.num单元格填充_列号 = new System.Windows.Forms.NumericUpDown();
this.num单元格填充_行号 = new System.Windows.Forms.NumericUpDown();
this.label3 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.txt单元格填充填充_文本内容 = new System.Windows.Forms.TextBox();
this.tabPage3 = new System.Windows.Forms.TabPage();
this.pnlColor = new System.Windows.Forms.Panel();
this.btn边框设置 = new System.Windows.Forms.Button();
this.label19 = new System.Windows.Forms.Label();
this.label18 = new System.Windows.Forms.Label();
this.cbb边框样式 = new System.Windows.Forms.ComboBox();
this.num样式设置_列2 = new System.Windows.Forms.NumericUpDown();
this.num边框粗细 = new System.Windows.Forms.NumericUpDown();
this.num样式设置_列1 = new System.Windows.Forms.NumericUpDown();
this.num样式设置_行2 = new System.Windows.Forms.NumericUpDown();
this.label14 = new System.Windows.Forms.Label();
this.num样式设置_行1 = new System.Windows.Forms.NumericUpDown();
this.label15 = new System.Windows.Forms.Label();
this.label16 = new System.Windows.Forms.Label();
this.label17 = new System.Windows.Forms.Label();
this.btnLoad = new System.Windows.Forms.Button();
this.cbbSheets = new System.Windows.Forms.ComboBox();
this.btnUnload = new System.Windows.Forms.Button();
this.btn浏览 = new System.Windows.Forms.Button();
this.label11 = new System.Windows.Forms.Label();
this.label12 = new System.Windows.Forms.Label();
this.num起始行 = new System.Windows.Forms.NumericUpDown();
this.num起始列 = new System.Windows.Forms.NumericUpDown();
this.colorDialog1 = new System.Windows.Forms.ColorDialog();
this.cbbBordersIndex = new System.Windows.Forms.ComboBox();
this.label20 = new System.Windows.Forms.Label();
this.btnSetBordersToInside = new System.Windows.Forms.Button();
this.btnSetBordersToOutside = new System.Windows.Forms.Button();
this.btnSetBordersToDiagonal = new System.Windows.Forms.Button();
this.fontDialog1 = new System.Windows.Forms.FontDialog();
this.lnk选择Font = new System.Windows.Forms.LinkLabel();
this.btnSetFont = new System.Windows.Forms.Button();
this.btnSetHAlign = new System.Windows.Forms.Button();
this.btnSetVAlign = new System.Windows.Forms.Button();
this.cbbHAlign = new System.Windows.Forms.ComboBox();
this.label21 = new System.Windows.Forms.Label();
this.cbbVAlign = new System.Windows.Forms.ComboBox();
this.label22 = new System.Windows.Forms.Label();
this.btnWrapText = new System.Windows.Forms.Button();
this.ckbWrapText = new System.Windows.Forms.CheckBox();
this.tabControl1.SuspendLayout();
this.tabPage2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.num高宽)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num删除插入数量)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num行列号CopyTo)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num行列号)).BeginInit();
this.tabPage1.SuspendLayout();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.num单元格合并_列2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num单元格合并_列1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num单元格合并_行2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num单元格合并_行1)).BeginInit();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.num单元格填充_列号)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num单元格填充_行号)).BeginInit();
this.tabPage3.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.num样式设置_列2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num边框粗细)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num样式设置_列1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num样式设置_行2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num样式设置_行1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num起始行)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.num起始列)).BeginInit();
this.SuspendLayout();
//
// txtFilePath
//
this.txtFilePath.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.txtFilePath.Location = new System.Drawing.Point(13, 4);
this.txtFilePath.Name = "txtFilePath";
this.txtFilePath.Size = new System.Drawing.Size(370, 21);
this.txtFilePath.TabIndex = 0;
//
// btn打开
//
this.btn打开.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn打开.Location = new System.Drawing.Point(470, 4);
this.btn打开.Name = "btn打开";
this.btn打开.Size = new System.Drawing.Size(75, 23);
this.btn打开.TabIndex = 1;
this.btn打开.Text = "打开...";
this.btn打开.UseVisualStyleBackColor = true;
this.btn打开.Click += new System.EventHandler(this.btn打开_Click);
//
// label1
//
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(14, 36);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(47, 12);
this.label1.TabIndex = 3;
this.label1.Text = "Sheets:";
//
// tabControl1
//
this.tabControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Controls.Add(this.tabPage3);
this.tabControl1.Location = new System.Drawing.Point(12, 85);
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(533, 307);
this.tabControl1.TabIndex = 5;
//
// tabPage2
//
this.tabPage2.Controls.Add(this.ckb插入拷贝);
this.tabPage2.Controls.Add(this.btn自适应列宽);
this.tabPage2.Controls.Add(this.btn设置列宽);
this.tabPage2.Controls.Add(this.btn拷贝列);
this.tabPage2.Controls.Add(this.btn删除列);
this.tabPage2.Controls.Add(this.btn插入列);
this.tabPage2.Controls.Add(this.btn拷贝行);
this.tabPage2.Controls.Add(this.btn删除行);
this.tabPage2.Controls.Add(this.btn自适应行高);
this.tabPage2.Controls.Add(this.btn设置行高);
this.tabPage2.Controls.Add(this.btn插入行);
this.tabPage2.Controls.Add(this.num高宽);
this.tabPage2.Controls.Add(this.label8);
this.tabPage2.Controls.Add(this.num删除插入数量);
this.tabPage2.Controls.Add(this.label10);
this.tabPage2.Controls.Add(this.num行列号CopyTo);
this.tabPage2.Controls.Add(this.label13);
this.tabPage2.Controls.Add(this.num行列号);
this.tabPage2.Controls.Add(this.label9);
this.tabPage2.Location = new System.Drawing.Point(4, 22);
this.tabPage2.Name = "tabPage2";
this.tabPage2.Padding = new System.Windows.Forms.Padding(3);
this.tabPage2.Size = new System.Drawing.Size(525, 281);
this.tabPage2.TabIndex = 1;
this.tabPage2.Text = "行列操作";
this.tabPage2.UseVisualStyleBackColor = true;
//
// ckb插入拷贝
//
this.ckb插入拷贝.AutoSize = true;
this.ckb插入拷贝.Location = new System.Drawing.Point(215, 75);
this.ckb插入拷贝.Name = "ckb插入拷贝";
this.ckb插入拷贝.Size = new System.Drawing.Size(48, 16);
this.ckb插入拷贝.TabIndex = 4;
this.ckb插入拷贝.Text = "拷贝";
this.ckb插入拷贝.UseVisualStyleBackColor = true;
//
// btn自适应列宽
//
this.btn自适应列宽.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn自适应列宽.Location = new System.Drawing.Point(436, 135);
this.btn自适应列宽.Name = "btn自适应列宽";
this.btn自适应列宽.Size = new System.Drawing.Size(75, 23);
this.btn自适应列宽.TabIndex = 3;
this.btn自适应列宽.Text = "自适应列宽";
this.btn自适应列宽.UseVisualStyleBackColor = true;
this.btn自适应列宽.Click += new System.EventHandler(this.btn自适应列宽_Click);
//
// btn设置列宽
//
this.btn设置列宽.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn设置列宽.Location = new System.Drawing.Point(436, 106);
this.btn设置列宽.Name = "btn设置列宽";
this.btn设置列宽.Size = new System.Drawing.Size(75, 23);
this.btn设置列宽.TabIndex = 3;
this.btn设置列宽.Text = "设置列宽";
this.btn设置列宽.UseVisualStyleBackColor = true;
this.btn设置列宽.Click += new System.EventHandler(this.btn设置列宽_Click);
//
// btn拷贝列
//
this.btn拷贝列.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn拷贝列.Location = new System.Drawing.Point(436, 14);
this.btn拷贝列.Name = "btn拷贝列";
this.btn拷贝列.Size = new System.Drawing.Size(75, 23);
this.btn拷贝列.TabIndex = 3;
this.btn拷贝列.Text = "拷贝列";
this.btn拷贝列.UseVisualStyleBackColor = true;
this.btn拷贝列.Click += new System.EventHandler(this.btn拷贝列_Click);
//
// btn删除列
//
this.btn删除列.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn删除列.Location = new System.Drawing.Point(436, 43);
this.btn删除列.Name = "btn删除列";
this.btn删除列.Size = new System.Drawing.Size(75, 23);
this.btn删除列.TabIndex = 3;
this.btn删除列.Text = "删除列";
this.btn删除列.UseVisualStyleBackColor = true;
this.btn删除列.Click += new System.EventHandler(this.btn删除列_Click);
//
// btn插入列
//
this.btn插入列.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn插入列.Location = new System.Drawing.Point(436, 75);
this.btn插入列.Name = "btn插入列";
this.btn插入列.Size = new System.Drawing.Size(75, 23);
this.btn插入列.TabIndex = 3;
this.btn插入列.Text = "插入列";
this.btn插入列.UseVisualStyleBackColor = true;
this.btn插入列.Click += new System.EventHandler(this.btn插入列_Click);
//
// btn拷贝行
//
this.btn拷贝行.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn拷贝行.Location = new System.Drawing.Point(355, 14);
this.btn拷贝行.Name = "btn拷贝行";
this.btn拷贝行.Size = new System.Drawing.Size(75, 23);
this.btn拷贝行.TabIndex = 3;
this.btn拷贝行.Text = "拷贝行";
this.btn拷贝行.UseVisualStyleBackColor = true;
this.btn拷贝行.Click += new System.EventHandler(this.btn拷贝行_Click);
//
// btn删除行
//
this.btn删除行.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn删除行.Location = new System.Drawing.Point(355, 43);
this.btn删除行.Name = "btn删除行";
this.btn删除行.Size = new System.Drawing.Size(75, 23);
this.btn删除行.TabIndex = 3;
this.btn删除行.Text = "删除行";
this.btn删除行.UseVisualStyleBackColor = true;
this.btn删除行.Click += new System.EventHandler(this.btn删除行_Click);
//
// btn自适应行高
//
this.btn自适应行高.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn自适应行高.Location = new System.Drawing.Point(355, 135);
this.btn自适应行高.Name = "btn自适应行高";
this.btn自适应行高.Size = new System.Drawing.Size(75, 23);
this.btn自适应行高.TabIndex = 3;
this.btn自适应行高.Text = "自适应行高";
this.btn自适应行高.UseVisualStyleBackColor = true;
this.btn自适应行高.Click += new System.EventHandler(this.btn自适应行高_Click);
//
// btn设置行高
//
this.btn设置行高.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn设置行高.Location = new System.Drawing.Point(355, 106);
this.btn设置行高.Name = "btn设置行高";
this.btn设置行高.Size = new System.Drawing.Size(75, 23);
this.btn设置行高.TabIndex = 3;
this.btn设置行高.Text = "设置行高";
this.btn设置行高.UseVisualStyleBackColor = true;
this.btn设置行高.Click += new System.EventHandler(this.btn设置行高_Click);
//
// btn插入行
//
this.btn插入行.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn插入行.Location = new System.Drawing.Point(355, 75);
this.btn插入行.Name = "btn插入行";
this.btn插入行.Size = new System.Drawing.Size(75, 23);
this.btn插入行.TabIndex = 3;
this.btn插入行.Text = "插入行";
this.btn插入行.UseVisualStyleBackColor = true;
this.btn插入行.Click += new System.EventHandler(this.btn插入行_Click);
//
// num高宽
//
this.num高宽.Location = new System.Drawing.Point(215, 106);
this.num高宽.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num高宽.Name = "num高宽";
this.num高宽.Size = new System.Drawing.Size(69, 21);
this.num高宽.TabIndex = 2;
this.num高宽.Value = new decimal(new int[] {
20,
0,
0,
0});
//
// label8
//
this.label8.AutoSize = true;
this.label8.Location = new System.Drawing.Point(168, 108);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(41, 12);
this.label8.TabIndex = 1;
this.label8.Text = "高/宽:";
//
// num删除插入数量
//
this.num删除插入数量.Location = new System.Drawing.Point(215, 43);
this.num删除插入数量.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num删除插入数量.Name = "num删除插入数量";
this.num删除插入数量.Size = new System.Drawing.Size(69, 21);
this.num删除插入数量.TabIndex = 2;
this.num删除插入数量.Value = new decimal(new int[] {
1,
0,
0,
0});
//
// label10
//
this.label10.AutoSize = true;
this.label10.Location = new System.Drawing.Point(121, 48);
this.label10.Name = "label10";
this.label10.Size = new System.Drawing.Size(89, 12);
this.label10.TabIndex = 1;
this.label10.Text = "删除/插入数量:";
//
// num行列号CopyTo
//
this.num行列号CopyTo.Location = new System.Drawing.Point(216, 16);
this.num行列号CopyTo.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num行列号CopyTo.Name = "num行列号CopyTo";
this.num行列号CopyTo.Size = new System.Drawing.Size(68, 21);
this.num行列号CopyTo.TabIndex = 2;
this.num行列号CopyTo.Value = new decimal(new int[] {
2,
0,
0,
0});
//
// label13
//
this.label13.AutoSize = true;
this.label13.Location = new System.Drawing.Point(145, 18);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(65, 12);
this.label13.TabIndex = 1;
this.label13.Text = "目标行/列:";
//
// num行列号
//
this.num行列号.Location = new System.Drawing.Point(62, 16);
this.num行列号.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num行列号.Name = "num行列号";
this.num行列号.Size = new System.Drawing.Size(68, 21);
this.num行列号.TabIndex = 2;
this.num行列号.Value = new decimal(new int[] {
1,
0,
0,
0});
//
// label9
//
this.label9.AutoSize = true;
this.label9.Location = new System.Drawing.Point(15, 18);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(41, 12);
this.label9.TabIndex = 1;
this.label9.Text = "行/列:";
//
// tabPage1
//
this.tabPage1.Controls.Add(this.groupBox2);
this.tabPage1.Controls.Add(this.groupBox1);
this.tabPage1.Location = new System.Drawing.Point(4, 22);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(525, 281);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "单元格操作";
this.tabPage1.UseVisualStyleBackColor = true;
//
// groupBox2
//
this.groupBox2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.groupBox2.Controls.Add(this.btn单元格合并_解除);
this.groupBox2.Controls.Add(this.btn单元格合并);
this.groupBox2.Controls.Add(this.num单元格合并_列2);
this.groupBox2.Controls.Add(this.num单元格合并_列1);
this.groupBox2.Controls.Add(this.num单元格合并_行2);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.num单元格合并_行1);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Location = new System.Drawing.Point(6, 94);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(513, 82);
this.groupBox2.TabIndex = 1;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "单元格合并";
//
// btn单元格合并_解除
//
this.btn单元格合并_解除.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn单元格合并_解除.Location = new System.Drawing.Point(432, 44);
this.btn单元格合并_解除.Name = "btn单元格合并_解除";
this.btn单元格合并_解除.Size = new System.Drawing.Size(75, 23);
this.btn单元格合并_解除.TabIndex = 3;
this.btn单元格合并_解除.Text = "解除合并";
this.btn单元格合并_解除.UseVisualStyleBackColor = true;
this.btn单元格合并_解除.Click += new System.EventHandler(this.btn单元格合并_解除_Click);
//
// btn单元格合并
//
this.btn单元格合并.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn单元格合并.Location = new System.Drawing.Point(432, 19);
this.btn单元格合并.Name = "btn单元格合并";
this.btn单元格合并.Size = new System.Drawing.Size(75, 23);
this.btn单元格合并.TabIndex = 3;
this.btn单元格合并.Text = "合 并";
this.btn单元格合并.UseVisualStyleBackColor = true;
this.btn单元格合并.Click += new System.EventHandler(this.btn单元格合并_Click);
//
// num单元格合并_列2
//
this.num单元格合并_列2.Location = new System.Drawing.Point(191, 47);
this.num单元格合并_列2.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num单元格合并_列2.Name = "num单元格合并_列2";
this.num单元格合并_列2.Size = new System.Drawing.Size(94, 21);
this.num单元格合并_列2.TabIndex = 2;
this.num单元格合并_列2.Value = new decimal(new int[] {
2,
0,
0,
0});
//
// num单元格合并_列1
//
this.num单元格合并_列1.Location = new System.Drawing.Point(191, 20);
this.num单元格合并_列1.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num单元格合并_列1.Name = "num单元格合并_列1";
this.num单元格合并_列1.Size = new System.Drawing.Size(94, 21);
this.num单元格合并_列1.TabIndex = 2;
this.num单元格合并_列1.Value = new decimal(new int[] {
1,
0,
0,
0});
//
// num单元格合并_行2
//
this.num单元格合并_行2.Location = new System.Drawing.Point(37, 47);
this.num单元格合并_行2.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num单元格合并_行2.Name = "num单元格合并_行2";
this.num单元格合并_行2.Size = new System.Drawing.Size(94, 21);
this.num单元格合并_行2.TabIndex = 2;
this.num单元格合并_行2.Value = new decimal(new int[] {
2,
0,
0,
0});
//
// label7
//
this.label7.AutoSize = true;
this.label7.Location = new System.Drawing.Point(162, 49);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(29, 12);
this.label7.TabIndex = 1;
this.label7.Text = "列2:";
//
// num单元格合并_行1
//
this.num单元格合并_行1.Location = new System.Drawing.Point(37, 20);
this.num单元格合并_行1.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num单元格合并_行1.Name = "num单元格合并_行1";
this.num单元格合并_行1.Size = new System.Drawing.Size(94, 21);
this.num单元格合并_行1.TabIndex = 2;
this.num单元格合并_行1.Value = new decimal(new int[] {
1,
0,
0,
0});
//
// label6
//
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(5, 49);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(29, 12);
this.label6.TabIndex = 1;
this.label6.Text = "行2:";
//
// label4
//
this.label4.AutoSize = true;
this.label4.Location = new System.Drawing.Point(162, 22);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(29, 12);
this.label4.TabIndex = 1;
this.label4.Text = "列1:";
//
// label5
//
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(5, 22);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(29, 12);
this.label5.TabIndex = 1;
this.label5.Text = "行1:";
//
// groupBox1
//
this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.groupBox1.Controls.Add(this.btn单元格填充);
this.groupBox1.Controls.Add(this.num单元格填充_列号);
this.groupBox1.Controls.Add(this.num单元格填充_行号);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txt单元格填充填充_文本内容);
this.groupBox1.Location = new System.Drawing.Point(6, 6);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(513, 82);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "单元格填充";
//
// btn单元格填充
//
this.btn单元格填充.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn单元格填充.Location = new System.Drawing.Point(432, 49);
this.btn单元格填充.Name = "btn单元格填充";
this.btn单元格填充.Size = new System.Drawing.Size(75, 23);
this.btn单元格填充.TabIndex = 3;
this.btn单元格填充.Text = "填 充";
this.btn单元格填充.UseVisualStyleBackColor = true;
this.btn单元格填充.Click += new System.EventHandler(this.btn单元格填充_Click);
//
// num单元格填充_列号
//
this.num单元格填充_列号.Location = new System.Drawing.Point(191, 49);
this.num单元格填充_列号.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num单元格填充_列号.Name = "num单元格填充_列号";
this.num单元格填充_列号.Size = new System.Drawing.Size(94, 21);
this.num单元格填充_列号.TabIndex = 2;
this.num单元格填充_列号.Value = new decimal(new int[] {
1,
0,
0,
0});
//
// num单元格填充_行号
//
this.num单元格填充_行号.Location = new System.Drawing.Point(37, 49);
this.num单元格填充_行号.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num单元格填充_行号.Name = "num单元格填充_行号";
this.num单元格填充_行号.Size = new System.Drawing.Size(94, 21);
this.num单元格填充_行号.TabIndex = 2;
this.num单元格填充_行号.Value = new decimal(new int[] {
1,
0,
0,
0});
//
// label3
//
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(162, 51);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(23, 12);
this.label3.TabIndex = 1;
this.label3.Text = "列:";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(6, 51);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(23, 12);
this.label2.TabIndex = 1;
this.label2.Text = "行:";
//
// txt单元格填充填充_文本内容
//
this.txt单元格填充填充_文本内容.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.txt单元格填充填充_文本内容.Location = new System.Drawing.Point(7, 21);
this.txt单元格填充填充_文本内容.Name = "txt单元格填充填充_文本内容";
this.txt单元格填充填充_文本内容.Size = new System.Drawing.Size(500, 21);
this.txt单元格填充填充_文本内容.TabIndex = 0;
this.txt单元格填充填充_文本内容.Text = "Excel单元格文本内容填充示例";
//
// tabPage3
//
this.tabPage3.Controls.Add(this.ckbWrapText);
this.tabPage3.Controls.Add(this.lnk选择Font);
this.tabPage3.Controls.Add(this.pnlColor);
this.tabPage3.Controls.Add(this.btnWrapText);
this.tabPage3.Controls.Add(this.btnSetVAlign);
this.tabPage3.Controls.Add(this.btnSetHAlign);
this.tabPage3.Controls.Add(this.btnSetFont);
this.tabPage3.Controls.Add(this.btnSetBordersToDiagonal);
this.tabPage3.Controls.Add(this.btnSetBordersToOutside);
this.tabPage3.Controls.Add(this.btnSetBordersToInside);
this.tabPage3.Controls.Add(this.btn边框设置);
this.tabPage3.Controls.Add(this.label19);
this.tabPage3.Controls.Add(this.label20);
this.tabPage3.Controls.Add(this.label22);
this.tabPage3.Controls.Add(this.label21);
this.tabPage3.Controls.Add(this.label18);
this.tabPage3.Controls.Add(this.cbbBordersIndex);
this.tabPage3.Controls.Add(this.cbbVAlign);
this.tabPage3.Controls.Add(this.cbbHAlign);
this.tabPage3.Controls.Add(this.cbb边框样式);
this.tabPage3.Controls.Add(this.num样式设置_列2);
this.tabPage3.Controls.Add(this.num边框粗细);
this.tabPage3.Controls.Add(this.num样式设置_列1);
this.tabPage3.Controls.Add(this.num样式设置_行2);
this.tabPage3.Controls.Add(this.label14);
this.tabPage3.Controls.Add(this.num样式设置_行1);
this.tabPage3.Controls.Add(this.label15);
this.tabPage3.Controls.Add(this.label16);
this.tabPage3.Controls.Add(this.label17);
this.tabPage3.Location = new System.Drawing.Point(4, 22);
this.tabPage3.Name = "tabPage3";
this.tabPage3.Padding = new System.Windows.Forms.Padding(3);
this.tabPage3.Size = new System.Drawing.Size(525, 281);
this.tabPage3.TabIndex = 2;
this.tabPage3.Text = "样式设置";
this.tabPage3.UseVisualStyleBackColor = true;
//
// pnlColor
//
this.pnlColor.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.pnlColor.BackColor = System.Drawing.Color.Black;
this.pnlColor.Location = new System.Drawing.Point(446, 8);
this.pnlColor.Name = "pnlColor";
this.pnlColor.Size = new System.Drawing.Size(73, 26);
this.pnlColor.TabIndex = 15;
this.pnlColor.Click += new System.EventHandler(this.pnlColor_Click);
//
// btn边框设置
//
this.btn边框设置.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn边框设置.Location = new System.Drawing.Point(383, 90);
this.btn边框设置.Name = "btn边框设置";
this.btn边框设置.Size = new System.Drawing.Size(139, 23);
this.btn边框设置.TabIndex = 13;
this.btn边框设置.Text = "边框设置";
this.btn边框设置.UseVisualStyleBackColor = true;
this.btn边框设置.Click += new System.EventHandler(this.btn边框设置_Click);
//
// label19
//
this.label19.AutoSize = true;
this.label19.Location = new System.Drawing.Point(286, 69);
this.label19.Name = "label19";
this.label19.Size = new System.Drawing.Size(35, 12);
this.label19.TabIndex = 12;
this.label19.Text = "粗细:";
//
// label18
//
this.label18.AutoSize = true;
this.label18.Location = new System.Drawing.Point(10, 69);
this.label18.Name = "label18";
this.label18.Size = new System.Drawing.Size(65, 12);
this.label18.TabIndex = 12;
this.label18.Text = "LineStyle:";
//
// cbb边框样式
//
this.cbb边框样式.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cbb边框样式.FormattingEnabled = true;
this.cbb边框样式.Location = new System.Drawing.Point(111, 65);
this.cbb边框样式.Name = "cbb边框样式";
this.cbb边框样式.Size = new System.Drawing.Size(158, 20);
this.cbb边框样式.TabIndex = 11;
//
// num样式设置_列2
//
this.num样式设置_列2.Location = new System.Drawing.Point(175, 33);
this.num样式设置_列2.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num样式设置_列2.Name = "num样式设置_列2";
this.num样式设置_列2.Size = new System.Drawing.Size(94, 21);
this.num样式设置_列2.TabIndex = 7;
this.num样式设置_列2.Value = new decimal(new int[] {
6,
0,
0,
0});
//
// num边框粗细
//
this.num边框粗细.Location = new System.Drawing.Point(327, 66);
this.num边框粗细.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num边框粗细.Name = "num边框粗细";
this.num边框粗细.Size = new System.Drawing.Size(67, 21);
this.num边框粗细.TabIndex = 8;
this.num边框粗细.Value = new decimal(new int[] {
1,
0,
0,
0});
//
// num样式设置_列1
//
this.num样式设置_列1.Location = new System.Drawing.Point(175, 6);
this.num样式设置_列1.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num样式设置_列1.Name = "num样式设置_列1";
this.num样式设置_列1.Size = new System.Drawing.Size(94, 21);
this.num样式设置_列1.TabIndex = 8;
this.num样式设置_列1.Value = new decimal(new int[] {
2,
0,
0,
0});
//
// num样式设置_行2
//
this.num样式设置_行2.Location = new System.Drawing.Point(40, 33);
this.num样式设置_行2.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num样式设置_行2.Name = "num样式设置_行2";
this.num样式设置_行2.Size = new System.Drawing.Size(94, 21);
this.num样式设置_行2.TabIndex = 9;
this.num样式设置_行2.Value = new decimal(new int[] {
5,
0,
0,
0});
//
// label14
//
this.label14.AutoSize = true;
this.label14.Location = new System.Drawing.Point(140, 35);
this.label14.Name = "label14";
this.label14.Size = new System.Drawing.Size(29, 12);
this.label14.TabIndex = 3;
this.label14.Text = "列2:";
//
// num样式设置_行1
//
this.num样式设置_行1.Location = new System.Drawing.Point(40, 6);
this.num样式设置_行1.Minimum = new decimal(new int[] {
1,
0,
0,
0});
this.num样式设置_行1.Name = "num样式设置_行1";
this.num样式设置_行1.Size = new System.Drawing.Size(94, 21);
this.num样式设置_行1.TabIndex = 10;
this.num样式设置_行1.Value = new decimal(new int[] {
3,
0,
0,
0});
//
// label15
//
this.label15.AutoSize = true;
this.label15.Location = new System.Drawing.Point(8, 35);
this.label15.Name = "label15";
this.label15.Size = new System.Drawing.Size(29, 12);
this.label15.TabIndex = 4;
this.label15.Text = "行2:";
//
// label16
//
this.label16.AutoSize = true;
this.label16.Location = new System.Drawing.Point(140, 8);
this.label16.Name = "label16";
this.label16.Size = new System.Drawing.Size(29, 12);
this.label16.TabIndex = 5;
this.label16.Text = "列1:";
//
// label17
//
this.label17.AutoSize = true;
this.label17.Location = new System.Drawing.Point(8, 8);
this.label17.Name = "label17";
this.label17.Size = new System.Drawing.Size(29, 12);
this.label17.TabIndex = 6;
this.label17.Text = "行1:";
//
// btnLoad
//
this.btnLoad.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnLoad.Location = new System.Drawing.Point(389, 31);
this.btnLoad.Name = "btnLoad";
this.btnLoad.Size = new System.Drawing.Size(75, 23);
this.btnLoad.TabIndex = 6;
this.btnLoad.Text = "加 载";
this.btnLoad.UseVisualStyleBackColor = true;
this.btnLoad.Click += new System.EventHandler(this.btnLoad_Click);
//
// cbbSheets
//
this.cbbSheets.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.cbbSheets.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cbbSheets.FormattingEnabled = true;
this.cbbSheets.Location = new System.Drawing.Point(68, 32);
this.cbbSheets.Name = "cbbSheets";
this.cbbSheets.Size = new System.Drawing.Size(315, 20);
this.cbbSheets.TabIndex = 7;
//
// btnUnload
//
this.btnUnload.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnUnload.Location = new System.Drawing.Point(470, 31);
this.btnUnload.Name = "btnUnload";
this.btnUnload.Size = new System.Drawing.Size(75, 23);
this.btnUnload.TabIndex = 6;
this.btnUnload.Text = "卸 载";
this.btnUnload.UseVisualStyleBackColor = true;
this.btnUnload.Click += new System.EventHandler(this.btnUnload_Click);
//
// btn浏览
//
this.btn浏览.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn浏览.Location = new System.Drawing.Point(389, 4);
this.btn浏览.Name = "btn浏览";
this.btn浏览.Size = new System.Drawing.Size(75, 23);
this.btn浏览.TabIndex = 1;
this.btn浏览.Text = "浏览..";
this.btn浏览.UseVisualStyleBackColor = true;
this.btn浏览.Click += new System.EventHandler(this.btn浏览_Click);
//
// label11
//
this.label11.AutoSize = true;
this.label11.Location = new System.Drawing.Point(14, 60);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(47, 12);
this.label11.TabIndex = 1;
this.label11.Text = "起始行:";
//
// label12
//
this.label12.AutoSize = true;
this.label12.Location = new System.Drawing.Point(179, 60);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(47, 12);
this.label12.TabIndex = 1;
this.label12.Text = "起始列:";
//
// num起始行
//
this.num起始行.Location = new System.Drawing.Point(68, 58);
this.num起始行.Name = "num起始行";
this.num起始行.Size = new System.Drawing.Size(94, 21);
this.num起始行.TabIndex = 2;
//
// num起始列
//
this.num起始列.Location = new System.Drawing.Point(232, 58);
this.num起始列.Name = "num起始列";
this.num起始列.Size = new System.Drawing.Size(94, 21);
this.num起始列.TabIndex = 2;
//
// cbbBordersIndex
//
this.cbbBordersIndex.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cbbBordersIndex.FormattingEnabled = true;
this.cbbBordersIndex.Location = new System.Drawing.Point(111, 91);
this.cbbBordersIndex.Name = "cbbBordersIndex";
this.cbbBordersIndex.Size = new System.Drawing.Size(158, 20);
this.cbbBordersIndex.TabIndex = 11;
//
// label20
//
this.label20.AutoSize = true;
this.label20.Location = new System.Drawing.Point(10, 94);
this.label20.Name = "label20";
this.label20.Size = new System.Drawing.Size(83, 12);
this.label20.TabIndex = 12;
this.label20.Text = "BordersIndex:";
//
// btnSetBordersToInside
//
this.btnSetBordersToInside.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnSetBordersToInside.Location = new System.Drawing.Point(383, 119);
this.btnSetBordersToInside.Name = "btnSetBordersToInside";
this.btnSetBordersToInside.Size = new System.Drawing.Size(136, 23);
this.btnSetBordersToInside.TabIndex = 13;
this.btnSetBordersToInside.Text = "SetBordersToInside";
this.btnSetBordersToInside.UseVisualStyleBackColor = true;
this.btnSetBordersToInside.Click += new System.EventHandler(this.btnSetBordersToInside_Click);
//
// btnSetBordersToOutside
//
this.btnSetBordersToOutside.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnSetBordersToOutside.Location = new System.Drawing.Point(383, 148);
this.btnSetBordersToOutside.Name = "btnSetBordersToOutside";
this.btnSetBordersToOutside.Size = new System.Drawing.Size(136, 23);
this.btnSetBordersToOutside.TabIndex = 13;
this.btnSetBordersToOutside.Text = "SetBordersToOutside";
this.btnSetBordersToOutside.UseVisualStyleBackColor = true;
this.btnSetBordersToOutside.Click += new System.EventHandler(this.btnSetBordersToOutside_Click);
//
// btnSetBordersToDiagonal
//
this.btnSetBordersToDiagonal.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnSetBordersToDiagonal.Location = new System.Drawing.Point(383, 177);
this.btnSetBordersToDiagonal.Name = "btnSetBordersToDiagonal";
this.btnSetBordersToDiagonal.Size = new System.Drawing.Size(136, 23);
this.btnSetBordersToDiagonal.TabIndex = 13;
this.btnSetBordersToDiagonal.Text = "SetBordersToDiagonal";
this.btnSetBordersToDiagonal.UseVisualStyleBackColor = true;
this.btnSetBordersToDiagonal.Click += new System.EventHandler(this.btnSetBordersToDiagonal_Click);
//
// fontDialog1
//
this.fontDialog1.Color = System.Drawing.SystemColors.ControlText;
//
// lnk选择Font
//
this.lnk选择Font.AutoSize = true;
this.lnk选择Font.Location = new System.Drawing.Point(10, 148);
this.lnk选择Font.Name = "lnk选择Font";
this.lnk选择Font.Size = new System.Drawing.Size(71, 12);
this.lnk选择Font.TabIndex = 16;
this.lnk选择Font.TabStop = true;
this.lnk选择Font.Text = "选择Font...";
this.lnk选择Font.LinkClicked += new System.Windows.Forms.LinkLabelLinkClickedEventHandler(this.lnk选择Font_LinkClicked);
//
// btnSetFont
//
this.btnSetFont.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnSetFont.Location = new System.Drawing.Point(211, 143);
this.btnSetFont.Name = "btnSetFont";
this.btnSetFont.Size = new System.Drawing.Size(99, 23);
this.btnSetFont.TabIndex = 13;
this.btnSetFont.Text = "SetFont";
this.btnSetFont.UseVisualStyleBackColor = true;
this.btnSetFont.Click += new System.EventHandler(this.btnSetFont_Click);
//
// btnSetHAlign
//
this.btnSetHAlign.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnSetHAlign.Location = new System.Drawing.Point(211, 172);
this.btnSetHAlign.Name = "btnSetHAlign";
this.btnSetHAlign.Size = new System.Drawing.Size(99, 23);
this.btnSetHAlign.TabIndex = 13;
this.btnSetHAlign.Text = "SetHAlign";
this.btnSetHAlign.UseVisualStyleBackColor = true;
this.btnSetHAlign.Click += new System.EventHandler(this.btnSetHAlign_Click);
//
// btnSetVAlign
//
this.btnSetVAlign.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnSetVAlign.Location = new System.Drawing.Point(211, 201);
this.btnSetVAlign.Name = "btnSetVAlign";
this.btnSetVAlign.Size = new System.Drawing.Size(99, 23);
this.btnSetVAlign.TabIndex = 13;
this.btnSetVAlign.Text = "SetVAlign";
this.btnSetVAlign.UseVisualStyleBackColor = true;
this.btnSetVAlign.Click += new System.EventHandler(this.btnSetVAlign_Click);
//
// cbbHAlign
//
this.cbbHAlign.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cbbHAlign.FormattingEnabled = true;
this.cbbHAlign.Location = new System.Drawing.Point(61, 174);
this.cbbHAlign.Name = "cbbHAlign";
this.cbbHAlign.Size = new System.Drawing.Size(144, 20);
this.cbbHAlign.TabIndex = 11;
//
// label21
//
this.label21.AutoSize = true;
this.label21.Location = new System.Drawing.Point(8, 177);
this.label21.Name = "label21";
this.label21.Size = new System.Drawing.Size(47, 12);
this.label21.TabIndex = 12;
this.label21.Text = "HAlign:";
//
// cbbVAlign
//
this.cbbVAlign.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cbbVAlign.FormattingEnabled = true;
this.cbbVAlign.Location = new System.Drawing.Point(61, 200);
this.cbbVAlign.Name = "cbbVAlign";
this.cbbVAlign.Size = new System.Drawing.Size(144, 20);
this.cbbVAlign.TabIndex = 11;
//
// label22
//
this.label22.AutoSize = true;
this.label22.Location = new System.Drawing.Point(8, 203);
this.label22.Name = "label22";
this.label22.Size = new System.Drawing.Size(47, 12);
this.label22.TabIndex = 12;
this.label22.Text = "VAlign:";
//
// btnWrapText
//
this.btnWrapText.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btnWrapText.Location = new System.Drawing.Point(211, 230);
this.btnWrapText.Name = "btnWrapText";
this.btnWrapText.Size = new System.Drawing.Size(99, 23);
this.btnWrapText.TabIndex = 13;
this.btnWrapText.Text = "WrapText";
this.btnWrapText.UseVisualStyleBackColor = true;
this.btnWrapText.Click += new System.EventHandler(this.btnWrapText_Click);
//
// ckbWrapText
//
this.ckbWrapText.AutoSize = true;
this.ckbWrapText.Location = new System.Drawing.Point(61, 233);
this.ckbWrapText.Name = "ckbWrapText";
this.ckbWrapText.Size = new System.Drawing.Size(72, 16);
this.ckbWrapText.TabIndex = 17;
this.ckbWrapText.Text = "WrapText";
this.ckbWrapText.UseVisualStyleBackColor = true;
//
// frmSheetHelperTest
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(557, 404);
this.Controls.Add(this.cbbSheets);
this.Controls.Add(this.num起始列);
this.Controls.Add(this.num起始行);
this.Controls.Add(this.btnUnload);
this.Controls.Add(this.label12);
this.Controls.Add(this.btnLoad);
this.Controls.Add(this.label11);
this.Controls.Add(this.tabControl1);
this.Controls.Add(this.label1);
this.Controls.Add(this.btn浏览);
this.Controls.Add(this.btn打开);
this.Controls.Add(this.txtFilePath);
this.Name = "frmSheetHelperTest";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "frmSheetHelperTest";
this.tabControl1.ResumeLayout(false);
this.tabPage2.ResumeLayout(false);
this.tabPage2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.num高宽)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num删除插入数量)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num行列号CopyTo)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num行列号)).EndInit();
this.tabPage1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
this.groupBox2.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.num单元格合并_列2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num单元格合并_列1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num单元格合并_行2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num单元格合并_行1)).EndInit();
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.num单元格填充_列号)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num单元格填充_行号)).EndInit();
this.tabPage3.ResumeLayout(false);
this.tabPage3.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.num样式设置_列2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num边框粗细)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num样式设置_列1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num样式设置_行2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num样式设置_行1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num起始行)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.num起始列)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
#endregion
private System.Windows.Forms.TextBox txtFilePath;
private System.Windows.Forms.Button btn打开;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TabControl tabControl1;
private System.Windows.Forms.TabPage tabPage1;
private System.Windows.Forms.TabPage tabPage2;
private System.Windows.Forms.Button btnLoad;
private System.Windows.Forms.ComboBox cbbSheets;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.TextBox txt单元格填充填充_文本内容;
private System.Windows.Forms.NumericUpDown num单元格填充_行号;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.NumericUpDown num单元格填充_列号;
private System.Windows.Forms.Button btn单元格填充;
private System.Windows.Forms.Button btnUnload;
private System.Windows.Forms.Button btn浏览;
private System.Windows.Forms.GroupBox groupBox2;
private System.Windows.Forms.Button btn单元格合并;
private System.Windows.Forms.NumericUpDown num单元格合并_列1;
private System.Windows.Forms.NumericUpDown num单元格合并_行1;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.NumericUpDown num单元格合并_列2;
private System.Windows.Forms.NumericUpDown num单元格合并_行2;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Button btn单元格合并_解除;
private System.Windows.Forms.Button btn插入行;
private System.Windows.Forms.NumericUpDown num行列号;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.Button btn插入列;
private System.Windows.Forms.NumericUpDown num高宽;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Button btn设置列宽;
private System.Windows.Forms.Button btn设置行高;
private System.Windows.Forms.NumericUpDown num删除插入数量;
private System.Windows.Forms.Label label10;
private System.Windows.Forms.Label label11;
private System.Windows.Forms.Label label12;
private System.Windows.Forms.NumericUpDown num起始行;
private System.Windows.Forms.NumericUpDown num起始列;
private System.Windows.Forms.Button btn删除列;
private System.Windows.Forms.Button btn删除行;
private System.Windows.Forms.Button btn自适应列宽;
private System.Windows.Forms.Button btn自适应行高;
private System.Windows.Forms.CheckBox ckb插入拷贝;
private System.Windows.Forms.Button btn拷贝列;
private System.Windows.Forms.Button btn拷贝行;
private System.Windows.Forms.NumericUpDown num行列号CopyTo;
private System.Windows.Forms.Label label13;
private System.Windows.Forms.TabPage tabPage3;
private System.Windows.Forms.NumericUpDown num样式设置_列2;
private System.Windows.Forms.NumericUpDown num样式设置_列1;
private System.Windows.Forms.NumericUpDown num样式设置_行2;
private System.Windows.Forms.Label label14;
private System.Windows.Forms.NumericUpDown num样式设置_行1;
private System.Windows.Forms.Label label15;
private System.Windows.Forms.Label label16;
private System.Windows.Forms.Label label17;
private System.Windows.Forms.Label label18;
private System.Windows.Forms.ComboBox cbb边框样式;
private System.Windows.Forms.Button btn边框设置;
private System.Windows.Forms.Label label19;
private System.Windows.Forms.NumericUpDown num边框粗细;
private System.Windows.Forms.ColorDialog colorDialog1;
private System.Windows.Forms.Panel pnlColor;
private System.Windows.Forms.Label label20;
private System.Windows.Forms.ComboBox cbbBordersIndex;
private System.Windows.Forms.Button btnSetBordersToInside;
private System.Windows.Forms.Button btnSetBordersToOutside;
private System.Windows.Forms.Button btnSetBordersToDiagonal;
private System.Windows.Forms.LinkLabel lnk选择Font;
private System.Windows.Forms.FontDialog fontDialog1;
private System.Windows.Forms.Button btnSetFont;
private System.Windows.Forms.Button btnSetHAlign;
private System.Windows.Forms.Button btnSetVAlign;
private System.Windows.Forms.Label label22;
private System.Windows.Forms.Label label21;
private System.Windows.Forms.ComboBox cbbVAlign;
private System.Windows.Forms.ComboBox cbbHAlign;
private System.Windows.Forms.Button btnWrapText;
private System.Windows.Forms.CheckBox ckbWrapText;
}
扫一扫
4938
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
