Answer / prashanthi

I'm giving you the code about export to excel i.e., now i'm
taking table from database and binding to excel sheet.That
Excel sheel is on my Local System.
Here i'm using Aspose(its a 3rd Party Tool)
Aspose reduces the code by setting data ,cells etc in Excel
Sheet.
Its a WebApplication.U can change it to Windows Application.

This code is for Setting the format for Excel Sheet:
public Workbook ExportToExcel(DataSet objDs, string
strHeader)
{
DataTable dtResult;
dtResult = objDs.Tables[0];

Workbook excel = new Workbook();
excel.Worksheets[0].Name = strHeader;

#region SettingHeaderInformation

excel.Worksheets[0].Cells
["B4"].Style.Font.IsBold = true;
excel.Worksheets[0].Cells["B4"].Style.Font.Size
= 12;
excel.Worksheets[0].Cells["B4"].PutValue
(strHeader);

excel.Worksheets[0].Cells
["D4"].Style.Font.IsItalic = true;
excel.Worksheets[0].Cells["D4"].PutValue
("Dated: " + DateTime.Now.ToLongDateString());

#endregion

//Exports data set into excel cells
Aspose.Cells.Cells exportCells =
excel.Worksheets[0].Cells;
exportCells.ImportDataTable(dtResult, false, 5,
0);

//This block is to header for exported data
table.
Aspose.Cells.Cells sheetCell = excel.Worksheets
[0].Cells;
for (int i = 0; i < dtResult.Columns.Count; i++)
{
if (i != (objDs.Tables[0].Columns.Count -
1))
excel.Worksheets[0].AutoFitColumn(i);

excel.Worksheets[0].Cells[5,
i].Style.Number = 49;
excel.Worksheets[0].Cells[5,
i].Style.Pattern = BackgroundType.Solid;
excel.Worksheets[0].Cells[5,
i].Style.ForegroundColor = excel.GetMatchingColor
(Color.FromName(SystemColors.InactiveCaption.Name));
excel.Worksheets[0].Cells[5,
i].Style.Font.IsBold = true;
excel.Worksheets[0].Cells[5,
i].Style.Font.Color = Color.White;
string headerTxt = dtResult.Columns
[i].ColumnName;
if (headerTxt.Contains(strDesc))
headerTxt = headerTxt.Remove
(headerTxt.IndexOf(strDesc));
else if (headerTxt.Contains(strDesc))
headerTxt = headerTxt.Remove
(headerTxt.IndexOf(strDesc));
excel.Worksheets[0].Cells[5, i].PutValue
(headerTxt);
if (i < objDs.Tables[0].Columns.Count)
excel.Worksheets[0].Cells[5,
i].Style.HorizontalAlignment = TextAlignmentType.Left;
else
excel.Worksheets[0].Cells[5,
i].Style.HorizontalAlignment = TextAlignmentType.Right;
}

return excel;
}


In Button we can write this code(its for binding the data
from database to Excel Sheet):

protected void Button2_Click(object sender, EventArgs e)
{
Aspose.Cells.Workbook workBook = new
Aspose.Cells.Workbook();
ExportMethods objExpMethods = new ExportMethods();
ds = objclass.getpagebal();//calling function from
businesslayer(table)
workBook = objExpMethods.ExportToExcel
(ds, "shanti_emp");//shanti_emp is a table name
workBook.Save("shantiExcel.xls",
FileFormatType.Default,
Aspose.Cells.SaveType.OpenInBrowser, Response);
}

U can convert it according to your convineince.

Explain strong name in .net assembly?

0 Answers  

---

I want to sample Hotel management project in vb.net because still now i am doing that project for small hotel....so please send me my email id is jmuthu_pearls@yahoo.com...

4 Answers   Sapphire Comfort Hotel, TATA,

---

hi dear ? MY problem is that i m developing software for Library. and i want to connect a third party software with my VB.net program in order to calculate DDC number.I dont know how to do this if any body can help me please?

1 Answers  

---

how can we assigns items on listbox so that it will show rowwise please write the code for it.

3 Answers  

---

What are the different types of a stream?

0 Answers  

---

What is code security?

0 Answers  

---

what are the advantages and diadvantages of active reports over crystal reports ?

1 Answers   IBM, Kotak,

---

How do you rate yourself in .NET ?

3 Answers   Infosys, Seneca Global,

---

What is the main use of a namespace?

0 Answers  

---

What are the features of c# which are not present in vb.net?

0 Answers  

---

What are the advantages of an assembly?

0 Answers  

---

What is non_deterministic finalization?

0 Answers  

---