C# WinForm创建Excel文件的实例
作者:jingxian 时间:2023-08-06 19:47:06
实例如下:
private bool creatExcel(string xlsfile)
{
try
{
object missing = System.Reflection.Missing.Value;
Excel.ApplicationClass myExcel = new Excel.ApplicationClass();
Excel._Workbook xBk; //工作薄
Excel._Worksheet xSt; //工作Sheet
xBk = myExcel.Workbooks.Add(true);
for (int i = 0; i < 1; i++)
{
xSt = (Excel._Worksheet)xBk.ActiveSheet;
xSt.Name = "Sheet" + i;
myExcel.Sheets.Add(missing, missing, 1, Excel.XlSheetType.xlWorksheet);
}
//myExcel.Visible = true;
if (xlsfile.ToLower().EndsWith(".xlsx"))
{
xBk.SaveAs(xlsfile, 56, missing,
missing, missing, missing, Excel.XlSaveAsAccessMode.xlShared,
missing, missing, missing, missing, missing);
}
else
{
xBk.SaveAs(xlsfile, missing, missing,
missing, missing, missing, Excel.XlSaveAsAccessMode.xlShared,
missing, missing, missing, missing, missing);
}
myExcel.Quit();
return true;
}
catch (Exception ex)
{
MessageBox.Show("Excel创建失败!原因:" + ex.Message);
return false;
}
}
标签:c,winform,excel,文件
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
java实现五子棋小游戏
2021-12-25 06:58:56
![](https://img.aspxhome.com/file/2023/0/63380_0s.jpg)
JAVA NIO实现简单聊天室功能
2023-05-01 10:32:49
C#手工双缓冲技术用法实例分析
2023-05-09 07:13:44
java 回调机制的实例详解
2023-12-04 10:03:04
C#中的WebRequest与WebResponse抽象类、DNS静态类、Ping类介绍
2022-12-28 05:22:15
C# Winform调用百度接口实现人脸识别教程(附源码)
2021-12-27 13:17:09
![](https://img.aspxhome.com/file/2023/2/91252_0s.jpg)
Servlet注解之@WebInitParam多个InitParam的使用
2023-08-04 13:43:01
C++链表节点的添加和删除介绍
2023-08-23 02:32:09
Android 开发使用PopupWindow实现弹出警告框的复用类示例
2022-04-07 03:43:42
![](https://img.aspxhome.com/file/2023/5/138855_0s.png)
Java 基础语法
2021-09-21 19:26:32
Android解决viewpager嵌套滑动冲突并保留侧滑菜单功能
2023-09-05 11:36:33
使用JVM常用GC日志打印参数
2021-09-06 17:36:41
![](https://img.aspxhome.com/file/2023/2/65752_0s.png)
springboot+mybatis-plus 两种方式打印sql语句的方法
2022-12-29 13:41:11
![](https://img.aspxhome.com/file/2023/9/64379_0s.jpg)
Android自定义view实现TextView方形输入框
2021-09-16 17:09:33
![](https://img.aspxhome.com/file/2023/1/138901_0s.jpg)
java理论基础Stream元素的匹配与查找
2021-08-26 10:11:20
![](https://img.aspxhome.com/file/2023/8/122948_0s.jpg)
Java实现List集合转树形结构的示例详解
2021-11-11 10:48:33
java连接SQL Server数据库的超详细教程
2023-04-05 21:46:22
![](https://img.aspxhome.com/file/2023/5/63095_0s.png)
C#交错数组用法实例
2022-08-13 09:34:55
AndroidStudio修改Code Style来格式化自定义标签的xml文件方式
2023-08-07 00:43:21
![](https://img.aspxhome.com/file/2023/5/128945_0s.jpg)
C++如何通过ostringstream实现任意类型转string
2022-06-27 16:23:06