i have to export data to excel sheet from data table and also i need to show a line chart there in the same sheet. my question is how could i show data & chart in same sheet.
i am using NPOI library version 1.2.5.0 & dotnet 2.0 i have manage to export data to excel from data table using NPOI Library like this way. here is my sample code.
class Program
{
static void Main(string[] args)
{
DataTable dt = new DataTable();
dt.Columns.Add("First Name", typeof(string));
dt.Columns.Add("Last Name", typeof(string));
dt.Columns.Add("Salary", typeof(double));
DataRow dr = null;
dr = dt.NewRow();
dr[0] = "Konna";
dr[1] = "Lombard";
dr[2] = "3000";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "Tunip" ...
Go to the complete details ...