.net 操作Excel
来源:互联网 发布:长沙麻将源码 编辑:程序博客网 时间:2024/06/06 05:58
将数字序号转换为列号
private string NunberToChar(int number)
{if (1 <= number && 36 >= number)
{
int num = number + 64;
System.Text.ASCIIEncoding asciiEncoding = new System.Text.ASCIIEncoding();
byte[] btNumber = new byte[] { (byte)num };
return asciiEncoding.GetString(btNumber);
}
if (number > 36)
{
int num = number - 36 + 64;
System.Text.ASCIIEncoding asciiEncoding = new System.Text.ASCIIEncoding();
byte[] btNumber = new byte[] { (byte)num };
return "A" + asciiEncoding.GetString(btNumber);
}
return "";
}
object missing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook newWorkBook = excel.Application.Workbooks.Add(true);//添加新工作簿
newWorkBook.Worksheets.Add(missing, missing, missing, missing);//向Excel文件中增加工作表
Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)newWorkBook.Sheets[1];
Microsoft.Office.Interop.Excel.Range range;
string sMaxCol = NunberToChar(dtLCLJJD.Rows.Count + 1);
range = sheet.get_Range("A1:" + sMaxCol + "1", Type.Missing);
range.Merge(0); //合并单元格显示
range.Value2 = “标题1”;
range.Font.Size = 15;
range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;
range.WrapText = true;//自动换行
- .net 操作EXCEL
- .net 操作EXCEL
- .net 操作excel
- .net 操作EXCEL
- C#.Net操作Excel
- .Net C# 操作Excel
- .NET操作EXCEL编程
- .net操作EXCEL
- .Net操作Excel实践
- asp.net 操作EXCEL
- .Net操作Excel总结
- asp.net 操作Excel
- asp.net操作excel
- vb.net 操作EXCEL
- .Net Excel 部分操作
- VB.NET EXCEL操作
- .net excel操作类
- asp.net 操作excel
- IOS 强制去除里面的警告
- stringstream的清空操作,注意clear()的使用
- 完整框架下载地址ssm
- Qt设置全局的widget的stylesheet
- VC中CListCtrl使用技巧(部分转载)
- .net 操作Excel
- 内联与宏
- libc: ../src/pj/os_core_unix.c:692: pj_thread_this: assertion "!"Calling pjlib from unknown/external
- The following classes could not be found: - android.support.v7.internal.app.WindowDecorActionBar (Fi
- 判断应用程序是否在前台
- SpringBoot启用HTTPS协议
- 排序算法之桶排序
- C++网络摄像头数据的获取与显示 (续)
- iOS开发多线程atomic nonatomic区别