The sample demonstrates how to write a string to an excel workbook.
private void btnRun_Click(object sender, System.EventArgs e)
{
//Creates workbook
Workbook workbook = new Workbook();
//Gets first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Writes hello world to A1
sheet.Range["A1"].Text = "Hello,World!";
//Save workbook to disk
workbook.SaveToFile("Sample.xls");
//View excel file
ExcelDocViewer(workbook.FileName);
}
private void ExcelDocViewer( string fileName )
{
try
{
System.Diagnostics.Process.Start(fileName);
} catch{}
}
Private Sub ExcelDocViewer(ByVal fileName As String)
Try
System.Diagnostics.Process.Start(fileName)
Catch
End Try
End Sub
Private Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click
'Creates workbook
Dim workbook As Workbook = New Workbook()
'Gets first worksheet
Dim sheet As Worksheet = workbook.Worksheets(0)
'Writes hello world to A1
sheet.Range("A1").Text = "Hello,World!"
'Save workbook to disk
workbook.SaveToFile("Sample.xls")
'View excel file
ExcelDocViewer(workbook.FileName)
End Sub
Private Sub btnAbout_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAbout.Click
Close()
End Sub