I have a scenario where I have to create multiple sheets in excel and bind data to those sheets and download. Now I have code for creating 1 sheet. I have creatied a HTML Table and binded it to excel. In the same way I have to create multiple sheets
from Html table and download the excel file.
filename = filename + " Case Study";
Query_ValuesSelection = "Select * from case_study_information where locid="+DD_Location.SelectedValue.ToString()+" and methodid="+DD_Methods.SelectedValue;
MySqlCommand command = new MySqlCommand(Query_ValuesSelection, con);
datareader = command.ExecuteReader();
if (datareader.HasRows)
{
datareader.Read();
sb.Append("<table ...
Go to the complete details ...