c# Excel导入/导出/获取Sheet名称
VIP_WPENG
学习中
展开
-
excel导出、导入
using Microsoft.Office.Interop.Excel;using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Data.OleDb;using System.Data.SqlClient;using原创 2013-08-04 12:37:06 · 681 阅读 · 0 评论 -
c# 操作Excel单元格属性
range.NumberFormatLocal = "@"; //设置单元格格式为文本range = (Range)worksheet.get_Range("A1", "E1"); //获取Excel多个单元格区域:本例做为Excel表头range.Merge(0); //单元格合并动作worksheet.Cells[1, 1] = "Excel单元格赋值";原创 2013-11-28 15:29:35 · 4856 阅读 · 0 评论