I'm exporting an ASP.NET gridview to Excel using the following function. The formatting is working really well, except I need to freeze the header row in Excel on the export. I'm really trying to avoid using a 3rd party Excel plugin for this, but unless there's some archaic excel markup in my AddExcelStyling function.
[code]....
I have gridview with 15 and above columns,I need to freeze the header of the gridview using the following css :
.container
{
overflow: auto;
}
/* Keep the header cells positioned as we scroll */[code].....
I would like to know how I can freeze the Header Row using DataGrid with AJAX in IE8. I've already tried using CSS but this does not work with IE8 unless I switch it to compatiblity mode. I have more than 100+ users so this is not feasible.
View 1 RepliesI have a grid view that contains a lot of data. Users have to scroll down far sometimes to edit that data. But since the header of the gridview isn't inherently frozen, its a pain for them to edit that data because they have to constantly scroll up and down. I've looked up several different methods on how to freeze the columns, but it none work work well with bound data. Often times, the rows will be offset by a large margin and even greater so, when the data is being edited. So it beats the purpose of doing it.
I can't remember exactly what I've tried, but most of it's been around Javascript. Any method to freeze the header? Or is there a better control, third party or otherwise?
I need to freeze my gridview header and the first two columns. I found a great jquery plugin called tinytbl which does the job but it messes up the inline javascript on my page which causes a few issues.
Any better way to freeze columns? I see alot of examples on the net using css but they use expression which has been deprecated.
i m using a Gridview in my Page.Now i want to freeze the row Header of the gridview.
i did it with CSS its working fine In IE
the problem arise, when the same code is working in IE but nt in Opera and also Chrome..
solution for using it in cross browser.or else code for freezing the header wihtout the CSS style sheets..
i want it to use it with the properties of Gridview ..
I want to freeze my Header columns when Autogeneratecolumns=True.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
[Code] .....
Possible Duplicate: Create Excel (.XLS and .XLSX) file from C#
I have some code that generates a zip file that contains multiple CSV files and streams it back to the user (no file is saved on the server). However, I want to create an excel workbook instead (can be traditional xls or Office Open XML xlsx format) with each CSV 'file' being a spreadsheet.
How can I do this, without resorting to Office Automation on the server or a commercial 3rd party component?
I have searched numerous articles for how to accomplish freezing the Header Row of a DataGrid or GridView component being to simply hide the header and then build table cells just above the component to define the columns. But the one that I'd like to get to work is by the use of CSS code. Problem is that this code seems to work for everyone else but it isn't working for me. Here's my Stylesheet code:
[Code]....
When I run my page I get all the styles applied but the header scrolls with all the other rows in the grid.
why this code is probably not working? I am using .NET Framework 3.5 and developing in VSS 2008 which may be why this doesn't work?
I have successfully downloaded sample code from Code Project which works using other techniques as well, but the code was written in .NET 1.1 Framework and VB.NET.
i designed a gridview with the option of Freeze the header. below is the style i have applied in the headerstyle
background: #ecf5ff;
color: #333;
background-color: #6D91BF;
border-style: solid;
border-width: 1px;
border-color: #9cc9ed #5c9fde #6daddb #b4d2f0;
font-weight: bold;
text-align: center;
color: white;
text-decoration: none;
font-size: 12px;
position: relative;
top: expression(this.offsetParent.scrollTop);
z-index: 10;
but its not working in IE8 standard view but working in IE8 compatibility mode,
When i scroll the cursor the header and static need to static but content must scroll..
View 1 RepliesI'm working on a project which requires me to plot a graph using Visual Studio ASP.Net from a data I've collected either in .txt or .xml format. The data consist of, eg. 15 records, but I'm only needed to plot 8 graphs out of the 15 records.
View 1 RepliesI have a 2 dimensional array, I want to convert it to an Excel document using C#.
View 2 RepliesI'm trying to upload an excel spreadsheet using the FileUpload control, read the excel sheet using OleDb connection, and save the strings onto a sql server database.Then, I'm trying to read each string in another method.My web app is currently hosted on the network on my local box, and using savePath= @"C:desktop" like I had it previously wasn't working, so I figured using a sql server database would work for being able to save the file and open it again... but I'm getting confused on how to do so, so i tried using my old savePath but it's not working anymore. So... I'm really at a lost on what to do and how to fix it.
[Code]....
On an .aspx page in a web site I need to retrieve some data from a sql server database and, instead of displaying it in a Gridview, I need to put the data in a spreadsheet and present the user with a Save As dialog.
I'd prefer to do it without using the Office / Excel / Interop com object - so, from what I've read so far, I can do this by returning XML data from SQL Server?
Normally I get data from SQL Server and populate a dataset or datareader with it - and then use this as the Datasource of a GridView.
If I run this in SQL Server ...
Code:
SELECT UserID, UserName FROM tblUsers FOR XML Auto, Root('Users')
It produces this ...
Code:
<Users>
<tblUsers UserID="1" UserName="Steve" />
<tblUsers UserID="2" UserName="Andrea" />
<tblUsers UserID="3" UserName="Zebedee" />
</Users>
So, first question - how do I get the data from SQL Server into my .aspx page? (All data access is done with stored procedures - so, from my data access class normally I create, for example, a SQLDataReader and populate it by calling a stored procedure. What object would I populate with the results of a stored procedure that contains a select statement with 'FOR XML Auto'
Then, assuming I get the XML into the .aspx page - how do I get it into a spreadsheet so that there are two columns called UserID and UserName and 3 rows with 1, 2 and 3 in the first cell and Steve, Andrea and Zebedee in teh second cell?
I have a gridview Control. In that control I need to show the headers when gridview is scrolling verticall. I tried your post from here [URL].... It's working in page loads.When I try to click any other buttons it's not working(it's showing all the records. I mean It's not scrolling). I have Add, Delete and reset buttons.
My gridview is with in update panel
<asp:UpdatePanel ID="uptGrid" runat="server">
<ContentTemplate>
<asp:HiddenField ID="hdnEditID" runat="server" />
<asp:Panel ID="pnlGrid" CssClass="cssPanel" runat="server" Height="250px" Width="100%"
Visible="False" ScrollBars="None"> <%-- ScrollBars="Vertical"--%>
<asp:GridView ID="grdData" runat="server" AutoGenerateColumns="False" HorizontalAlign="Left"
ForeColor="#333333" Font-Names="Courier New" Font-Size="12px" Width="100%" GridLines="None"
CellPadding="4" EmptyDataText="No record(s) Found" DataKeyNames="ID"
OnRowDataBound="grdData_RowDataBound" OnSelectedIndexChanged="grdData_SelectedIndexChanged">
My company has new customers in Brazil and we realized that our excel reports are not working when our Brazilian customers tried to open the reports in their Brazilian versions of excel.
For excel output we use spreadsheet gear in our vb.net web application. Our excel worksheets are fairly simple. Mostly outputted text/numbers/dates, a couple of formulas (sum, if) and formatting on the currency and dates.
I've tried several methods to get my excel reports to work: First I left the excel workbook in the "en-US" culture and tried simply chaging the number format for Brazil to:
_-[$R$-416] * #.##0,00_-;-[$R$-416] * #.##0,00_-;_-[$R$-416] * "-"??_-;_-@_-
And this formatted the regular cells but the formulas still failed to show a value. Instead they showed a 0 value.
Next I tried changing the workbook to the "pt-BR" culture and that also forced me to translate the formula names (Sum -> Soma, If -> Se) but they still wouldn't should a value and instead showed a #Name/#Nome error. Interestingly enough the formulas would work if I edited the cell and hit enter. The formula wouldn't change but it would some how fix that cell.
I need to be able to out excel reports that can format dates/currencies and apply simple formulas (IF, Sum) for other excel cultures.
I would like to access an Excel 2010 spreadsheet via ASP.NET 4 - what is the best (i.e. straight forward) method to do this? I would like to update the spreadsheet via ASP then read the results of the data from Excel back to a web form.
View 9 RepliesI have a gridvidew (GV2). I want the user to be able to export the contents of this gridview to an excel spreadsheet for offline processing.
Here is my subroutine:
[code]...
On clicking the ExcelButton I get the error message:
Control 'GV2' of type 'GridView' must be placed inside a form tag with runat=server.
The control GV2 is in fact inside:
<form id="form1" runat="server"></form>
I would like to be able to copy one row and five columns from an Excel spreadsheet to a table like structure on a ASP.NET web form. The idea is keeping the data in the exact row and column from Excel to the table like control on the ASP.NET web-form. Then I want to be able to save to the contents of the ASP.NET control to a database by a buttoon command click. What ASP.NET control would allow me to do this? Gridviews and datagrids don't seem to allow me to do this.
View 1 RepliesMy host does not allow me to save files to the file system, but I would like to be able to send some reports via email as Excel attachments.
How can I generate and the file without actually saving it to disk?
I want to show information from an excel spreadsheet in a web page. The xls will have maybe 5 columns, and as many rows as needed. The columns will be 'Name', 'Created Date', 'Expired Date', 'Owner', and maybe down the road maybe more.
What I would like is for the C# to nightly read the xls, and display the information in a table on the website.
If there is a PDF available for download I am going to link that as well.
I've tried many combonations and looked over may websites for sample code but no matter what I do I only getting a few cells of data from my Excel DataSet.
CODE:
using System;
I am generating, using a ASP routine, Visual Basic, a HTML table in a file to be read by MS Excel.
After Excel reads the file, some of the numbers (in some cells) are shown as "text", not numbers: they cannot be operated upon, like decimal numbers. (added, subtracted...)
If I click in a "number" stored as "text" cell, I can "edit" the cell and remove an invisible "apostrofe" to the left of the number; after that, the "text" becomes "number" again.
Seems like Excel is inserting a non-visible character before the number, so that it is stored as "text"
It happens to some lines and not to others...
I am trying to generate an excel spreadsheet in my vb.net web service but it looks like its not allowing me. I need to generate it from xml string and send this spreadsheet in an email from the same web service.
View 1 Replies