private void btnRun_Click(object sender, System.EventArgs e)
{
Workbook workbook = new Workbook();
//Load workbook from disk.
workbook.LoadFromFile(@"..\..\..\..\..\..\Data\EditSheetSample.xls");
//Initialize worksheet
Worksheet sheet = workbook.Worksheets[0];
//Writes string
sheet.Range["B1"].Text = "Hello,World!";
//Writes number
sheet.Range["B2"].NumberValue = 1234.5678;
//Writes date
sheet.Range["B3"].DateTimeValue = System.DateTime.Now;
//Writes formula
sheet.Range["B4"].Formula = "=1111*11111";
workbook.SaveToFile("Sample.xls");
ExcelDocViewer(workbook.FileName);
}
private void ExcelDocViewer( string fileName )
{
try
{
System.Diagnostics.Process.Start(fileName);
}
catch{}
}
Private Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click
Dim workbook As Workbook = New Workbook()
'Load workbook from disk.
workbook.LoadFromFile("..\..\..\..\..\..\Data\EditSheetSample.xls")
'Initialize worksheet
Dim sheet As Worksheet = workbook.Worksheets(0)
'Writes string
sheet.Range("B1").Text = "Hello,World!"
'Writes number
sheet.Range("B2").NumberValue = 1234.5678
'Writes date
sheet.Range("B3").DateTimeValue = System.DateTime.Now
'Writes formula
sheet.Range("B4").Formula = "=1111*11111"
workbook.SaveToFile("Sample.xls")
ExcelDocViewer(workbook.FileName)
End Sub
Private Sub ExcelDocViewer(ByVal fileName As String)
Try
System.Diagnostics.Process.Start(fileName)
Catch
End Try
End Sub