创建简单的Excel表在C＃中使用字符串作为输入 [英] creating simple excel sheet in c# with strings as input

问题描述

我创建的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.

感谢您

推荐答案

如果您包括的Excel互操作你可以做任何你请有安装在系统上的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＃中使用字符串作为输入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！