Create Excel file with ExcelLibrary

Question

I use ExcelLibrary to create an excel from a DataSet. I use the below code to create a DataSet and create Excel.

DataTable dtTable = new DataTable();
dtTable.Columns.Add(new DataColumn("name", typeof(string)));
DataRow dr = dtTable.NewRow();
dr[0] = "test";
dtTable.Rows.Add(dr);
DataSet ds = new DataSet();
ds.Tables.Add(dtTable);

ExcelLibrary.DataSetHelper.CreateWorkbook(textBox1.Text, ds);

But when the excel is created, there are no rows in Excel.

Questions are more easily answered if you include the code.. — Vandal, Oct 19 '15 at 06:09

score 1 · Answer 1 · answered Oct 19 '15 at 06:48

1

Try this.

DataTable dt = new DataTable(); dt.Columns.Add("Name"); dt.Columns.Add("Code");

DataRow row1 = dt.NewRow(); row1["Name"] = "Abundantcode"; row1["Code"] = "1-1-1"; dt.Rows.Add(row1);

Source.

Hope it helps!

answered Oct 19 '15 at 06:48

Vandal

903
1
14
27

doesn't work, the dataTable that i created is correct,but when create excel doesn't show data – SajjadZare Oct 19 '15 at 06:53

score 0 · Answer 2 · answered Jan 31 '19 at 09:10

0

Give a name to your datatable. That will create the sheet name dtTable.TableName = "Sheet1"

answered Jan 31 '19 at 09:10

emrah kasal

21
2

Create Excel file with ExcelLibrary

2 Answers2