Microsoft.Office.Interop.Excel.Application

  • Thread starter Thread starter Andie
  • Start date Start date
A

Andie

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.Worksheets[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.__ComObjectH40655


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

Thanks heaps
 
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
 
Back
Top