C#操作excel数据表 在excel指定位置添加文字图片等操作

1.找到要操作的excel数据表

Server.MapPath("/xx.xlsx");

2.定义Worksheet对象

Worksheet objExcelWorkSheet;

3.判断文件是否存在，如果存在则删除重新创建

FileInfo newFile = new FileInfo(filePath);
if (newFile.Exists)
{
newFile.Delete();
newFile = new FileInfo(filePath);
}

4.创建Application对象

Application objExcelApp = new ApplicationClass();
Workbooks objExcelWorkBooks = objExcelApp.Workbooks;
Workbook objExcelWorkbook = objExcelWorkBooks.Open(workTmp, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

objExcelWorkSheet = (Worksheet)objExcelWorkbook.Worksheets[1];

5.写入文字

objExcelWorkSheet.Cells[3, 6] = ds.Tables[0].Rows[0]["PP"];

 

说明

1.Server.MapPath();//获得服务器上的物理路径，也就是常说的绝对路径，Server.MapPath("/") 代表获得应用程序根目录所在的位置

2.Worksheet：Worksheet对象代表Excel工作表，workSheet是单个工作表，workSheets是指定工作簿中所有工作表的集合。

3.