Step 3: Add the following codes to the method.
C#
private void button1_Click(object sender, EventArgs e)
{
Workbook workbook = new Workbook();
//Initialize worksheet
workbook.LoadFromFile("../../../../../../Data/EditChartSample.xls", true);
Worksheet sheet = workbook.Worksheets[0];
//Writes chart data
CreateChartData(sheet);
workbook.SaveToFile("Sample.xls");
ExcelDocViewer(workbook.FileName);
}
private void CreateChartData(Worksheet sheet)
{
//Jun
sheet.Range["F6"].NumberValue = 6000;
sheet.Range["F7"].NumberValue = 8000;
sheet.Range["F8"].NumberValue = 9000;
sheet.Range["F9"].NumberValue = 8500;
//Aug
sheet.Range["G6"].NumberValue = 4000;
sheet.Range["G7"].NumberValue = 7000;
sheet.Range["G8"].NumberValue = 2000;
sheet.Range["G9"].NumberValue = 5000;
sheet.Range["F6:F9"].Style.NumberFormat = "\"$\"#,##0";
sheet.Range["G6:G9"].Style.NumberFormat = "\"$\"#,##0";
}
private void ExcelDocViewer(string fileName)
{
try
{
System.Diagnostics.Process.Start(fileName);
}
catch { }
}
VB.NETPrivate Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click
Dim workbook As Workbook = New Workbook()
'Initialize worksheet
workbook.LoadFromFile("../../../../.././Dat/EditChartSample.xls",True)
Dim sheet As Worksheet = workbook.Worksheets(0)
'Writes chart data
CreateChartData(sheet)
workbook.SaveToFile("Sample.xls")
ExcelDocViewer(workbook.FileName)
End Sub
Private Sub CreateChartData(ByVal sheet As Worksheet)
'Jun
sheet.Range("F6").NumberValue = 6000
sheet.Range("F7").NumberValue = 8000
sheet.Range("F8").NumberValue = 9000
sheet.Range("F9").NumberValue = 8500
'Aug
sheet.Range("G6").NumberValue = 4000
sheet.Range("G7").NumberValue = 7000
sheet.Range("G8").NumberValue = 2000
sheet.Range("G9").NumberValue = 5000
sheet.Range("F6:F9").Style.NumberFormat = """$""#,##0"
sheet.Range("G6:G9").Style.NumberFormat = """$""#,##0"
End Sub
Private Sub ExcelDocViewer(ByVal fileName As String)
Try
System.Diagnostics.Process.Start(fileName)
Catch
End Try
End Sub
Note:If you download the Spire.XLS, you can find the "EditChartSample.xls"
in Spire. XLS profile-Demos-Data- EditChartSample.xls.
Step 4: Run the project Edit Chart Sheet.
Press F5 to run the project, you can see picture 4.1:
4.1
More About Spire. XLS
Spire. XLS, as a professional Excel component, allows its users to operate Excel document directly such as save to stream, save as web response, copy, lock/unlock worksheet, set up workbook properties, etc.