C# Workbook.CreateEmptySheets方法代码示例

        private void btnRead_Click(object sender, RoutedEventArgs e)
        {
            Workbook workbook = new Workbook();

            //Initailize worksheet
            workbook.CreateEmptySheets(1);
            Worksheet sheet = workbook.Worksheets[0];
            sheet.Name = "Chart data";
            sheet.GridLinesVisible = false;

            //Writes chart data
            CreateChartData(sheet);
            //Add a new  chart worsheet to workbook
            Chart chart = sheet.Charts.Add();

            //Set region of chart data
            chart.DataRange = sheet.Range["A1:C5"];
            chart.SeriesDataFromRange = false;

            //Set position of chart
            chart.LeftColumn = 1;
            chart.TopRow = 7;
            chart.RightColumn = 11;
            chart.BottomRow = 30;
            
            if (chk3D.IsChecked==true)
            {
                chart.ChartType = ExcelChartType.Area3D;
            }
            else
            {
                chart.ChartType = ExcelChartType.Area;
            }

            //Chart title area
            chart.ChartTitle = "Sales market by country";
            chart.ChartTitleArea.IsBold = true;
            chart.ChartTitleArea.Size = 12;

            chart.PrimaryCategoryAxis.Title = "Country";
            chart.PrimaryCategoryAxis.Font.IsBold = true;
            chart.PrimaryCategoryAxis.TitleArea.IsBold = true;

            chart.PrimaryValueAxis.Title = "Sales(in Dollars)";
            chart.PrimaryValueAxis.HasMajorGridLines = true;
            chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90;
            chart.PrimaryValueAxis.MinValue = 1000;
            chart.PrimaryValueAxis.TitleArea.IsBold = true;

            foreach (Spire.Xls.Charts.ChartSerie cs in chart.Series)
            {
                cs.Format.Options.IsVaryColor = true;
                cs.DataPoints.DefaultDataPoint.DataLabels.HasValue = true;
            }

            chart.Legend.Position = LegendPositionType.Top;
            workbook.SaveToFile("Sample.xls");
            ExcelDocViewer(workbook.FileName);
        }

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.Name = "Chart data";
			sheet.GridLinesVisible = false;

			//Writes chart data
			CreateChartData(sheet);
            //Add a new  chart worsheet to workbook
			Chart chart = sheet.Charts.Add();

			//Set region of chart data
			chart.DataRange = sheet.Range["B1:B5"];
			chart.SeriesDataFromRange = false;

			//Set position of chart
			chart.LeftColumn = 1;
			chart.TopRow = 6;
			chart.RightColumn = 11;
			chart.BottomRow = 29;


			if (checkBox1.Checked)
			{
				chart.ChartType =  ExcelChartType.Cylinder3DClustered;
			}
			else
			{
				chart.ChartType = ExcelChartType.CylinderClustered;
			}

            //Chart title
			chart.ChartTitle = "Sales by year";
			chart.ChartTitleArea.IsBold = true;
			chart.ChartTitleArea.Size = 12;

			chart.PrimaryCategoryAxis.Title = "Year";
			chart.PrimaryCategoryAxis.Font.IsBold = true;
			chart.PrimaryCategoryAxis.TitleArea.IsBold = true;

			chart.PrimaryValueAxis.Title = "Sales(in Dollars)";
			chart.PrimaryValueAxis.HasMajorGridLines = false;
            chart.PrimaryValueAxis.MinValue = 1000;
			chart.PrimaryValueAxis.TitleArea.IsBold = true;
			chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90;



            Charts.ChartSerie cs = chart.Series[0];
			cs.CategoryLabels = sheet.Range["A2:A5"];

			chart.Legend.Position = LegendPositionType.Top;
			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.GridLinesVisible = false;

			//Writes Sample data
			CreateSampleData(sheet);

			sheet.GroupByRows(1,5,false);
			sheet.GroupByColumns(1,3,false);

			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.GridLinesVisible = false;

			//Writes filter data
			CreateFilterData(sheet);

			sheet.AutoFilters.Range = sheet.Range["A1:C1"];

			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];

			//Protect workshet
			sheet.Protect( this.textBox1.Text );

			//Protect cells
			sheet.Range["A1"].Text = "Locked";
			sheet.Range["B1"].Text = "Unlocked";

			sheet.Range["A1"].Style.Locked = true;
			sheet.Range["B1"].Style.Locked = false;

      //Protect workbook
      workbook.Protect(this.textBox1.Text);
			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.Name = "Chart data";
			sheet.GridLinesVisible = false;

			//Add a new  chart worsheet to workbook
			Chart chart = sheet.Charts.Add();

			CreateChartData(sheet);
			CreateChart(sheet, chart);

			chart.ChartType = ExcelChartType.ScatterMarkers;

			chart.Legend.Position = LegendPositionType.Top;
			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();

			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.Name = "Chart data";
			sheet.GridLinesVisible = false;

			//Add a new  chart worsheet to workbook
			Chart chart = null;
			if (checkBox1.Checked)
			{
				chart = sheet.Charts.Add(ExcelChartType.Pie3DExploded);
			}
			else
			{
				chart = sheet.Charts.Add(ExcelChartType.PieExploded);
			}

			CreateChartData(sheet);
			CreateChart(sheet, chart);

			chart.PlotArea.Fill.Visible = false;

			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();

			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.Name = "Chart data";
			sheet.GridLinesVisible = false;

			//Add a new  chart worsheet to workbook
			Chart chart = sheet.Charts.Add();

			if (checkBox1.Checked)
			{
				CreateStackedChartData(sheet);
				CreateStackedColumnChart(sheet, chart);
				chart.ChartType = ExcelChartType.CylinderBarStacked;

			}
			else
			{
				CreateChartData(sheet);
				CreateColumnChart(sheet, chart);
				chart.ChartType =  ExcelChartType.CylinderBarClustered;
			}


			chart.Legend.Position = LegendPositionType.Top;
			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.GridLinesVisible = false;

			//Writes sample data
			CreateSampleData(sheet);

			//Sets page setup properties
			sheet.PageSetup.Orientation = PageOrientationType.Landscape;
			sheet.PageSetup.PaperSize = PaperSizeType.PaperA3;

			//Sets page break
			sheet.VPageBreaks.Add(sheet.Range["A5"]);
			sheet.HPageBreaks.Add(sheet.Range["C6"]);

			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();

			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.Name = "Chart data";
			sheet.GridLinesVisible = false;

			//Writes chart data
			CreateChartData(sheet);
            //Add a new  chart worsheet to workbook
			Chart chart = sheet.Charts.Add();

			//Set region of chart data
			chart.DataRange = sheet.Range["A1:C5"];
			chart.SeriesDataFromRange = false;

			//Set position of chart
			chart.LeftColumn = 1;
			chart.TopRow = 6;
			chart.RightColumn = 11;
			chart.BottomRow = 29;


			chart.ChartType =  ExcelChartType.Doughnut;

            //Chart title
			chart.ChartTitle = "Sales market by country";
			chart.ChartTitleArea.IsBold = true;
			chart.ChartTitleArea.Size = 12;

            foreach (Charts.ChartSerie cs in chart.Series)
            {
                cs.Format.Options.IsVaryColor = true;
                cs.DataPoints.DefaultDataPoint.DataLabels.HasValue = true;
            }

            chart.PlotArea.Fill.Visible = false;

			chart.Legend.Position = LegendPositionType.Top;
			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.SetColumnWidth(1,25);

			//Creates font
			ExcelFont fontBlue = workbook.CreateFont();
			fontBlue.KnownColor = ExcelColors.LightBlue;
			ExcelFont fontGreen = workbook.CreateFont();
			fontGreen.KnownColor = ExcelColors.Red;

			CellRange range = sheet.Range["A1"];
			range.Text = "Regular comment";
			range.Comment.Text = "Regular comment";

			//Regular comment
			range = sheet.Range["A2"];
			range.Text = "Rich text comment";

			//Rich text comment
			range.Comment.RichText.Text = "Rich text comment";
			range.Comment.RichText.SetFont(0,4, fontGreen);
			range.Comment.RichText.SetFont(5,9, fontBlue);

			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer( workbook.FileName );
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();

			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.Name = "Chart data";
			sheet.GridLinesVisible = false;

			//Writes chart data
			CreateChartData(sheet);
            //Add a new  chart worsheet to workbook
			Chart chart = sheet.Charts.Add();

			//Set position of chart
			chart.LeftColumn = 1;
			chart.TopRow = 6;
			chart.RightColumn = 11;
			chart.BottomRow = 29;

			//Set region of chart data
			chart.DataRange = sheet.Range["A1:C5"];
			chart.SeriesDataFromRange = false;

			if (checkBox1.Checked)
			{
				chart.ChartType =  ExcelChartType.RadarMarkers;
			}
			else
			{
				chart.ChartType = ExcelChartType.Radar;
			}

            //Chart title
			chart.ChartTitle = "Sale market by region";
			chart.ChartTitleArea.IsBold = true;
			chart.ChartTitleArea.Size = 12;

			chart.PlotArea.Fill.Visible = false;

			chart.Legend.Position = LegendPositionType.Corner;
			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.Name = "Chart data";

			//Writes chart data
			CreateChartData(sheet);
            //Add a new  chart worsheet to workbook
			ChartSheet chartsheet = workbook.Charts.Add("chart worksheet");
			//Set region of chart data
			chartsheet.DataRange = sheet.Range["A1:B5"];
			chartsheet.SeriesDataFromRange = false;

            //Chart title
			chartsheet.ChartTitle = "Sales market by country";
			chartsheet.ChartTitleArea.IsBold = true;
			chartsheet.ChartTitleArea.Size = 12;

			chartsheet.PrimaryCategoryAxis.Title = "Country";
			chartsheet.PrimaryCategoryAxis.Font.IsBold = true;
			chartsheet.PrimaryCategoryAxis.TitleArea.IsBold = true;

			chartsheet.PrimaryValueAxis.Title = "Sales(in Dollars)";
			chartsheet.PrimaryValueAxis.HasMajorGridLines = false;
			chartsheet.PrimaryValueAxis.TitleArea.TextRotationAngle = 90;
            chartsheet.PrimaryValueAxis.MinValue = 1000;
			chartsheet.PrimaryValueAxis.TitleArea.IsBold = true;


            foreach (Charts.ChartSerie cs in chartsheet.Series)
            {
			    cs.Format.Options.IsVaryColor = true;
			    cs.DataPoints.DefaultDataPoint.DataLabels.HasValue = true;
            }

			chartsheet.Legend.Position = LegendPositionType.Top;
			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
			
			//Initailize worksheet
			workbook.CreateEmptySheets(1);
			Worksheet sheet = workbook.Worksheets[0];
			sheet.Name = "Chart data";
			sheet.GridLinesVisible = false;

			//Writes chart data
			CreateChartData(sheet);
            //Add a new  chart worsheet to workbook
			Chart chart = sheet.Charts.Add();
			if (checkBox1.Checked)
			{
				chart.ChartType = ExcelChartType.LineMarkers100PercentStacked;
			}
			else
			{
				chart.ChartType = ExcelChartType.Line100PercentStacked;
			}

			//Set region of chart data
			chart.DataRange = sheet.Range["A1:E5"];

			//Set position of chart
			chart.LeftColumn = 1;
			chart.TopRow = 6;
			chart.RightColumn = 11;
			chart.BottomRow = 29;


            //Chart title
			chart.ChartTitle = "Sales market by country";
			chart.ChartTitleArea.IsBold = true;
			chart.ChartTitleArea.Size = 12;

			chart.PrimaryCategoryAxis.Title = "Month";
			chart.PrimaryCategoryAxis.Font.IsBold = true;
			chart.PrimaryCategoryAxis.TitleArea.IsBold = true;

			chart.PrimaryValueAxis.Title = "Sales(%)";
			chart.PrimaryValueAxis.HasMajorGridLines = false;
			chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90;
			chart.PrimaryValueAxis.TitleArea.IsBold = true;

            foreach (Charts.ChartSerie cs in chart.Series)
            {
                cs.Format.Options.IsVaryColor = true;
                cs.DataPoints.DefaultDataPoint.DataLabels.HasValue = true;
            }

			chart.Legend.Position = LegendPositionType.Top;
			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

        private void btnRun_Click(object sender, System.EventArgs e)
        {
            Workbook workbook = new Workbook();
            workbook.Version = ExcelVersion.Version2010;
            workbook.CreateEmptySheets(1);

            Worksheet sheet = workbook.Worksheets[0];

            //Country
            sheet.Range["A1"].Value = "Country";
            sheet.Range["A2"].Value = "Cuba";
            sheet.Range["A3"].Value = "Mexico";
            sheet.Range["A4"].Value = "France";
            sheet.Range["A5"].Value = "German";

            //Jun
            sheet.Range["B1"].Value = "Jun";
            sheet.Range["B2"].NumberValue = 0.23;
            sheet.Range["B3"].NumberValue = 0.37;
            sheet.Range["B4"].NumberValue = 0.15;
            sheet.Range["B5"].NumberValue = 0.25;

            //Jul
            sheet.Range["C1"].Value = "Jul";
            sheet.Range["C2"].NumberValue = 0.1;
            sheet.Range["C3"].NumberValue = 0.35;
            sheet.Range["C4"].NumberValue = 0.22;
            sheet.Range["C5"].NumberValue = 0.33;


            //Aug
            sheet.Range["D1"].Value = "Aug";
            sheet.Range["D2"].NumberValue = 0.14;
            sheet.Range["D3"].NumberValue = 0.36;
            sheet.Range["D4"].NumberValue = 0.25;
            sheet.Range["D5"].NumberValue = 0.25;


            //Aug
            sheet.Range["E1"].Value = "Sep";
            sheet.Range["E2"].NumberValue = 0.17;
            sheet.Range["E3"].NumberValue = 0.28;
            sheet.Range["E4"].NumberValue = 0.39;
            sheet.Range["E5"].NumberValue = 0.32;

            //Style
            sheet.Range["A1:E1"].Style.Font.IsBold = true;
            sheet.Range["A2:E2"].Style.KnownColor = ExcelColors.LightYellow;
            sheet.Range["A3:E3"].Style.KnownColor = ExcelColors.LightGreen1;
            sheet.Range["A4:E4"].Style.KnownColor = ExcelColors.LightOrange;
            sheet.Range["A5:E5"].Style.KnownColor = ExcelColors.LightTurquoise;

            //Border
            sheet.Range["A1:E5"].Style.Borders[BordersLineType.EdgeTop].Color = Color.FromArgb(0, 0, 128);
            sheet.Range["A1:E5"].Style.Borders[BordersLineType.EdgeTop].LineStyle = LineStyleType.Thin;
            sheet.Range["A1:E5"].Style.Borders[BordersLineType.EdgeBottom].Color = Color.FromArgb(0, 0, 128);
            sheet.Range["A1:E5"].Style.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.Thin;
            sheet.Range["A1:E5"].Style.Borders[BordersLineType.EdgeLeft].Color = Color.FromArgb(0, 0, 128);
            sheet.Range["A1:E5"].Style.Borders[BordersLineType.EdgeLeft].LineStyle = LineStyleType.Thin;
            sheet.Range["A1:E5"].Style.Borders[BordersLineType.EdgeRight].Color = Color.FromArgb(0, 0, 128);
            sheet.Range["A1:E5"].Style.Borders[BordersLineType.EdgeRight].LineStyle = LineStyleType.Thin;

            sheet.Range["B2:D5"].Style.NumberFormatIndex = 9;

            SparklineGroup sparklineGroup
                = sheet.SparklineGroups.AddGroup(SparklineType.Line);
            SparklineCollection sparklines = sparklineGroup.Add();
            sparklines.Add(sheet["B2:E2"], sheet["F2"]);
            sparklines.Add(sheet["B3:E3"], sheet["F3"]);
            sparklines.Add(sheet["B4:E4"], sheet["F4"]);
            sparklines.Add(sheet["B5:E5"], sheet["F5"]);

            workbook.SaveToFile("Sample.xlsx");

            ExcelDocViewer(workbook.FileName);
        }