C#操作WPS的EXCEL表格

最新推荐文章于 2024-08-29 16:58:05 发布

Just4life

最新推荐文章于 2024-08-29 16:58:05 发布

阅读量8.1k

点赞数

分类专栏：软件编程技术文章标签： excel c# null 工作

本文链接：https://blog.csdn.net/lassewang/article/details/6988882

版权

软件编程技术专栏收录该内容

205 篇文章 8 订阅

订阅专栏

1. 打开ET文件

ET.Application etApp;
ET.workbook etbook;
ET.Worksheet etsheet;
ET.Range etrange;

etApp = new ET.Application();
etbook = new ET.workbook();

//获取工作表格
etbook = (ET.workbook)etApp.Workbooks.Open(strEtFPath, null, null, null, null, null, null, null, null, null, null, null, null);

//获取第一个表格
etsheet = (ET.Worksheet)etbook.Worksheets.get_Item(1);

//获取数据区域
etrange = (ET.Range)etsheet.UsedRange;

2.关闭ET文件

ET.Application etApp;
ET.workbook etbook;
ET.Worksheet etsheet;
ET.Range etrange;

etbook.Close(true, strEtFPath, System.Reflection.Missing.Value);
etApp.Quit();

System.Runtime.InteropServices.Marshal.ReleaseComObject(etrange);
System.Runtime.InteropServices.Marshal.ReleaseComObject(etsheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(etbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(etApp);




3.获取ET文件的行数于列数

int iRow = etrange.Rows.Count;
int iColumn = etrange.Columns.Count;


4.读取指定位置的数据


int iRowCount = 0;
int iColumnCount = 0;
strData = ((ET.Range)etrange.get_Item(iRowCount, iColumnCount)).Text;

5.创建ET文件
ET.Application etApp;
ET.workbook etbook;
ET.Workbooks etbooks;
ET.Worksheet etsheet;



etApp = new ET.Application();
etbooks = etApp.Workbooks;
etbook = etbooks.Add(System.Reflection.Missing.Value);
etsheet = (ET.Worksheet)etbook.ActiveSHeet;