...
2. Instantiate the ExcelApplication
object
Csharp |
---|
|
ExcelApplication oXLAPPXLAPP = new ExcelApplication();
|
Vbnet |
---|
|
Dim oXLAPP XLAPP As New ExcelApplication() |
...
3. Create a new workbook with ExcelApplication.Create()
Csharp |
---|
|
Workbook oWBWB = oXLAPPXLAPP.Create(ExcelApplication.FileFormat.Excel2007);
|
Vbnet |
---|
|
Dim oWB WB As Workbook = oXLAPPXLAPP.Create(ExcelApplication.FileFormat.Excel2007) |
...
4. Access the first worksheet through the Workbook.Worksheets
collection
Csharp |
---|
|
Worksheet oWKSTWKST = oWBWB.Worksheets[0];
|
Vbnet |
---|
|
Dim oWKST WKST As Worksheet = oWBWB.Worksheets(0) |
You can access worksheets by name (e.g. "Sheet1") or by index (shown above), but ExcelWriter will throw an exception if you attempt to access a worksheet that does not exist.
...
Csharp |
---|
|
string value = DataValueBox.Text.Trim();
oWKSTWKST.Cells[0,0].Value = value;
|
Vbnet |
---|
|
Dim value As String = DataValueBox.Text.Trim() oWKST WKST.Cells(0, 0).Value = value |
...
6. Save the workbook
Csharp |
---|
|
oXLAPPXLAPP.Save(oWBWB, Page.Response, "Output.xlsx", false);
|
Vbnet |
---|
|
oXLAPPXLAPP.Save(oWBWB, Page.Response, "Output.xlsx", False) |
...
Csharp |
---|
|
using SoftArtisans.OfficeWriter.ExcelWriter;
...
ExcelApplication oXLAPPXLAPP = new ExcelApplication();
ExcelApplication oXLAPPXLAPP = new ExcelApplication();
Worksheet oWKSTWKST = oWBWB.Worksheets[0];
string value = DataValueBox.Text.Trim();
oWKSTWKST.Cells[0,0].Value = value;
oXLAPPXLAPP.Save(oWBWB, Page.Response, "Output.xlsx", false);
|
Vbnet |
---|
|
Include SoftArtisans.OfficeWriter.ExcelWriter ... Dim oXLAPP XLAPP As New ExcelApplication() Dim oWB WB As Workbook = oXLAPPXLAPP.Create(ExcelApplication.FileFormat.Excel2007) Dim oWKST WKST As Worksheet = oWBWB.Worksheets(0) Dim value As String = DataValueBox.Text.Trim() oWKST WKST.Cells(0, 0).Value = value oXLAPP XLAPP.Save(oWBWB, Page.Response, "Output.xlsx", False) |