Microsoft.Office.Interop.Excel.Application
 

Hi All,


I am using Microsoft.Office.Interop.Excel.Application COM to create a Excel
spreadsheet, and write the value (not from any dataset) into that
spreadsheet, and then StreamWrite to the disk.

For some reason, the following code is not working.

This is the declaration of ws:
Microsoft.Office.Interop.Excel.Worksheet ws
=(Microsoft.Office.Interop.Excel.Worksheet)wb.Work sheets[1];

ws.Cells[1, 1] = "CardNo";
ws.Cells[1, 2] = "PharmacyName";
ws.Cells[1, 3] = "CostPerCard";

sw.Writer(ws.Cells[1, 1]);
sw.Writer(ws.Cells[1, 2]);
sw.Writer(ws.Cells[1, 3]);

I thought this code will write to the spreadsheet like this:
A | B | C
-----------------------------------------------
CardNo | PharmacyName | CostPerCard

but, it wrote to spreasheet like this, all them just in column A:
A
-----------------------------------------------
System.__ComObjectSystem.__ComObjectSystem.__ComOb jectH40655


I have been spent quite lots of time on it, but still couldn't work it out.

Thanks heaps

Microsoft.Office.Interop.Excel.Application
 

Hi

I worked it out. lol

I can't use the StreamWriter to write the value into spreadsheet and save
it, i have to use Excel.Workbook.SaveAs() method to save the spreadsheet.

Thanks for your help anyway.

Andie


"Andie" wrote:

Hi All,


I am using Microsoft.Office.Interop.Excel.Application COM to create a Excel
spreadsheet, and write the value (not from any dataset) into that
spreadsheet, and then StreamWrite to the disk.

For some reason, the following code is not working.

This is the declaration of ws:
Microsoft.Office.Interop.Excel.Worksheet ws
=(Microsoft.Office.Interop.Excel.Worksheet)wb.Work sheets[1];

ws.Cells[1, 1] = "CardNo";
ws.Cells[1, 2] = "PharmacyName";
ws.Cells[1, 3] = "CostPerCard";

sw.Writer(ws.Cells[1, 1]);
sw.Writer(ws.Cells[1, 2]);
sw.Writer(ws.Cells[1, 3]);

I thought this code will write to the spreadsheet like this:
A | B | C
-----------------------------------------------
CardNo | PharmacyName | CostPerCard

but, it wrote to spreasheet like this, all them just in column A:
A
-----------------------------------------------
System.__ComObjectSystem.__ComObjectSystem.__ComOb jectH40655


I have been spent quite lots of time on it, but still couldn't work it out.

Thanks heaps