Aspose.Excel.Web 1.0 Released!
Aspose.Excel.Web 1.0 Released!
Version 1.0 Released on March 10 2005
...Excel Expert: need a good solution to fill some data into a complex excel sheet
I am stuck with a problem
The Requirement is that, there a complex Excel file(XLS) that is used as template; it has Macros and all the worksheets are either locked or hidden. When the user clicks to download it, the follows operation occurs
Unlock a particular worksheet, fill some data @ certain cells and then lock it back.
Unhide a worksheet, fill some data @ certain cells and then hide it back.
I think there are two options to resolve it (if there are more then please let me know)
Interop libraries / Excel Object Library
I cannot ...C#.NET WEB APPLICATION
hei guys, i need help on my application, i'm using C#.NET as front-ed and SQL as back-end, aside from a datagrid, i want to display my data using textboxes and not a datagrid, i can do it using Visual Basic 6 but since i'm a newbee at C#.NET i don't know how to do it, specially the codes, can anyone help me with it? thank you in advance!
If you are doing windows development, i would suggest using 'DataForm wizard' (Use Solution Explorer-->Rightclick project-->Add new Item-->New DataForm). It will guide you through steps. If you are doing web apps. Use quickstart to learn them.
h...Export data from web form to excel -- using client's excel app
I am currently trying to figure out if there is any way to export data to the client's excel app. I do not want to use the web server's excel application as it is cutting into the site's performance.
Is there any way to use something similar to the what is included below (ExportComponent.vb), but to use the client's excel app?
Public Class ExportComponent
Public Shared Sub DataToExcel(ByVal dgData As DataGrid, ByVal response As HttpResponse)
response.Charse...Submitting data from a know web form to unknown web form
hi i m making a software in which i will submitt some data from a web page that will go to a web form of which contrlos are unknown to me only i know the name and how many controls in that form it means i can see the form only. how can i do this please help me soon with code plz its very argent.i m doin this wit the help of foxtrot.xray.WebRobot but its giving me error that this dll file is already exists in The file ('C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\_foxtrot.xray.WebRobot.dll' already exists).i don know what will do so please help me soon please thanks praveen
We ca...Pull data from excel sheet into another excel sheet. Automate it
I have following requirement:-
1. Need to write a script that can be scheduled to run after every one hour.
The script should be able to pull the data from an excel sheet (saved on file system) after every one hour and replace the excel sheet already stored somewhere else with the latest contents.
Incase the new excel does not exist. it should be able to create that excel as well and populate with the data from the excel sheet being extracted from.
So, I need how to automate this script to run every one hour.
and how to pull the data from excel sheet into another.
...Urgent: i m working for a web page (C#) that use for importing excel sheet data to database tables.....i wanna validation for each column data......
i m working for a web page (C#) that use for importing excel sheet data to database tables.....i wanna validation for each column data......
want suggstion/links/code....plz help me!
I didn't understand your question properly but If you want validation on Excel sheet than add text box and write the validation code in the VBA for the click event.
you haven't specified what kinda database you are using and kinda validations you want to perform, still here are some
of the links which do the work for you, check them out those might be helpful.
http://www.vbdotnetheav...Problem in read data in excel sheet
Hi all,I'm using OLEDB to reading data from an excel file, using connection string below:OleDbConnection
conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + FileName + ";Extended Properties= 'Excel 8.0;IMEX=1'"); OleDbCommand command = new OleDbCommand("Select * from [ItemDetails$]", conn);In my Excel sheet, one column contains data like this. :2424245900,PDD012000,IXX088700.my code reads this value: 2424245900.But Its return empty string while reading NXX012000,IXX088700Help me, its urgent. Thanks in advance.. ...Implementing .Net Form into an APS.net web form, can this be done
I am new here, but have been searching for a while, and may not have the correct lingo to find what I am looking for.
I am tasked with implementing a .exe application that was writen vb6 then converted to .net into a new website my team is developing. The idea is to put each of the 3 different forms in this .exe application of 3 different .aspx pages. I have attempted multiple things to get this into the page and even started to just rewrite it as an ASP.net web form, but even then I can't reuse any of the code since the System.Web.UI.Page doesn't inherit the sa...synchronizing chunk of data of one web form for another web form
I'm making a web application. In one web form; i'm taking inputs from user. Now; there is some info given by user in this page which is needed for web form which is going to be displayed next. i want to display that info automatically on that web form so that user doesn't have to re-input that info in this next web form.
Info from first page would be inserted into database when user clicks on the submit button. then that next web form would be displayed. and the chunk of info from previous page should be displayed there!!! how can i do this??
cany anybody help??
nobody can help me!!
I...Generating filled up PDF forms from web app
Hi everyone, I have a .NET 2.0 web application and need a PDF writer to query fields from a SQL Server database and output a PDF document containing this data. The PDF document is a nicely-formatted application form something this (note: example only), which should have several fields filled out from the database data (eg, name, date of birth, etc).
This whole process should be transparent to the user (ie, user should not have to install any software on her end, or launch any third party software besides her IE browser).
Is this something that SQL REporting Se...Problems with the .NET 2005 web form designer
In Visual Studio.NET 2003, building a web page was very similar to building a plain old form. In 2005, everything's changed. Every control gets shifted to the top left, I have to use panels and so on to separate things, and if I have to change something later it's an absolute nightmare. Am I really stuck with this, or is there some switch somewhere that will allow me to do things the way I'm used to?
Bring up an aspx page in design (not source) mode. This will enable the Layout menu.
Goto Layout->Position->Auto-Pos...Exporting data from web form to excel file
I have a page with datgrid and one button called export into excel.
I use this code to export data into excel sheet. If my excel file size become more then 50k then i am having error and i can not open or save the excel file.
Here is the code:
Server.ScriptTimeout = 12000 Response.ContentType = "application/vnd.ms-excel" dvwdetail = GetSQLData(VSQL) grdapex.DataSource = dvwdetail.Tables(0) grdapex.DataBind()
If i have less row means the excel file size is less then 50k then it works fine but if i have more data file size is more then 50k then it give me error m...Problem parsing web form generated querystring
Hi all,I am having trouble retrieving the value of the first key in a query string using the Request.Querystring method.The problem is on a 404 handler page. In a nutshell the request proceeds as follows:1) Form data posts to URL (for example) http://www.somesite.com/someurl/thatdoesntexist/?value1=foo&value2=bar 2) IIS cant find the page so it sends the request to www.somesite.com/404handler.aspx3) Retrieve the values of value1 and value2 in 404handler.aspx ie: HttpContext.Current.Request.Querystring("value1") / HttpContext.Current.R...