如果是新建一个excel文件:
Application app=new Application();
Workbook wbook=app.Workbook.Add(Type.missing);
Worksheet worksheet=(Worksheet)wbook.Worksheets[1];
设置某个单元格里的内容:
worksheet.Cells[1,2]="列内容"
读取某个单元格里的内容
string temp=((Range)worksheet.Cells[1,2]).Text;
设置某个单元格里的格式
Excel.Range rtemp=worksheet.get_Range("A1","A1");
rtemp.Font.Name="宋体";
rtemp.Font.FontStyle="加粗";
rtemp.Font.Size=5;
保存新建的内容:
worksheet.SaveAs("c://temp.xls",Type.missing,Type.missing,Type.missing,Type.missing,Type.missing,Type.missing,Type.missing,Type.missing);
Application app=new Application();
Workbook wbook=app.Workbook.Add(Type.missing);
Worksheet worksheet=(Worksheet)wbook.Worksheets[1];
设置某个单元格里的内容:
worksheet.Cells[1,2]="列内容"
读取某个单元格里的内容
string temp=((Range)worksheet.Cells[1,2]).Text;
设置某个单元格里的格式
Excel.Range rtemp=worksheet.get_Range("A1","A1");
rtemp.Font.Name="宋体";
rtemp.Font.FontStyle="加粗";
rtemp.Font.Size=5;
保存新建的内容:
worksheet.SaveAs("c://temp.xls",Type.missing,Type.missing,Type.missing,Type.missing,Type.missing,Type.missing,Type.missing,Type.missing);