I have a excel template(.xlt), and i want to do custom validation for this can i use macro,I am doing coding in c#,When i pressF11 in visual stdio it opens the macro editor of visual stdio but not of excel...Is there any way to add macro or UDF so that i can use User Defined Function in custom validation of excel.
View 2 RepliesI want to design it in windows application form of Visual Stdio 2008
View 2 RepliesI've got an .rdlc report which I print from my .net app (C# Visual Studio 2005), where I use a RemoteReportPrinter object. I give it as parameters the server name, report name, report parameters, etc. Works fine. My question is, I would live to do an analagous export of that report to Excel. Set it up exactly the same, but have it export to Excel rather than print, probably using some other type of object than RemoteReportPrinter.
View 1 RepliesI'm totally new to ASP.NET ( as a VC++ 6.0 engineer ), I have just downloaded the express edition of 2010 web developer and cannot find for the life of me the correct project template to create an ASP.NET webservice.. in 2008 it appears there is an option for this .. however I cannot find it in 2010..
View 3 RepliesI want how to upload the excel sheet data and that data will save in Sql Server 2008(table).
View 2 RepliesHow is it possible to open an excel template (Which has a small text of hello) from the server onto the client machine?
View 2 RepliesI spent a few hours on google now but what I found was pretty crappy, most stuff 3 years old and not using a ms excel template so hence I writer here now.
The problem is to dump my dataset into a ms excel worksheet using the great worksheet template I already designed.
the browser should then prompt the user with the download. - I dont want to store it on the server.
I dont just want to throw the dataset on the sheet either, but do each cell individually . so e.g. UPDATE F3:F5 value ="Mike Testable",
UPDATE F3:F5 value ="Please sign here MR" + user.id
whereas F3 is formatted in the ms excel document.
how is that done the most efficient way, using .net 2 ? ..I head office objects is one way but was not able to find a template attribute that lets me define a template.
1. I have to generate multiple report in excel from c# code.
2. layout and format varies from report to report.
3. Some of the report has complex format like cell merge, cell color.
4. Is there anyway I can define template and populate data for c# code?
1. I have to generate multiple report in excel from c# code.
2. layout and format varies from report to report.
3. Some of the report has complex format like cell merge, cell color.
4. Is there anyway I can define template and populate data for c# code?
I am running .net 4.0 asp.net app on IIS 7. I want to know if there is an easy way of adding rows to an excel 2007/2010 (not too fussed) template file that a user can download from the server.
For example, the user might check a couple of tick boxes and clicks a button on the web page. The server does a sql query on a table and comes back with the results. I have an excel file with some headings, column titles, formatting etc. on the web app's resources directory. I want to make a copy of this file, insert each of the results as a row into this file (insert first name into cell A3, last name into cell B3 etc.). And make it available for the user to save on their disk.
Since Excel (xls) format is an "Open format", I was wondering how easy/straight forward this would be. Is it a matter of loading the excel XML DOM and inserting XML elements? What are libraries I need to use?
My requirement is, to open existing .xls template, write data to some specific /fixed cells to it and make it available for download.In case if I will use "Excel.Application", then at the time of deployment is it necessary that Server should have Microsoft Office installed?
View 2 RepliesI have a gridview that I need to export to Excel. Excel is not installed on the server, but I would like to put a template on the server so that when the user exports the data it will use the template and open the file on the user's local machine.To make things slightly more complex, I need to export the data to Sheet2 because Sheet1 needs to be a graph (thus the need for the template).I cannot use any third party software and I have no ability to modify anything on the server. This is used in a corporate environment on a shared server that I don't have any control over.
View 4 RepliesWhen I click on New Project-> Visual Basic (or C#)-> Web, the only options i get is AjaxControlExtender, AjaxServerControl and ASP.Net Server Control. How do i get the ASP.Net WebApplication option to show up?
View 2 RepliesI'm trying to learn ASP.NET MVC, but have discovered that I don't even have the ASP.NET MVC 2 Web Application template installed. I'm using VS 2010 Ultimate (10.0.30319.1 RTMRel). How do I get this installed so I can begin?
View 6 RepliesIn Visual Studio 2010, I don't see the Visual Studio installed template to create an ASP .Net Web Service Website (when I click on File->New->Web Site..) if the target framework is 4.0. However if I switch to FW 3.5 or lower, I do see the template.
View 1 RepliesToday in one of the computer i installed visual studio 2010 professional edition, and successfully installed. But in my new project template "Asp.net MVC 2 website" is missing. Also I'm not able to open an already created MVC 2 project also. I'm also having MVC 2 installed with VS 2008 Sp1 in the same machine and is working fine. I uninstalled and installed again, the same is happening.
View 3 RepliesI just installed Visual Studio 2010 on my Windows 7 laptop in order to start learning the Entity Framework. For some reason that I haven't been able to figure out, when I try to add a new item, there is no template for the ADO.NET Entity Framework. Why the template doesn't exist and what I need to do in order to get the template? I came across a post that stated that in order restore the template that I needed to do the following:
devenv /installvstemplates
How would I do visual editing of a template for a control X that is embedded within a user control?.
Of course, in this case the Control X is not directly available to the end user.
NOTE: I do not want to create another user control to the template.
I installed Telerik component set and was impressed with their project template. how to write a simple one, giving me a clear way to get started.
View 1 Repliesi am using VS 2008, whiile working on the walkthroughs of restful services(http://msdn.microsoft.com/en-us/library/dd203052.aspx), i did not find any template for the ADO.net services. Could you please direct me to the link where i can download/install the required template or package.
View 1 RepliesI want to change the default formview generated template. I don't mean change the itemtemple on each page, I mean what VS generates when ever you databind the formview. I want to change it so it uses <label...>xxx</label> instead of xxx <asp....
View 2 RepliesI have a DetailsView control in a VS2010 project. There are 20 fields, most of which have been converted to template fields. However, when I right click the control and choose Edit Template, I only see the first 15. I cannot choose to edit any of the template fields beyond that. The fields work when I run the project, but I cannot edit them via the designer. Is this by design or is something corrupted?
View 2 RepliesHas anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.
View 6 RepliesIs there an ajax enabled website template?
View 7 RepliesWhen I use TT files to generate code, output files within Websites ar never properly generated. The resut is always some "Chinese character garbage", and the generated extension is always .cs (whatever the given outputextension may be)Generating text files works fine in class libraries, MVC websites and other "projects".Just not in plain websites. Is this a known issue, am I forgetting some swith or doing something wrong, can or can I not fix this?UPDATE: It seems to be a problem with the Tangible T4 Editor, after uninstalling this tool, it seems to work fine. However, I've lost syntax highlighting and intellisense then.Since this is an external tool, I don't think this forum covers that scope.
View 4 Replies