C# - Exporting Data To Excel, With Jagged Columns Due To Dynamic Data?
Jan 25, 2010
I have a bit of an interesting problem where I need to create an Excel data dump from some data in the database, but rather than it being something simple I have some complex data to merge, below is an example of the data that I have to deal with.
TblGeneralInfo
RecordId|Record Name |Date |Cost
1 |Test Entry | 1/1/2010 |2.0
2 |Test Entry2 | 1/1/2010 |20.25
TblRandomInfo
RecordId |QuestionName | Answer
1 |Your Name? | Bob
1 |Your Title? | The Builder
2 |Favorite Movie | The Matrix
2 |Favorite Car | Mustang
What I need in the end is the following
RecordId|Record Name |Date |Cost | | | |
1 |Test Entry | 1/1/2010 |2.0 |Your Name? | Bob | Your Title? | The Builder
2 |Test Entry2 | 1/1/2010 |20.25 |Favorite Move | The Matrix | Favorite Car | Mustang
Now I'm using SQL Server 2005 for the reporting and ASP.NET 3.5 (C#) for the application. I'm looking for the best way to do this. The number of items in "tblRandomInfo" is variable, and can have as many as 20-30 Q/A pairs per record. I cannot easily do a pivot, even a dynamic pivot due to the nature of the data.
Edit.A solution is valid either on the SQL Server or C# side. But note that information in tblRandomInfo can contain line breaks.
View 3 Replies
Similar Messages:
Aug 12, 2010
i did the mysql data export into excel in row wise when button click... here i want the same data export into columns wise..i used datatable and dataset for this function.. here i need all data should export in column..here i used some code..
[Code]....
View 2 Replies
Feb 28, 2013
I'm exporting a Gridview to excel. I get all the gridview header and content in excel in addition to that i need to add a header text like report name in header of the excel sheet with line break in header.
I tried the solution in this link [URL] by adding
Table.Caption = "Header Text"
Table.CaptionAlign = TableCaptionAlign.Top
but i get error Reference to a non shared member requires an object reference.
View 1 Replies
Apr 1, 2010
when I used a code of exporting gridview into excel this code worked for a new website which is without masterpage.
my code:
public override void VerifyRenderingInServerForm(Control control) { }
protected void BtnGenerateReport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();.....
Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.
View 2 Replies
May 7, 2015
I am trying to export my Model to an Excel sheet. I have 31 fields out of which only 29 are exported. Among the 3 fields that I am not able to export 2 are of type Enum and one of DateTime. Their is another DateTime field also, but that is exported properly. Here are few fields of the model :
[EnumDataType(typeof(Suffix)), Display(Name = "Suffix *")]
[Required(ErrorMessage = "Suffix is Required")]
public Suffix NameSuffix { get; set; }
[EnumDataType(typeof(InquiryStatus)), Display(Name = "Status")]
[Required(ErrorMessage = "Status is Required")]
[Code] ....
Among the 4 fields above, NameSuffix, Inquiry_Status & FollowUpDate are not exported. InquiryDate is exported.
My exporting code is :
DataGrid dg = new DataGrid();
dg.DataSource = inqs.ToList<Inquiry>();
dg.DataBind();
string filename = "InquiryList_" + DateTime.Now + ".xls";
Response.ClearContent();
[Code] ....
In the ContentType, I alos tried with ""application/ms-excel";, but that makes no difference.
What can be the error for the above ?
View 1 Replies
Oct 17, 2013
I have a project in vb with a gridview in a multiview and i want to save in a workbook excel the gridview displayed data. I have read many articles but in the end i have downloaded the code from URL...and i adapted for my code. The problem is that when i press the ExporttoExcel button it's exporting only this...I cannot figure out that is the problem.
<style> .textmode { mso-number-format:@; } </style><div>
</div>
My code is down
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI.WebControls.TableRow
Imports System.Web.UI.WebControls.GridViewRow
Imports System.Diagnostics
Imports System.IO
Imports System.Configuration
[code]....
View 1 Replies
Apr 6, 2010
I'm having two grid view and one button on aspx page , on click of export to excel button i want to transfer these grid view data to excel sheet.. My requirement is to trasnfer to same excel file with two sheets(One sheet for one grid view).
View 6 Replies
Jan 21, 2010
I want to export a gridview data to excel; however, my form contains an update panel. I am getting the error message below. Note: the function works without an update Panel.
RegisterForEventValidation can only be called during Render();
private
{
Response.ClearContent();
Response.AddHeader(
Response.ContentType =
[Code].....
View 2 Replies
Jan 8, 2013
In my gridview,the first 5 columns are filled with the values retrived from database on selecting an item dropdown.The last i.e, 6th column(date) is filled with value given in the textbox.
Now I need to export the gridview rows to Excel in which checkbox is checked.But Now With the code i have,Excel is containing the empty date column.Pls correct my code to get the proper filled Excel.
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
fillCollegeNames();
}
private void fillCollegeNames()
[code]....
View 1 Replies
Oct 7, 2010
I have master page concept in the project where as i am trying to create the export function in the child contrl.on the button click i wrote the below code
Response.Clear();
View 7 Replies
Jul 27, 2010
I have fetched data from databse using Nhibernate as a data access.
I am traversing a list in View using foreach loop.
I want to export this tables data to Excel.
View 8 Replies
Sep 20, 2010
I created a gridview that is made up of 4 gridviews and using a stored procedure to populate it. I create columns at runtime because the number of columns changes all the time.To make the grids editable I am adding template fields at runtime as I create the columns, this is to ensure that a user is able to edit the cells and some foot values update. Reason why I have four grids is to freeze rows and columns like in excel using javascript. The problem is that performance is very bad especially in IE, the grids take a long time to load. I am not sure if this is caused by the data load or the creation of text boxes. see some of the code below for my _aspx page:
[Code]....
View 1 Replies
May 10, 2010
I am binding data from a dataset to a grid and exporting data from the grid to an excel.if the the number of items in the grid is greater than 50000,an error message is displayed.
So i want to split the data and display it in different worksheets in excel.(Am working in a web application)
using this code for exporting to excel
gvExcel.DataSource = DTS;
gvExcel.DataBind();
Response.AddHeader("content-disposition", "attachment; filename= filename.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvExcel.RenderControl(htw);
// Style is added dynamically
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
View 2 Replies
Aug 10, 2010
let me know how to export asp.net4.0 chart data to pdf/excel .
View 2 Replies
Feb 2, 2011
I am trying to export an ASP.NET 3.5 DataGridView to Excel using the following code :
protected
void Button1_Click(object sender,
EventArgs e)
{
Response.Clear();
Response.Buffer = true ;
Response.AddHeader("content-disposition" ,
"attachment;filename=text.xls" );
Response.Charset = "" ;
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" ;
StringWriter sw =
new StringWriter ();
HtmlTextWriter hw =
new HtmlTextWriter (sw);
GridView1.DataSource = RecordsDataSet;
GridView1.DataBind();
GridView1.AllowPaging = false ;
GridView1.DataBind();
GridView1.HeaderRow.Style.Add("background-color" ,
"#FFFFFF" );
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
//Change Color back to white
row.BackColor = System.Drawing.Color .White;
//Apply text style to each Row
row.Attributes.Add("class" ,
"textmode" );
}
GridView1.RenderControl(hw);
//style to format numbers to string...........
View 10 Replies
Nov 9, 2010
I didn know where to post this query so m posting it here
I am tryin to export the data from d database to an excel sheet m using d following stored procedure for this
[Code]....
BlogAssignment being my database name and Data_Table my table.
Trial.xls is the excel sheet where i am trying to insert the data.
I am getting the follwoing error
[Code]....
View 2 Replies
Feb 8, 2010
I need a way to export data from MySql database (or simply from DataTable) to Excel and set colors of particular rows based on one of the fields' content.
I don't want to export the whole GridView because I need a way to add fields with calculated values as needed.
I have the following code that works:
[Code]....
But I don't know how to set colors to particular rows. Also, I don't know how to make Excel treat text fields that look like numbers as text to avoit scientific notation.
View 1 Replies
Jan 27, 2010
I currently have a data grid that exports to Excel on an ASP.NET page (which is used for reporting purposes) which works great until we put it under the stresses of a full scale production environment. With a multitude of users using it it seems to fill up the server memory quite quickly since the data thats being pulled is rather large. The requirements of the page are: The data needs to be queried and exported to excel, so theres no point to getting around that. I've noticed that xls files are rather large in comparison to their xlsx counter parts, using xlsx files would be fine for my application. I've noticed that xlsb (Excel binary) are even smaller(approx 25% the size of the their xls counterpart). Is there anyway to change my code to export to xlsb (first choice) or xlsx rather than xls? I think it has something to do with Mime Types but I'm not positive.
Here is the code that I'm using for exporting:
[Code]....
View 8 Replies
Aug 16, 2010
I found the following code online but I get error message "
RegisterForEventValidation can only be called during Render();
My C# code is:
[Code]....
View 2 Replies
Jan 26, 2012
I'm exporting data to Excel. I've to put some headings, some data from datatable and again some footer text. For that I'm using following Code. It works fine locally but when I publish it it gives error while saving excel file as I'm hosting it on shared server.
Code:
'--SOME HEADERS
Dim HtmlStream As String
HtmlStream = "<html><body><br/><div style='padding:15px;font-family:Tahoma;font-size:11px;'>"
HtmlStream += "<table cellpadding='0' cellspacing='0' border='1' style='line-height:20px; border:solid 1px;font-size:11px;' width='100%'><tr><td colspan='8' style='height:20px;'></td></tr> <tr><Td colspan='8'>"
HtmlStream += "<div style='padding-left:20px;'><b>MULTIPLE TRANSACTIONS REQUEST FORM</b><br /><b>Date -" + DateTime.Now + "</b><br /><b>Name of Applicant - ABC CO. LTD.NEFT</b><br />"
[Code] ....
It gives error while saving
View 8 Replies
May 24, 2010
I have an export button which exports the datagrid data to the excel sheet, now the problem is it is not exporting the right data to the excel sheet, the address column is showing just the 1st line of address shown in the datagrid and also not showing the
county .the code for this button is below.
protected void btnExport_Click(object sender, EventArgs e)
{
var _exportData = FilteredAudienceAsTable;
Export(_exportData, "Audiences.xls");
[Code]...
View 6 Replies
Jul 15, 2010
I am exporting GridView to Excel but keep on getting a pop up "The file you are trying to open, 'somefile.xls' is in a different format than specidied by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?When I click "yes" the file opens fine. But why I am getting the pop up at the first place.Also as I have Office 2007 on my machine
GridView1.DataSource = dv;
GridView1.DataBind();
Response.Clear();
Response.Buffer = true;
[code]...
View 1 Replies
Apr 14, 2010
I am usig ADO.NET to fetch a Dataset and then exporting the data to excel using Response.Write with response type set as excel. However when I run the application I am getting the following error in the browser."Cannot view XML input using XSL style sheet. Please correct the error and then click theRefresh button, or try again later."Anybody has any idea on why do we get this error and any pointers to resolve this error? By the way the same code does works on another machine, it's just not working on few machines.
View 1 Replies
Apr 28, 2010
I am creating some Graphs using Asp.net Charting control. I need to export the charts created to excel. These charts are going to be saved as images. I am able to export the Graph along with other details successfully using the foloowing code...
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=Sample.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter stringWriter = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
Table1.RenderControl(htmlTextWriter);
htmlTextWriter.WriteBreak();
string test = Server.MapPath("~/");.......
If i try to open this excel file in any other system, then the image (i.e, charts) wont be available. But the excel shows the image only in my system(where the image is available in hard disk) .
View 4 Replies
Jan 20, 2011
I have the following scenario shown below
Label: Name
ID Qty
1 10
2 5
Kindly note, the ID. QTy are currently in a gridview and the Label is a label on top of the gridview. I would like to export both the label and the gridview to excel...how can I do this.
View 7 Replies
