Loading

how to add one column before generate table

how to add one column before generate table

venkat

8y794Visual Basic .NET

Hi all,

The below code will generate table and i binded to the excel it is working fine .

public static DataTable GetTable()

{

// Here we create a DataTable with four columns.

DataTable table = new DataTable("Example Values");

table.Columns.Add("tyu", typeof(string));

table.Columns.Add("wer", typeof(int));

table.Columns.Add("adf", typeof(string));

// Here we add DataRows.

table.Rows.Add("lkj", "oip", "hn");

table.Rows.Add("hj", "hj", "yuu");

return table;

}

output :

above output is fine but here i need to small change like wants to add some text on top of the table.

i want to add one column on top of the table

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

venkat8y ago
it is not windows form. using closedxml i generated excel.
DataSet dataset = new DataSet();
dataset.Tables.Add(datatable);
DataTable staticdatatable = new DataTable();
staticdatatable = GetStaticdataTable();
DataSet staticdataset = new DataSet();
staticdataset.Tables.Add(staticdatatable);
XLWorkbook wb = new XLWorkbook();
IXLWorksheet worksheet = wb.Worksheets.Add(staticdataset.Tables[0]);
IXLWorksheet ws = wb.Worksheets.Add(dataset.Tables[0]);
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=" + fileName);
Kanimozhi Shivakumar8y ago
Hi Venkat,

Is it in Windows Forms?

Can you tell me how you binded datatable to excel?

Because I tried to bind datatable to excel from customized Row(i.e I need to Print first Company details on top of the excel and then I have to print Datatable details) . But I didn't get any solution..

Now I am binding ADODB.Recordset instead of datatable.. It is working fine.. If you are fine with this logic , I will share the same.