Grouping rows in excel
I have created one web page in asp.net. In that I used css button and excel generate button. So far I press the button to populate data from the database to succeed. It shows problem while loading css file like this. What will I do to remove this error.
I used the following code to open an excel sheet
Response.ContentType = "application/xls";
Response.AddHeader("Content-Disposition", "attachment; filename=itext.xls");
Is there something wrong with that?
If I understand correctly, the problem you are facing is something I had a long time ago (still in the classic ASP days) where you get a "Missing file" error pointing to a css link when opening a file excel you created. The workaround I did at the time was to completely remove the css link and use inline styles.
This will take you home, but if you want a more advanced solution, you can make an asynchronous request to the server, generate content there (either in memory or in a file, depending on how big the result is) and then send it back to the client. when it's done.
source to share