473,626 Members | 3,304 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Datagrid export to excel only displays in white for unknown reason

9 New Member
I am populating a datagrid and outputting it to excel. Everything worked well last night, but today excel only displays the content in font color white, which is impossible to see.

The data is all there but invisible. I am unable to change any type of properties within excel to have the font color change. I have tried changing every attribute on the datagrid that I can think of, and I have also outputted to just a plain generic auto-generate columns datagrid with the same effect.

When i change the response.type from excel to html the datagrid displays fine in black print.

Any tips on how to change this output would be great, we're trying to get this to go live today.

Thanks!


Here is my HTML Code

Expand|Select|Wrap|Line Numbers
  1. <%@ Page Language="vb" AutoEventWireup="false" Codebehind="TimeReport.aspx.vb" Inherits="xxxx" %>
  2. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  3. <HTML>
  4.     <HEAD>
  5.         <title>TimeReport</title>
  6.         <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
  7.         <meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
  8.         <meta name="vs_defaultClientScript" content="JavaScript">
  9.         <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
  10.  
  11.     </HEAD>
  12.     <body bottomMargin="0" leftMargin="0" topMargin="0" rightMargin="0">
  13.         <form id="Form1" method="post" runat="server">
  14.             <asp:DataGrid ID="dataGrid"  AutoGenerateColumns=True runat=server></asp:DataGrid>
  15.         </form>
  16.     </body>
  17. </HTML>
  18.  
  19.  
  20.  

Here is the VB code:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Page_Load()
  2.   Response.Clear()
  3.             Response.ContentType = "application/vnd.ms-excel"
  4.             Response.Charset = ""
  5.  
  6.             Dim dsExport As DataSet = getReportData(dateselect1, dateselect2)
  7.             dataGrid.DataSource = dsExport
  8.             dataGrid.DataBind()
  9.  
  10.  
  11.     End Sub
  12.  
  13.  
  14.     Private Function getReportData(ByVal d1 As Date, ByVal d2 As Date) As DataSet
  15.         Dim strConnection As String
  16.         Dim sqlCmd As SqlCommand
  17.         Dim ds As New DataSet
  18.         Dim da As SqlDataAdapter
  19.  
  20.         ' Dim sqlRetrieve As SqlCommand
  21.         Dim sqlConn As SqlConnection
  22.         Dim intTestCount As Integer
  23.         Try
  24.  
  25.             'connection string from Web Config
  26.             strConnection = ConfigurationSettings.AppSettings("ConnectionString")
  27.             sqlConn = New SqlConnection(strConnection)
  28.             sqlCmd = New SqlCommand("TimeTracker_ReportGenerate1", sqlConn)
  29.             sqlCmd.CommandType = CommandType.StoredProcedure
  30.                 sqlCmd.Parameters.Add("@dtDateRange1", d1)
  31.                 sqlCmd.Parameters.Add("@dtDateRange2", d2)
  32.  
  33.             sqlConn.Open()
  34.  
  35.             da = New SqlDataAdapter(sqlCmd)
  36.             da.Fill(ds)
  37.  
  38.         Catch ex As Exception
  39.             Response.Write(ex.ToString & "<br>")
  40.  
  41.         Finally
  42.             sqlConn.Close()
  43.         End Try
  44.  
  45.         Return (ds)
  46.  
  47.     End Function
  48.  
Jul 17 '06 #1
0 5261

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
7903
by: Ashish Shridharan | last post by:
Hi All I have been trying to add a control to the header cell of a datagrid on my ASP.NET page. These controls are defined in the HTML as ASP.NET web controls. They are being added into the header of the datagrid in the "ItemDataBound" method of the grid. However, once, they are added in the grid, i seem to lose the event handler for the same control. Is there anyone who has tried this before and knows why this is hapenning ??
1
10912
by: Ugo | last post by:
Hi, I am having a problem exporting a Datagrid to excel in asp.net. For some reason I am getting a blank excel page. I set up in IIS the Mime for ..xls. My code is below any help would be appreciated.. Thanks CODE: private void ExportToExcel()
1
3370
by: Kevin Blakeley | last post by:
I know this was just posted but I did not want this message to get lost in the other thread as it's slightly different. Yes I want to export my dataset to excel for my clients, but I don't want it to show in the browser. Everything I have tried makes it so that IE will load excel within the browser session and view the file in there. What I want is for the user to be prompted with the save dialog to save the excel file disk. How do I...
0
1023
by: Dave | last post by:
In a VB.NET application, I have a datagrid that I export to an Excel spreadsheet like this: ' Set the content type to Excel Response.ContentType = "application/vnd.ms-excel" Dim tw As New System.IO.StringWriter Dim hw As New System.Web.UI.HtmlTextWriter(tw) ' Get the HTML for the control.
1
1857
by: Luis Esteban Valencia | last post by:
Here is my aspx code: ============= <%@ Page language="c#" Codebehind="WebForm3.aspx.cs" AutoEventWireup="false" Inherits="PDM.excel.WebForm3" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <title>WebForm3</title> <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR"> <meta content="C#" name="CODE_LANGUAGE">
0
1691
by: optimizeit | last post by:
What I am attempting to do is import an Excel Workbook and display the worksheets in a datagrid dynamically. I am very close to getting this to work. I have to this point successfully imported a single worksheet into a dataset. I successfully built a dynamic datagrid. And I did successfully bind it to the dataset. Then I added the datagrid control to a PlaceHolder. The first worksheet displays beautifully. The next step is to allow...
4
2189
by: Amirallia | last post by:
Hello Here's my code to export a datagrid to Exel : Response.Clear() Response.Buffer = True Response.ContentType = "application/vnd.ms-excel" Response.Charset = "" Dim monStringWriter As StringWriter = New StringWriter Dim monHtmlTextWriter As HtmlTextWriter = New HtmlTextWriter(monStringWriter)
3
5077
by: =?Utf-8?B?Sm9obiBXYWxrZXI=?= | last post by:
Hi, Is there anything wrong with the code below in sending my browser page to Excel? Before my page opens in Excel there's a message "Problems came up in the following areas during load:" and it shows a CSS file in the "temporary internet files" path. But when i click OK the page displays beautifully. Even though my page has 3 datagrids, they all display with the same style as seen in the browser page. Though, the second problem is,...
6
2730
by: slinky | last post by:
I found the following code to transfer datagrid data to an Excel file. Is this written in C#?... I'm a vb.netter. I'm just not sure where to place the code to experiment on it. Should I place it in the event handler for a form button. Is there other ways to accomplish this? I looked at some on the web and usergroups, but was confused as to the functioning. BTW my datagrid is enclosed in a <div></divfor ease of scrolling if that would...
0
8203
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8711
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8642
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8368
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8512
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5576
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4094
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2630
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1815
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.