|
Hello All,
I am working on ASP.NET 2008 (C#) and I have to display data in ExcelSheet on IE.
I have some data and thro which I create Excel file in code behind. This excel file has some formulas also.
Now I need to show this Excel file on IE and if any changes made then all the related Formulas must be fired and updated file should be display.
Can someone help me ....
Thanks in advance...
|
|
|
|
|
You're not talking about prompting the user to either open or download the file the typical web way are you?
Because if you are not then you'll want to make a web version of excel... pretty much like spreadsheets on Google Docs... And I bet that is complicated and took *some* time.
Anyhow, I guess you'd have manually render a table, link it to a stylesheet for coloring and such, then attach events or javascript [I'd personally go for AJAX] to cells which contain formulas on the excel file, etc.
Now, processes for reading from/writing to Excel files will vary depending on whether your excel file is 97-2003 version or an OOXML one...
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
IE have its in-build mechanism for opening an excel file.You no need to worry about how to open it. Only give proper path in browser.
User gets option for "Open" or "Save". If user opts for save that excel file is saved to user's system and if users opts for "open" the its opened into browser automatically!!!
Thanks,
Arindam D Tewary
|
|
|
|
|
I have face a problem on java script that is not working in FF but well work in IE See the URL below.when i give user name and password and press enter then it go to search button.but i set it on LogIn buttton by java script.Please help me.
http://demo.culturaldna.com/newaccount.aspx
Vishal Rastogi
|
|
|
|
|
Install FireBug, a addon for firefox. It allows you to debug JS
|
|
|
|
|
As far as I tested, which is a couple of times, it works perfectly fine in Firefox 3.0.
In my last ASP .NET development I also had a lot of trouble with the way IIS renders html and js when the requester browser is Firefox 2. But I assumed by now, the vast majority of FF users will have already upgraded to version 3.
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
I have seen many people saying this. I never had any issues with firefox. There won't be much issues if you follow W3C standards for designing your HTML.
|
|
|
|
|
You will surely have many issues with IE if you design following W3C standards, sadly.
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
I want to navigate the user to a new page, how to do this.
It is when the user clicks a button.
|
|
|
|
|
onclick=" location.href='URL' "
It's my life
|
|
|
|
|
i want to add the code to my aspx.cs file, not by using java functions...
|
|
|
|
|
Response.Redirect("NewPageName")
|
|
|
|
|
thanx !
|
|
|
|
|
or
response.redirect("page.aspx");
We are not a Code Charity
|
|
|
|
|
Response.Redirect("PageName.aspx")
Sathya
|
|
|
|
|
Hi i have searched in net,
But i didnt get proper solution...
I have to maintain scroll position for my gridview...,
My gridview which is in inside panel...,
The panel having scroll auto event...,
In my gridview i didnt use any template or button colums...,
Now when i click a bound column it have to maintain the scroll position on that row?,
hwo to do that?,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
Repeat Post
We are not a Code Charity
|
|
|
|
|
|
I need a column in GridView to be invisible. I tried with some code and its throwing some error. Can anyone help me with this...?
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
modified on Friday, June 27, 2008 2:58 AM
|
|
|
|
|
<asp:BoundField DataField="id" Visible="False"
surely its the above,
We are not a Code Charity
|
|
|
|
|
But now if you plan on do that then don't even think about recovering the cell's value on code behind.
At least I've never been able to... 
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
Ariel Kazeed wrote: ecovering the cell's value on code behind.
What do you mean?
We are not a Code Charity
|
|
|
|
|
I mean something like...
Integer ID = Gridview.Cells[0].Text
That would throw an exception. Yes, ASP.NET knows there is a column there even though you cannot see it. Problem is, since the value of that particular column is not printed on the page, it only exists at databinding time. Hence, in this case GridView.Cells[0].Text returns "", that's what I meant.
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
Hi all,
I am trying to bind teh datagird with a datset at run time I tried the following code but I m not getting any data in datagrid. Can anyone please provide me the correct code. The code is
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim Productds As New DataSet
Dim m_DataAdapter As New SqlClient.SqlDataAdapter( _
"query", "connectionstring")
Dim m_DataSet As New DataSet
' Fill the DataSet.
m_DataAdapter.Fill(m_DataSet, "Demo")
' Bind the DataGrid to the DataSet's first DataTable.
ProductDG.DataSource = m_DataSet.DefaultViewManager
ProductDG.DataMember = "Demo"
End sub
Thanking You!
Rock Star
|
|
|
|
|
Rock Star. wrote: ' Bind the DataGrid to the DataSet's first DataTable.
ProductDG.DataSource = m_DataSet.DefaultViewManager
ProductDG.DataMember = "Demo"
May be you missed something,
' Bind the DataGrid to the DataSet's first DataTable.
ProductDG.DataSource = m_DataSet.DefaultViewManager
ProductDG.DataMember = "Demo"
ProductDG.DataBind()
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
