VB.NET to VC#

[Dorothy]

Dim a As New Excel.Application()
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet

wb = a.Workbooks.Open("C:\book1.xls")

ws = wb.Worksheets.Item(1)

With ws
'populate titles
.Cells(1, 1).value = "Date"
.Cells(1, 2).value = "Location"

.Cells(2, 1).value = YOUR STRING VALUE
.Cells(2, 2).value = YOUR STRING VALUE

I need the above code converted to VC#. Can anyone help me with this?

[SoftwareMaker]

I cant really test it now but this is the conversion

static void main
{
Excel.Application a = new Excel.Application;
Excel.Workbook wb = a.Open("C:\book1.xls");
Excel.Worksheet ws = wb.Worksheets.Item(1);

ws.Cells(2, 1).value = "YOUR STRING VALUE";
ws.Cells(2, 2).value = "YOUR STRING VALUE";
}

hth

[Dorothy]

Excel.Application a = new Excel.Application;
Excel.Workbook wb = a.Open ("C:\book1.xls");
Excel.Worksheet ws = wb.Worksheets.Item (1);

ws. Cells (2, 1).value = "YOUR STRING VALUE";
ws. Cells( 2, 2).value = "YOUR STRING VALUE";

I get error on the underlined codes.

[SoftwareMaker]

What is the error and did you set a reference to the excel runtime library ?

[SoftwareMaker]

+++++++++++++
Excel.Application a = new Excel.Application;
Excel.Workbook wb = a.Open ("C:\book1.xls");
Excel.Worksheet ws = wb.Worksheets.Item (1);

ws. Cells (2, 1).value = "YOUR STRING VALUE";
ws. Cells( 2, 2).value = "YOUR STRING VALUE";

I get error on the underlined codes.
+++++++++++++

Try this
=========================
Excel.Application a = new Excel.Application;
Excel.Workbook wb = a.Workbooks.Open (@"C:\book1.xls");
Excel.Worksheet ws = wb.Worksheets.Item [1];

ws.Range("A1").value = "YOUR STRING VALUE";
=========================

Like I said, I dont have a C# compiler to test it right now. If this still doesnt work, post this code snippet in the C# forum and ask for help there