/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
Spire.DataExport.XLS.WorkSheet workSheet1 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.StripStyle stripStyle1 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.StripStyle stripStyle2 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.WorkSheet workSheet2 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.StripStyle stripStyle3 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.StripStyle stripStyle4 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.WorkSheet workSheet3 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.Chart chart1 = new Spire.DataExport.XLS.Chart();
Spire.DataExport.XLS.ChartSeries chartSeries1 = new Spire.DataExport.XLS.ChartSeries();
Spire.DataExport.XLS.StripStyle stripStyle5 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.StripStyle stripStyle6 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.WorkSheet workSheet4 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.Chart chart2 = new Spire.DataExport.XLS.Chart();
Spire.DataExport.XLS.ChartSeries chartSeries2 = new Spire.DataExport.XLS.ChartSeries();
Spire.DataExport.XLS.WorkSheet workSheet5 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.StripStyle stripStyle7 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.StripStyle stripStyle8 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.WorkSheet workSheet6 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.ColumnFormat columnFormat1 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.ColumnFormat columnFormat2 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.ColumnFormat columnFormat3 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.ColumnFormat columnFormat4 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.ColumnFormat columnFormat5 = new Spire.DataExport.XLS.ColumnFormat();
this.oleDbCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbCommand2 = new System.Data.OleDb.OleDbCommand();
this.cellExport1 = new Spire.DataExport.XLS.CellExport();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.txtCommandTxt1 = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.button2 = new System.Windows.Forms.Button();
this.txtCommandText = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtConnectString = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.dgDetail = new System.Windows.Forms.DataGrid();
this.btnRun = new System.Windows.Forms.Button();
this.btnAbout = new System.Windows.Forms.Button();
this.button1 = new System.Windows.Forms.Button();
this.cellExport2 = new Spire.DataExport.XLS.CellExport();
this.button3 = new System.Windows.Forms.Button();
this.label4 = new System.Windows.Forms.Label();
this.button4 = new System.Windows.Forms.Button();
this.cellExport4 = new Spire.DataExport.XLS.CellExport();
this.button5 = new System.Windows.Forms.Button();
this.cellExport5 = new Spire.DataExport.XLS.CellExport();
this.cellExport3 = new Spire.DataExport.XLS.CellExport();
this.groupBox1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dgDetail)).BeginInit();
this.SuspendLayout();
//
// oleDbCommand1
//
this.oleDbCommand1.CommandText = "select * from parts";
this.oleDbCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = resources.GetString("oleDbConnection1.ConnectionString");
//
// oleDbCommand2
//
this.oleDbCommand2.CommandText = "select * from country";
this.oleDbCommand2.Connection = this.oleDbConnection1;
//
// cellExport1
//
this.cellExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.cellExport1.AutoFitColWidth = true;
this.cellExport1.AutoFormula = true;
this.cellExport1.DataFormats.CultureName = "zh-CN";
this.cellExport1.DataFormats.Currency = "$#,###,##0.00";
this.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport1.DataFormats.Float = "#,###,##0.00";
this.cellExport1.DataFormats.Integer = "#,###,##0";
this.cellExport1.DataFormats.Time = "H:mm";
this.cellExport1.FileName = "Sheets.xls";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport1.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport1.SheetOptions.TitlesFormat.Font.Bold = true;
workSheet1.AutoFitColWidth = true;
workSheet1.CustomFormats.AddRange(new object[] {
"OnHand=#,##0",
"OnOrder=#,##0",
"Cost=#,##0.0000;-#,##0.0000"});
workSheet1.FormatsExport.CultureName = "zh-CN";
workSheet1.FormatsExport.Currency = "гд#,###,##0.00";
workSheet1.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet1.FormatsExport.Float = "#,###,##0.00";
workSheet1.FormatsExport.Integer = "#,###,##0";
workSheet1.FormatsExport.Time = "H:mm";
stripStyle1.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle1.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle1.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle1.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle1.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightGreen;
stripStyle1.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle2.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle2.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle2.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle2.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle2.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
stripStyle2.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet1.ItemStyles.Add(stripStyle1);
workSheet1.ItemStyles.Add(stripStyle2);
workSheet1.ItemType = Spire.DataExport.XLS.CellItemType.Col;
workSheet1.Options.HeaderFormat.Font.Bold = true;
workSheet1.Options.HeaderFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet1.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet1.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet1.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet1.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet1.Options.NoteFormat.Font.Bold = true;
workSheet1.Options.NoteFormat.Font.Name = "Tahoma";
workSheet1.Options.NoteFormat.Font.Size = 8F;
workSheet1.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet1.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet1.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet1.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet1.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet1.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet1.Options.TitlesFormat.Font.Bold = true;
workSheet1.SheetName = "parts";
workSheet1.SQLCommand = this.oleDbCommand1;
workSheet1.StartDataCol = ((byte)(0));
workSheet2.AutoFitColWidth = true;
workSheet2.CustomFormats.AddRange(new object[] {
"Area=#,##0",
"Population=#,##0"});
workSheet2.FormatsExport.CultureName = "zh-CN";
workSheet2.FormatsExport.Currency = "гд#,###,##0.00";
workSheet2.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet2.FormatsExport.Float = "#,###,##0.00";
workSheet2.FormatsExport.Integer = "#,###,##0";
workSheet2.FormatsExport.Time = "H:mm";
stripStyle3.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle3.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle3.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle3.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle3.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightGreen;
stripStyle3.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle4.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle4.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle4.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle4.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle4.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
stripStyle4.FillStyle.Foreground = Spire.DataExport.XLS.CellColor.White;
stripStyle4.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet2.ItemStyles.Add(stripStyle3);
workSheet2.ItemStyles.Add(stripStyle4);
workSheet2.ItemType = Spire.DataExport.XLS.CellItemType.Col;
workSheet2.Options.FooterFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet2.Options.HeaderFormat.Font.Bold = true;
workSheet2.Options.HeaderFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet2.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet2.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet2.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet2.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet2.Options.NoteFormat.Font.Bold = true;
workSheet2.Options.NoteFormat.Font.Name = "Tahoma";
workSheet2.Options.NoteFormat.Font.Size = 8F;
workSheet2.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet2.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet2.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet2.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet2.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet2.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet2.Options.TitlesFormat.Font.Bold = true;
workSheet2.SheetName = "country";
workSheet2.SQLCommand = this.oleDbCommand2;
workSheet2.StartDataCol = ((byte)(0));
this.cellExport1.Sheets.Add(workSheet1);
this.cellExport1.Sheets.Add(workSheet2);
this.cellExport1.SQLCommand = this.oleDbCommand1;
this.cellExport1.GetDataParams += new Spire.DataExport.Delegates.DataParamsEventHandler(this.cellExport1_GetDataParams);
//
// groupBox1
//
this.groupBox1.Controls.Add(this.txtCommandTxt1);
this.groupBox1.Controls.Add(this.label3);
this.groupBox1.Controls.Add(this.button2);
this.groupBox1.Controls.Add(this.txtCommandText);
this.groupBox1.Controls.Add(this.label2);
this.groupBox1.Controls.Add(this.txtConnectString);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Location = new System.Drawing.Point(16, 13);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(312, 203);
this.groupBox1.TabIndex = 0;
this.groupBox1.TabStop = false;
this.groupBox1.Text = " Data source ";
//
// txtCommandTxt1
//
this.txtCommandTxt1.Location = new System.Drawing.Point(17, 144);
this.txtCommandTxt1.Name = "txtCommandTxt1";
this.txtCommandTxt1.Size = new System.Drawing.Size(279, 21);
this.txtCommandTxt1.TabIndex = 7;
this.txtCommandTxt1.Text = "select * from country";
//
// label3
//
this.label3.Location = new System.Drawing.Point(16, 120);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(256, 23);
this.label3.TabIndex = 6;
this.label3.Text = "Command text for the second work sheet:";
//
// button2
//
this.button2.Location = new System.Drawing.Point(232, 173);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(64, 23);
this.button2.TabIndex = 5;
this.button2.Text = "Load";
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// txtCommandText
//
this.txtCommandText.Location = new System.Drawing.Point(17, 95);
this.txtCommandText.Name = "txtCommandText";
this.txtCommandText.Size = new System.Drawing.Size(279, 21);
this.txtCommandText.TabIndex = 3;
this.txtCommandText.Text = "select * from parts";
//
// label2
//
this.label2.Location = new System.Drawing.Point(16, 75);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(240, 23);
this.label2.TabIndex = 2;
this.label2.Text = "Command text for the first work sheet:";
//
// txtConnectString
//
this.txtConnectString.Location = new System.Drawing.Point(16, 43);
this.txtConnectString.Name = "txtConnectString";
this.txtConnectString.Size = new System.Drawing.Size(280, 21);
this.txtConnectString.TabIndex = 1;
this.txtConnectString.Text = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\\\..\\\\..\\\\..\\\\database\\\\demo.mdb";
//
// label1
//
this.label1.Location = new System.Drawing.Point(15, 23);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(121, 16);
this.label1.TabIndex = 0;
this.label1.Text = "Connection string:";
//
// dgDetail
//
this.dgDetail.DataMember = "";
this.dgDetail.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dgDetail.Location = new System.Drawing.Point(16, 224);
this.dgDetail.Name = "dgDetail";
this.dgDetail.Size = new System.Drawing.Size(584, 128);
this.dgDetail.TabIndex = 0;
//
// btnRun
//
this.btnRun.Location = new System.Drawing.Point(368, 24);
this.btnRun.Name = "btnRun";
this.btnRun.Size = new System.Drawing.Size(96, 23);
this.btnRun.TabIndex = 2;
this.btnRun.Text = "Multi-Sheets";
this.btnRun.Click += new System.EventHandler(this.btnRun_Click);
//
// btnAbout
//
this.btnAbout.Location = new System.Drawing.Point(528, 368);
this.btnAbout.Name = "btnAbout";
this.btnAbout.Size = new System.Drawing.Size(75, 23);
this.btnAbout.TabIndex = 3;
this.btnAbout.Text = "Close";
this.btnAbout.Click += new System.EventHandler(this.btnAbout_Click);
//
// button1
//
this.button1.Location = new System.Drawing.Point(368, 56);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(96, 23);
this.button1.TabIndex = 2;
this.button1.Text = "Chart1";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// cellExport2
//
this.cellExport2.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.cellExport2.AutoFitColWidth = true;
this.cellExport2.DataFormats.CultureName = "zh-CN";
this.cellExport2.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport2.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport2.DataFormats.Float = "#,###,##0.00";
this.cellExport2.DataFormats.Integer = "#,###,##0";
this.cellExport2.DataFormats.Time = "H:mm";
this.cellExport2.FileName = "chart1.xls";
this.cellExport2.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport2.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport2.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport2.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport2.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport2.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport2.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport2.SheetOptions.TitlesFormat.Font.Bold = true;
workSheet3.AutoFitColWidth = true;
chart1.CategoryLabels.ColX = ((byte)(1));
chart1.CategoryLabels.ColY = ((byte)(1));
chart1.CategoryLabels.RowX = 1;
chart1.CategoryLabels.RowY = 9;
chart1.CategoryLabelsColumn = "Name";
chart1.DataRangeSheet = "charts";
chart1.Position.AutoPosition.Height = 12;
chart1.Position.AutoPosition.Top = 1;
chart1.Position.AutoPosition.Width = 6;
chartSeries1.DataColumn = "Population";
chartSeries1.DataRangeSheet = "charts";
chartSeries1.Title = "Population";
chart1.Series.Add(chartSeries1);
chart1.Style = Spire.DataExport.XLS.ChartStyle.Pie3d;
chart1.Title = "Chart demo";
workSheet3.Charts.Add(chart1);
workSheet3.FormatsExport.CultureName = "zh-CN";
workSheet3.FormatsExport.Currency = "гд#,###,##0.00";
workSheet3.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet3.FormatsExport.Float = "#,###,##0.00";
workSheet3.FormatsExport.Integer = "#,###,##0";
workSheet3.FormatsExport.Time = "H:mm";
stripStyle5.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle5.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle5.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle5.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle5.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightGreen;
stripStyle5.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle6.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle6.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle6.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle6.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle6.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
stripStyle6.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet3.ItemStyles.Add(stripStyle5);
workSheet3.ItemStyles.Add(stripStyle6);
workSheet3.ItemType = Spire.DataExport.XLS.CellItemType.Col;
workSheet3.Options.HeaderFormat.Font.Bold = true;
workSheet3.Options.HeaderFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet3.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet3.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet3.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet3.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet3.Options.NoteFormat.Font.Bold = true;
workSheet3.Options.NoteFormat.Font.Name = "Tahoma";
workSheet3.Options.NoteFormat.Font.Size = 8F;
workSheet3.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet3.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet3.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet3.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet3.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet3.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet3.Options.TitlesFormat.Font.Bold = true;
workSheet3.SheetName = "charts";
workSheet3.SQLCommand = this.oleDbCommand2;
workSheet3.StartDataCol = ((byte)(0));
this.cellExport2.Sheets.Add(workSheet3);
this.cellExport2.SQLCommand = this.oleDbCommand1;
//
// button3
//
this.button3.Location = new System.Drawing.Point(368, 88);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(96, 23);
this.button3.TabIndex = 2;
this.button3.Text = "Misc";
this.button3.Click += new System.EventHandler(this.button3_Click);
//
// label4
//
this.label4.ForeColor = System.Drawing.Color.Blue;
this.label4.Location = new System.Drawing.Point(352, 136);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(240, 64);
this.label4.TabIndex = 4;
this.label4.Text = "Notes : Not needing to have Microsoft Excel installed on the machine, The Spire.D" +
"ataExport can create Excel spreadsheet. ";
//
// button4
//
this.button4.Location = new System.Drawing.Point(488, 56);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(88, 23);
this.button4.TabIndex = 2;
this.button4.Text = "Chart2";
this.button4.Click += new System.EventHandler(this.button4_Click);
//
// cellExport4
//
this.cellExport4.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.cellExport4.AutoFitColWidth = true;
this.cellExport4.DataFormats.CultureName = "zh-CN";
this.cellExport4.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport4.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport4.DataFormats.Float = "#,###,##0.00";
this.cellExport4.DataFormats.Integer = "#,###,##0";
this.cellExport4.DataFormats.Time = "H:mm";
this.cellExport4.FileName = "chart2.xls";
this.cellExport4.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport4.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport4.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport4.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport4.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport4.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport4.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport4.SheetOptions.TitlesFormat.Font.Bold = true;
chart2.AutoColor = false;
chart2.CategoryLabels.ColX = ((byte)(1));
chart2.CategoryLabels.ColY = ((byte)(1));
chart2.CategoryLabels.RowX = 1;
chart2.CategoryLabels.RowY = 9;
chart2.CategoryLabelsColumn = "Name";
chart2.DataRangeSheet = "Sheet 2";
chart2.Position.AutoPosition.Height = 23;
chart2.Position.AutoPosition.Left = 1;
chart2.Position.AutoPosition.Top = 1;
chart2.Position.AutoPosition.Width = 11;
chart2.Position.CustomPosition.X1 = ((byte)(1));
chart2.Position.CustomPosition.X2 = ((byte)(15));
chart2.Position.CustomPosition.Y1 = 1;
chart2.Position.CustomPosition.Y2 = 30;
chartSeries2.Color = Spire.DataExport.XLS.CellColor.Tan;
chartSeries2.DataColumn = "Area";
chartSeries2.DataRangeSheet = "Sheet 2";
chartSeries2.Title = "Population";
chart2.Series.Add(chartSeries2);
chart2.Style = Spire.DataExport.XLS.ChartStyle.Bar;
chart2.Title = "Chart demo";
workSheet4.Charts.Add(chart2);
workSheet4.DataExported = false;
workSheet4.FormatsExport.CultureName = "zh-CN";
workSheet4.FormatsExport.Currency = "гд#,###,##0.00";
workSheet4.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet4.FormatsExport.Float = "#,###,##0.00";
workSheet4.FormatsExport.Integer = "#,###,##0";
workSheet4.FormatsExport.Time = "H:mm";
workSheet4.Options.HeaderFormat.Font.Bold = true;
workSheet4.Options.HeaderFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet4.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet4.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet4.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet4.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet4.Options.NoteFormat.Font.Bold = true;
workSheet4.Options.NoteFormat.Font.Name = "Tahoma";
workSheet4.Options.NoteFormat.Font.Size = 8F;
workSheet4.Options.TitlesFormat.Font.Bold = true;
workSheet4.Options.TitlesFormat.Font.Name = "Times New Roman";
workSheet4.Options.TitlesFormat.Font.Size = 13F;
workSheet4.SheetName = "charts";
workSheet4.StartDataCol = ((byte)(0));
workSheet5.AutoFitColWidth = true;
workSheet5.FormatsExport.CultureName = "zh-CN";
workSheet5.FormatsExport.Currency = "гд#,###,##0.00";
workSheet5.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet5.FormatsExport.Float = "#,###,##0.00";
workSheet5.FormatsExport.Integer = "#,###,##0";
workSheet5.FormatsExport.Time = "H:mm";
stripStyle7.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle7.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle7.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle7.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle7.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightGreen;
stripStyle7.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle8.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle8.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle8.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle8.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle8.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
stripStyle8.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet5.ItemStyles.Add(stripStyle7);
workSheet5.ItemStyles.Add(stripStyle8);
workSheet5.ItemType = Spire.DataExport.XLS.CellItemType.Col;
workSheet5.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet5.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet5.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet5.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet5.Options.NoteFormat.Font.Bold = true;
workSheet5.Options.NoteFormat.Font.Name = "Tahoma";
workSheet5.Options.NoteFormat.Font.Size = 8F;
workSheet5.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet5.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet5.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet5.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet5.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet5.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet5.Options.TitlesFormat.Font.Bold = true;
workSheet5.SheetName = "Sheet 2";
workSheet5.SQLCommand = this.oleDbCommand2;
workSheet5.StartDataCol = ((byte)(0));
this.cellExport4.Sheets.Add(workSheet4);
this.cellExport4.Sheets.Add(workSheet5);
this.cellExport4.SQLCommand = this.oleDbCommand1;
//
// button5
//
this.button5.Location = new System.Drawing.Point(488, 24);
this.button5.Name = "button5";
this.button5.Size = new System.Drawing.Size(88, 23);
this.button5.TabIndex = 5;
this.button5.Text = "Formula";
this.button5.Click += new System.EventHandler(this.button5_Click);
//
// cellExport5
//
this.cellExport5.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.cellExport5.ColumnsWidth.AddRange(new object[] {
"100",
"200"});
this.cellExport5.DataExported = false;
this.cellExport5.DataFormats.CultureName = "zh-CN";
this.cellExport5.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport5.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport5.DataFormats.Float = "#,###,##0.00";
this.cellExport5.DataFormats.Integer = "#,###,##0";
this.cellExport5.DataFormats.Time = "H:mm";
this.cellExport5.FileName = "formula.xls";
this.cellExport5.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport5.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport5.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport5.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport5.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport5.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport5.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport5.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport5.SQLCommand = this.oleDbCommand1;
//
// cellExport3
//
this.cellExport3.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.cellExport3.DataFormats.CultureName = "zh-CN";
this.cellExport3.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport3.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport3.DataFormats.Float = "#,###,##0.00";
this.cellExport3.DataFormats.Integer = "#,###,##0";
this.cellExport3.DataFormats.Time = "H:mm";
this.cellExport3.FileName = "misc.xls";
this.cellExport3.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport3.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport3.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport3.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport3.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport3.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport3.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport3.SheetOptions.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.Gray40Percent;
this.cellExport3.SheetOptions.TitlesFormat.Font.Bold = true;
columnFormat1.FieldName = "PartNo";
columnFormat1.Font.Bold = true;
columnFormat2.FieldName = "VendorNo";
columnFormat2.Font.Color = Spire.DataExport.XLS.CellColor.Color1;
columnFormat2.Font.Italic = true;
columnFormat3.FieldName = "Description";
columnFormat3.Font.Strikeout = true;
columnFormat3.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.DoubleAccounting;
columnFormat4.FieldName = "OnHand";
columnFormat4.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
columnFormat4.FillStyle.Foreground = Spire.DataExport.XLS.CellColor.Pink;
columnFormat4.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.ThinGorizontal;
columnFormat5.FieldName = "ListPrice";
columnFormat5.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
columnFormat5.FillStyle.Foreground = Spire.DataExport.XLS.CellColor.SkyBlue;
columnFormat5.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.ThinVertical;
workSheet6.ColumnFormats.Add(columnFormat1);
workSheet6.ColumnFormats.Add(columnFormat2);
workSheet6.ColumnFormats.Add(columnFormat3);
workSheet6.ColumnFormats.Add(columnFormat4);
workSheet6.ColumnFormats.Add(columnFormat5);
workSheet6.FormatsExport.CultureName = "zh-CN";
workSheet6.FormatsExport.Currency = "гд#,###,##0.00";
workSheet6.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet6.FormatsExport.Float = "#,###,##0.00";
workSheet6.FormatsExport.Integer = "#,###,##0";
workSheet6.FormatsExport.Time = "H:mm";
workSheet6.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet6.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet6.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet6.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet6.Options.NoteFormat.Font.Bold = true;
workSheet6.Options.NoteFormat.Font.Name = "Tahoma";
workSheet6.Options.NoteFormat.Font.Size = 8F;
workSheet6.Options.TitlesFormat.Font.Bold = true;
workSheet6.SheetName = "Sheet 1";
workSheet6.SQLCommand = this.oleDbCommand1;
workSheet6.StartDataCol = ((byte)(0));
this.cellExport3.Sheets.Add(workSheet6);
this.cellExport3.GetDataParams += new Spire.DataExport.Delegates.DataParamsEventHandler(this.cellExport1_GetDataParams);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(616, 398);
this.Controls.Add(this.button5);
this.Controls.Add(this.label4);
this.Controls.Add(this.btnAbout);
this.Controls.Add(this.btnRun);
this.Controls.Add(this.dgDetail);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.button1);
this.Controls.Add(this.button3);
this.Controls.Add(this.button4);
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "Form1";
this.Text = "Cell demo";
this.Load += new System.EventHandler(this.Form1_Load);
this.groupBox1.ResumeLayout(false);
this.groupBox1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dgDetail)).EndInit();
this.ResumeLayout(false);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
Spire.DataExport.XLS.WorkSheet workSheet1 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.ColumnFormat columnFormat1 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.StripStyle stripStyle1 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.StripStyle stripStyle2 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.WorkSheet workSheet2 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.StripStyle stripStyle3 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.StripStyle stripStyle4 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.WorkSheet workSheet3 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.ColumnFormat columnFormat2 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.ColumnFormat columnFormat3 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.ColumnFormat columnFormat4 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.ColumnFormat columnFormat5 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.ColumnFormat columnFormat6 = new Spire.DataExport.XLS.ColumnFormat();
Spire.DataExport.XLS.CellPicture cellPicture1 = new Spire.DataExport.XLS.CellPicture();
Spire.DataExport.XLS.WorkSheet workSheet4 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.CellImage cellImage1 = new Spire.DataExport.XLS.CellImage();
Spire.DataExport.XLS.CellImage cellImage2 = new Spire.DataExport.XLS.CellImage();
Spire.DataExport.XLS.WorkSheet workSheet5 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.Chart chart1 = new Spire.DataExport.XLS.Chart();
Spire.DataExport.XLS.ChartSeries chartSeries1 = new Spire.DataExport.XLS.ChartSeries();
Spire.DataExport.XLS.StripStyle stripStyle5 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.StripStyle stripStyle6 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.WorkSheet workSheet6 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.Chart chart2 = new Spire.DataExport.XLS.Chart();
Spire.DataExport.XLS.ChartSeries chartSeries2 = new Spire.DataExport.XLS.ChartSeries();
Spire.DataExport.XLS.WorkSheet workSheet7 = new Spire.DataExport.XLS.WorkSheet();
Spire.DataExport.XLS.StripStyle stripStyle7 = new Spire.DataExport.XLS.StripStyle();
Spire.DataExport.XLS.StripStyle stripStyle8 = new Spire.DataExport.XLS.StripStyle();
this.oleDbCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbCommand2 = new System.Data.OleDb.OleDbCommand();
this.cellExport1 = new Spire.DataExport.XLS.CellExport();
this.cellExport2 = new Spire.DataExport.XLS.CellExport();
this.cellExport3 = new Spire.DataExport.XLS.CellExport();
this.cellExport5 = new Spire.DataExport.XLS.CellExport();
this.cellExport6 = new Spire.DataExport.XLS.CellExport();
this.cellExport7 = new Spire.DataExport.XLS.CellExport();
this.cellExport8 = new Spire.DataExport.XLS.CellExport();
//
// oleDbCommand1
//
this.oleDbCommand1.CommandText = "SELECT * FROM PARTS";
this.oleDbCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source="".\..\database\demo.mdb"";Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
//
// oleDbCommand2
//
this.oleDbCommand2.CommandText = "SELECT * FROM Employee";
this.oleDbCommand2.Connection = this.oleDbConnection1;
//
// cellExport1
//
this.cellExport1.DataFormats.CultureName = "zh-CN";
this.cellExport1.DataFormats.Currency = "$#,###,##0.00";
this.cellExport1.DataFormats.DateTime = "yyyy-M-d";
this.cellExport1.DataFormats.Float = "#,###,##0.00";
this.cellExport1.DataFormats.Integer = "#,###,##0";
this.cellExport1.DataFormats.Time = "H:mm";
this.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport1.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport1.SheetOptions.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.Gray40Percent;
this.cellExport1.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial";
workSheet1.AutoFitColWidth = true;
workSheet1.CustomFormats.AddRange(new object[] {
"OnHand=#,##0",
"OnOrder=#,##0",
"Cost=#,##0.0000;-#,##0.0000"});
columnFormat1.FieldName = "ListPrice";
columnFormat1.Font.Name = "Arial";
columnFormat1.Width = 8;
workSheet1.ColumnFormats.Add(columnFormat1);
workSheet1.FormatsExport.CultureName = "zh-CN";
workSheet1.FormatsExport.Currency = "гд#,###,##0.00";
workSheet1.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet1.FormatsExport.Float = "#,###,##0.00";
workSheet1.FormatsExport.Integer = "#,###,##0";
workSheet1.FormatsExport.Time = "H:mm";
stripStyle1.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle1.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle1.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle1.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle1.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightGreen;
stripStyle1.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle1.Font.Name = "Arial";
stripStyle2.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle2.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle2.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle2.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle2.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
stripStyle2.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle2.Font.Name = "Arial";
workSheet1.ItemStyles.Add(stripStyle1);
workSheet1.ItemStyles.Add(stripStyle2);
workSheet1.ItemType = Spire.DataExport.XLS.CellItemType.Row;
workSheet1.Options.AggregateFormat.Font.Name = "Arial";
workSheet1.Options.CustomDataFormat.Font.Name = "Arial";
workSheet1.Options.DefaultFont.Name = "Arial";
workSheet1.Options.FooterFormat.Font.Name = "Arial";
workSheet1.Options.HeaderFormat.Font.Name = "Arial";
workSheet1.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet1.Options.HyperlinkFormat.Font.Name = "Arial";
workSheet1.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet1.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet1.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet1.Options.NoteFormat.Font.Bold = true;
workSheet1.Options.NoteFormat.Font.Name = "Tahoma";
workSheet1.Options.NoteFormat.Font.Size = 8F;
workSheet1.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet1.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet1.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet1.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet1.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet1.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet1.Options.TitlesFormat.Font.Bold = true;
workSheet1.Options.TitlesFormat.Font.Name = "Arial";
workSheet1.SheetName = "Parts";
workSheet1.SQLCommand = this.oleDbCommand1;
workSheet1.StartDataCol = ((System.Byte)(0));
workSheet2.AutoFitColWidth = true;
workSheet2.CustomFormats.AddRange(new object[] {
"HireDate=yyyy-MM-dd"});
workSheet2.FormatsExport.CultureName = "zh-CN";
workSheet2.FormatsExport.Currency = "гд#,###,##0.00";
workSheet2.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet2.FormatsExport.Float = "#,###,##0.00";
workSheet2.FormatsExport.Integer = "#,###,##0";
workSheet2.FormatsExport.Time = "H:mm";
stripStyle3.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle3.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle3.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle3.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle3.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightGreen;
stripStyle3.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle3.Font.Name = "Arial";
stripStyle4.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle4.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle4.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle4.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle4.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
stripStyle4.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle4.Font.Name = "Arial";
workSheet2.ItemStyles.Add(stripStyle3);
workSheet2.ItemStyles.Add(stripStyle4);
workSheet2.ItemType = Spire.DataExport.XLS.CellItemType.Col;
workSheet2.Options.AggregateFormat.Font.Name = "Arial";
workSheet2.Options.CustomDataFormat.Font.Name = "Arial";
workSheet2.Options.DefaultFont.Name = "Arial";
workSheet2.Options.FooterFormat.Font.Name = "Arial";
workSheet2.Options.HeaderFormat.Font.Name = "Arial";
workSheet2.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet2.Options.HyperlinkFormat.Font.Name = "Arial";
workSheet2.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet2.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet2.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet2.Options.NoteFormat.Font.Bold = true;
workSheet2.Options.NoteFormat.Font.Name = "Tahoma";
workSheet2.Options.NoteFormat.Font.Size = 8F;
workSheet2.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet2.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet2.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet2.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet2.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet2.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet2.Options.TitlesFormat.Font.Bold = true;
workSheet2.Options.TitlesFormat.Font.Name = "Arial";
workSheet2.SheetName = "Orders";
workSheet2.SQLCommand = this.oleDbCommand2;
workSheet2.StartDataCol = ((System.Byte)(0));
this.cellExport1.Sheets.Add(workSheet1);
this.cellExport1.Sheets.Add(workSheet2);
this.cellExport1.GetDataParams += new Spire.DataExport.Delegates.DataParamsEventHandler(this.cellExport1_GetDataParams);
//
// cellExport2
//
this.cellExport2.DataFormats.CultureName = "zh-CN";
this.cellExport2.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport2.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport2.DataFormats.Float = "#,###,##0.00";
this.cellExport2.DataFormats.Integer = "#,###,##0";
this.cellExport2.DataFormats.Time = "H:mm";
this.cellExport2.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport2.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport2.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport2.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport2.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport2.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport2.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport2.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport2.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport2.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport2.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport2.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport2.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport2.SheetOptions.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.Gray40Percent;
this.cellExport2.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport2.SheetOptions.TitlesFormat.Font.Name = "Arial";
columnFormat2.FieldName = "PartNo";
columnFormat2.Font.Bold = true;
columnFormat2.Font.Name = "Arial";
columnFormat3.FieldName = "VendorNo";
columnFormat3.Font.Color = Spire.DataExport.XLS.CellColor.Color1;
columnFormat3.Font.Italic = true;
columnFormat3.Font.Name = "Arial";
columnFormat4.FieldName = "Description";
columnFormat4.Font.Name = "Arial";
columnFormat4.Font.Strikeout = true;
columnFormat4.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.DoubleAccounting;
columnFormat5.FieldName = "OnHand";
columnFormat5.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
columnFormat5.FillStyle.Foreground = Spire.DataExport.XLS.CellColor.Pink;
columnFormat5.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.ThinGorizontal;
columnFormat5.Font.Name = "Arial";
columnFormat6.FieldName = "ListPrice";
columnFormat6.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
columnFormat6.FillStyle.Foreground = Spire.DataExport.XLS.CellColor.SkyBlue;
columnFormat6.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.ThinVertical;
columnFormat6.Font.Name = "Arial";
workSheet3.ColumnFormats.Add(columnFormat2);
workSheet3.ColumnFormats.Add(columnFormat3);
workSheet3.ColumnFormats.Add(columnFormat4);
workSheet3.ColumnFormats.Add(columnFormat5);
workSheet3.ColumnFormats.Add(columnFormat6);
workSheet3.FormatsExport.CultureName = "zh-CN";
workSheet3.FormatsExport.Currency = "гд#,###,##0.00";
workSheet3.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet3.FormatsExport.Float = "#,###,##0.00";
workSheet3.FormatsExport.Integer = "#,###,##0";
workSheet3.FormatsExport.Time = "H:mm";
workSheet3.Options.AggregateFormat.Font.Name = "Arial";
workSheet3.Options.CustomDataFormat.Font.Name = "Arial";
workSheet3.Options.DefaultFont.Name = "Arial";
workSheet3.Options.FooterFormat.Font.Name = "Arial";
workSheet3.Options.HeaderFormat.Font.Name = "Arial";
workSheet3.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet3.Options.HyperlinkFormat.Font.Name = "Arial";
workSheet3.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet3.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet3.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet3.Options.NoteFormat.Font.Bold = true;
workSheet3.Options.NoteFormat.Font.Name = "Tahoma";
workSheet3.Options.NoteFormat.Font.Size = 8F;
workSheet3.Options.TitlesFormat.Font.Bold = true;
workSheet3.Options.TitlesFormat.Font.Name = "Arial";
workSheet3.SheetName = "Sheet 1";
workSheet3.SQLCommand = this.oleDbCommand1;
workSheet3.StartDataCol = ((System.Byte)(0));
this.cellExport2.Sheets.Add(workSheet3);
//
// cellExport3
//
this.cellExport3.DataFormats.CultureName = "zh-CN";
this.cellExport3.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport3.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport3.DataFormats.Float = "#,###,##0.00";
this.cellExport3.DataFormats.Integer = "#,###,##0";
this.cellExport3.DataFormats.Time = "H:mm";
cellPicture1.FileName = Server.MapPath("Images/sample.gif");
cellPicture1.Name = "Picture_0";
this.cellExport3.Pictures.Add(cellPicture1);
this.cellExport3.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport3.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport3.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport3.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport3.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport3.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport3.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport3.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport3.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport3.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport3.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport3.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport3.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport3.SheetOptions.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.Gray40Percent;
this.cellExport3.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport3.SheetOptions.TitlesFormat.Font.Name = "Arial";
workSheet4.DataExported = false;
workSheet4.FormatsExport.CultureName = "zh-CN";
workSheet4.FormatsExport.Currency = "гд#,###,##0.00";
workSheet4.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet4.FormatsExport.Float = "#,###,##0.00";
workSheet4.FormatsExport.Integer = "#,###,##0";
workSheet4.FormatsExport.Time = "H:mm";
cellImage1.Column = 1;
cellImage1.PictureName = "Picture_0";
cellImage1.Row = 1;
cellImage1.Title = "Image_0";
cellImage2.Column = 1;
cellImage2.PictureName = "Picture_0";
cellImage2.Row = 16;
cellImage2.Title = "Image_1";
workSheet4.Images.Add(cellImage1);
workSheet4.Images.Add(cellImage2);
workSheet4.ItemType = Spire.DataExport.XLS.CellItemType.Col;
workSheet4.Options.AggregateFormat.Font.Name = "Arial";
workSheet4.Options.CustomDataFormat.Font.Name = "Arial";
workSheet4.Options.DefaultFont.Name = "Arial";
workSheet4.Options.FooterFormat.Font.Name = "Arial";
workSheet4.Options.HeaderFormat.Font.Name = "Arial";
workSheet4.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet4.Options.HyperlinkFormat.Font.Name = "Arial";
workSheet4.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet4.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet4.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet4.Options.NoteFormat.Font.Bold = true;
workSheet4.Options.NoteFormat.Font.Name = "Tahoma";
workSheet4.Options.NoteFormat.Font.Size = 8F;
workSheet4.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet4.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet4.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet4.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet4.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet4.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet4.Options.TitlesFormat.Font.Bold = true;
workSheet4.Options.TitlesFormat.Font.Name = "Arial";
workSheet4.SheetName = "Parts";
workSheet4.StartDataCol = ((System.Byte)(0));
this.cellExport3.Sheets.Add(workSheet4);
//
// cellExport5
//
this.cellExport5.DataExported = false;
this.cellExport5.DataFormats.CultureName = "zh-CN";
this.cellExport5.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport5.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport5.DataFormats.Float = "#,###,##0.00";
this.cellExport5.DataFormats.Integer = "#,###,##0";
this.cellExport5.DataFormats.Time = "H:mm";
this.cellExport5.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport5.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport5.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport5.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport5.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport5.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport5.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport5.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport5.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport5.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport5.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport5.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport5.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport5.SheetOptions.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.Gray40Percent;
this.cellExport5.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport5.SheetOptions.TitlesFormat.Font.Name = "Arial";
//
// cellExport6
//
this.cellExport6.DataFormats.CultureName = "zh-CN";
this.cellExport6.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport6.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport6.DataFormats.Float = "#,###,##0.00";
this.cellExport6.DataFormats.Integer = "#,###,##0";
this.cellExport6.DataFormats.Time = "H:mm";
this.cellExport6.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport6.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport6.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport6.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport6.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport6.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport6.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport6.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport6.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport6.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport6.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport6.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport6.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport6.SheetOptions.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.Gray40Percent;
this.cellExport6.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport6.SheetOptions.TitlesFormat.Font.Name = "Arial";
workSheet5.AutoFitColWidth = true;
chart1.CategoryLabelsColumn = "PartNo";
chart1.DataRangeSheet = "";
chart1.Position.AutoPosition.Placement = Spire.DataExport.XLS.ChartPlacement.Right;
chartSeries1.DataColumn = "ListPrice";
chartSeries1.DataRangeSheet = "";
chart1.Series.Add(chartSeries1);
chart1.Style = Spire.DataExport.XLS.ChartStyle.Pie3d;
workSheet5.Charts.Add(chart1);
workSheet5.FormatsExport.CultureName = "zh-CN";
workSheet5.FormatsExport.Currency = "гд#,###,##0.00";
workSheet5.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet5.FormatsExport.Float = "#,###,##0.00";
workSheet5.FormatsExport.Integer = "#,###,##0";
workSheet5.FormatsExport.Time = "H:mm";
stripStyle5.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle5.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle5.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle5.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle5.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightGreen;
stripStyle5.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle5.Font.Name = "Arial";
stripStyle6.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle6.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle6.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle6.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle6.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
stripStyle6.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle6.Font.Name = "Arial";
workSheet5.ItemStyles.Add(stripStyle5);
workSheet5.ItemStyles.Add(stripStyle6);
workSheet5.ItemType = Spire.DataExport.XLS.CellItemType.Col;
workSheet5.Options.AggregateFormat.Font.Name = "Arial";
workSheet5.Options.CustomDataFormat.Font.Name = "Arial";
workSheet5.Options.DefaultFont.Name = "Arial";
workSheet5.Options.FooterFormat.Font.Name = "Arial";
workSheet5.Options.HeaderFormat.Font.Name = "Arial";
workSheet5.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet5.Options.HyperlinkFormat.Font.Name = "Arial";
workSheet5.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet5.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet5.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet5.Options.NoteFormat.Font.Bold = true;
workSheet5.Options.NoteFormat.Font.Name = "Tahoma";
workSheet5.Options.NoteFormat.Font.Size = 8F;
workSheet5.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet5.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet5.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet5.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet5.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet5.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet5.Options.TitlesFormat.Font.Bold = true;
workSheet5.Options.TitlesFormat.Font.Name = "Arial";
workSheet5.SheetName = "Parts";
workSheet5.SQLCommand = this.oleDbCommand1;
workSheet5.StartDataCol = ((System.Byte)(0));
this.cellExport6.Sheets.Add(workSheet5);
//
// cellExport7
//
this.cellExport7.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.cellExport7.AutoFitColWidth = true;
this.cellExport7.DataFormats.CultureName = "zh-CN";
this.cellExport7.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport7.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport7.DataFormats.Float = "#,###,##0.00";
this.cellExport7.DataFormats.Integer = "#,###,##0";
this.cellExport7.DataFormats.Time = "H:mm";
this.cellExport7.FileName = "chart2.xls";
this.cellExport7.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport7.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport7.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport7.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport7.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport7.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport7.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport7.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport7.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport7.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport7.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport7.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport7.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport7.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport7.SheetOptions.TitlesFormat.Font.Name = "Arial";
chart2.AutoColor = false;
chart2.CategoryLabels.ColX = ((System.Byte)(1));
chart2.CategoryLabels.ColY = ((System.Byte)(1));
chart2.CategoryLabels.RowX = 1;
chart2.CategoryLabels.RowY = 9;
chart2.CategoryLabelsColumn = "PartNo";
chart2.DataRangeSheet = "Sheet 2";
chart2.Position.AutoPosition.Height = 23;
chart2.Position.AutoPosition.Left = 1;
chart2.Position.AutoPosition.Top = 1;
chart2.Position.AutoPosition.Width = 11;
chart2.Position.CustomPosition.X1 = ((System.Byte)(1));
chart2.Position.CustomPosition.X2 = ((System.Byte)(15));
chart2.Position.CustomPosition.Y1 = 1;
chart2.Position.CustomPosition.Y2 = 30;
chartSeries2.Color = Spire.DataExport.XLS.CellColor.Tan;
chartSeries2.DataColumn = "Cost";
chartSeries2.DataRangeSheet = "Sheet 2";
chartSeries2.Title = "Cost";
chart2.Series.Add(chartSeries2);
chart2.Style = Spire.DataExport.XLS.ChartStyle.Bar;
chart2.Title = "Chart demo";
workSheet6.Charts.Add(chart2);
workSheet6.DataExported = false;
workSheet6.FormatsExport.CultureName = "zh-CN";
workSheet6.FormatsExport.Currency = "гд#,###,##0.00";
workSheet6.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet6.FormatsExport.Float = "#,###,##0.00";
workSheet6.FormatsExport.Integer = "#,###,##0";
workSheet6.FormatsExport.Time = "H:mm";
workSheet6.Options.AggregateFormat.Font.Name = "Arial";
workSheet6.Options.CustomDataFormat.Font.Name = "Arial";
workSheet6.Options.DefaultFont.Name = "Arial";
workSheet6.Options.FooterFormat.Font.Name = "Arial";
workSheet6.Options.HeaderFormat.Font.Bold = true;
workSheet6.Options.HeaderFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet6.Options.HeaderFormat.Font.Name = "Arial";
workSheet6.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet6.Options.HyperlinkFormat.Font.Name = "Arial";
workSheet6.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet6.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet6.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet6.Options.NoteFormat.Font.Bold = true;
workSheet6.Options.NoteFormat.Font.Name = "Tahoma";
workSheet6.Options.NoteFormat.Font.Size = 8F;
workSheet6.Options.TitlesFormat.Font.Bold = true;
workSheet6.Options.TitlesFormat.Font.Name = "Times New Roman";
workSheet6.Options.TitlesFormat.Font.Size = 13F;
workSheet6.SheetName = "charts";
workSheet6.StartDataCol = ((System.Byte)(0));
workSheet7.AutoFitColWidth = true;
workSheet7.FormatsExport.CultureName = "zh-CN";
workSheet7.FormatsExport.Currency = "гд#,###,##0.00";
workSheet7.FormatsExport.DateTime = "yyyy-M-d H:mm";
workSheet7.FormatsExport.Float = "#,###,##0.00";
workSheet7.FormatsExport.Integer = "#,###,##0";
workSheet7.FormatsExport.Time = "H:mm";
stripStyle7.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle7.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle7.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle7.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle7.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightGreen;
stripStyle7.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle7.Font.Name = "Arial";
stripStyle8.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle8.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle8.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle8.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
stripStyle8.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightTurquoise;
stripStyle8.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
stripStyle8.Font.Name = "Arial";
workSheet7.ItemStyles.Add(stripStyle7);
workSheet7.ItemStyles.Add(stripStyle8);
workSheet7.ItemType = Spire.DataExport.XLS.CellItemType.Col;
workSheet7.Options.AggregateFormat.Font.Name = "Arial";
workSheet7.Options.CustomDataFormat.Font.Name = "Arial";
workSheet7.Options.DefaultFont.Name = "Arial";
workSheet7.Options.FooterFormat.Font.Name = "Arial";
workSheet7.Options.HeaderFormat.Font.Name = "Arial";
workSheet7.Options.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
workSheet7.Options.HyperlinkFormat.Font.Name = "Arial";
workSheet7.Options.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
workSheet7.Options.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
workSheet7.Options.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
workSheet7.Options.NoteFormat.Font.Bold = true;
workSheet7.Options.NoteFormat.Font.Name = "Tahoma";
workSheet7.Options.NoteFormat.Font.Size = 8F;
workSheet7.Options.TitlesFormat.Borders.Bottom.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet7.Options.TitlesFormat.Borders.Left.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet7.Options.TitlesFormat.Borders.Right.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet7.Options.TitlesFormat.Borders.Top.Style = Spire.DataExport.XLS.CellBorderStyle.Medium;
workSheet7.Options.TitlesFormat.FillStyle.Background = Spire.DataExport.XLS.CellColor.LightYellow;
workSheet7.Options.TitlesFormat.FillStyle.Pattern = Spire.DataExport.XLS.Pattern.Solid;
workSheet7.Options.TitlesFormat.Font.Bold = true;
workSheet7.Options.TitlesFormat.Font.Name = "Arial";
workSheet7.SheetName = "Sheet 2";
workSheet7.SQLCommand = this.oleDbCommand1;
workSheet7.StartDataCol = ((System.Byte)(0));
this.cellExport7.Sheets.Add(workSheet6);
this.cellExport7.Sheets.Add(workSheet7);
this.cellExport7.SQLCommand = this.oleDbCommand1;
this.cellExport7.GetDataParams += new Spire.DataExport.Delegates.DataParamsEventHandler(this.cellExport1_GetDataParams);
//
// cellExport8
//
this.cellExport8.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.cellExport8.ColumnsWidth.AddRange(new object[] {
"100",
"200"});
this.cellExport8.DataExported = false;
this.cellExport8.DataFormats.CultureName = "zh-CN";
this.cellExport8.DataFormats.Currency = "гд#,###,##0.00";
this.cellExport8.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport8.DataFormats.Float = "#,###,##0.00";
this.cellExport8.DataFormats.Integer = "#,###,##0";
this.cellExport8.DataFormats.Time = "H:mm";
this.cellExport8.FileName = "formula.xls";
this.cellExport8.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport8.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport8.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport8.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport8.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport8.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport8.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport8.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport8.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport8.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport8.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport8.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport8.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport8.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport8.SheetOptions.TitlesFormat.Font.Name = "Arial";
this.cellExport8.SQLCommand = this.oleDbCommand1;
}
