Hi,
I want to create at least 5 spreadsheets in excel file, could you please tell me how to do it with Spire.XLS for .NET?
thx
//Create a new workbook
Workbook workbook = new Workbook();
//Initialize worksheet
workbook.CreateEmptySheets(1);
Worksheet sheet = workbook.Worksheets[0];
//Year
sheet.Range["A1"].Value = "Year";
sheet.Range["A2"].Value = "2002";
sheet.Range["A3"].Value = "2003";
sheet.Range["A4"].Value = "2004";
sheet.Range["A5"].Value = "2005";
//Sales
sheet.Range["B1"].Value = "Sales";
sheet.Range["B2"].NumberValue = 4000;
sheet.Range["B3"].NumberValue = 6000;
sheet.Range["B4"].NumberValue = 7000;
sheet.Range["B5"].NumberValue = 8500;
//Set sheet name
sheet.Name = "Chart data";
Chart chart = sheet.Charts.Add(ExcelChartType.Pie3D);
chart.DataRange = sheet.Range["B2:B5"];
chart.SeriesDataFromRange = false;
chart.LeftColumn = 1;
chart.TopRow = 6;
chart.RightColumn = 9;
chart.BottomRow = 25;
chart.ChartTitle = "Sales by year";
chart.ChartTitleArea.IsBold = true;
chart.ChartTitleArea.Size = 12;
Spire.Xls.Charts.ChartSerie cs = chart.Series[0];
cs.CategoryLabels = sheet.Range["A2:A5"];
//Add a new chart1
Chart chart1 = sheet.Charts.Add();
chart1.ChartType = ExcelChartType.BarClustered;
//Set region of chart1 data
chart1.DataRange = sheet.Range["B2:B5"];
chart1.SeriesDataFromRange = false;
Spire.Xls.Charts.ChartSerie cs1 = chart1.Series[0];
cs1.CategoryLabels = sheet.Range["A2:A5"];
//Set position of chart1
chart1.LeftColumn = 1;
chart1.TopRow = 30;
chart1.RightColumn = 11;
chart1.BottomRow = 60;
workbook.SaveToFile("result.xlsx", ExcelVersion.Version2010);