本文介绍了创建简单的Excel表在C#中使用字符串作为输入的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我创建的Excel工作表工作在C#
I am working on creating EXcel sheet in C#.
No Of columns:4
Name of columns: SNO, Name, ID, Address
有是行数不constarint。
There is no constarint on number of rows.
SNO Name ID Address
1 A 1122 XXXX
2 B 2211 YYYY
--- --- ---- ---
我有一个字符串作为输入
I have strings as input
string sno, string name, string Id, string address
其实我新的C#背景。
任何一个可以分享他们就可以了看法一样需要等的DLL。
Can any one share their view on it like dlls needed etc.
感谢您
推荐答案
如果您包括的你可以做任何你请有安装在系统上的Office。
If you include a reference to Excel Interop you can do whatever you please having Office installed on your system.
一个小例子:
using Excel = Microsoft.Office.Interop.Excel;
Excel.Application excel = new Excel.Application();
excel.Visible = true;
Excel.Workbook wb = excel.Workbooks.Open(excel_filename);
Excel.Worksheet sh = wb.Sheets.Add();
sh.Name = "TestSheet";
sh.Cells[1, "A"].Value2 = "SNO";
sh.Cells[2, "B"].Value2 = "A";
sh.Cells[2, "C"].Value2 = "1122";
wb.Close(true);
excel.Quit();
这篇关于创建简单的Excel表在C#中使用字符串作为输入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!