|
Hi ,
i went hro an article here at
http://www.codeproject.com/csharp/Export.asp[^]
There the dynamic creation of an excel sheet has been coded...
But my question is,Is it possible to define the datatypes of each column we create in the excel sheet?
Kindly help...Thanx....
|
|
|
|
|
I do it this way
App = New Excel.Application()
Doc = App.Workbooks.Add
Sheet = Doc.Sheets(1)
Sheet.Range("J1").AutoFormat()
|
|
|
|
|
What is that Doc?
cud u tell me........
|
|
|
|
|
Hi friend,
Am working with C#(windows form)....
Cud u explain ur answer in C#?
thanx..
|
|
|
|
|
Search MSDN and Google for MS Office PIA.
|
|
|
|
|
hi mahi
Please try this, u can get export the records into excel.
Response.Clear();
Response.Charset = "";
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.ContentType = "application/vnd.ms-excel"; System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
DataGrid dGrid[object]= new DataGrid();
dGrid.DataSource = name[class name].GetAllDetails(); dGrid.HeaderStyle.Font.Bold = true;
dGrid.DataBind();
dGrid.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
Bye
Naren
|
|
|
|
|
Hi naren,
i can export datas to excel..but i could nt define the datatype for these datas at runtime..thts the problem..
Moreover,am working with windows form with c#...
Cud anyone tell me the solution...
Thanx.......
|
|
|
|
|
Dear All,
I need to open a popup on the click of another popup here popup does not refer to popup window. This is on urgent basis.
Regards
Bipin
|
|
|
|
|
Hi,
I've some issues using property grid features, more specifically removing properties from the propertyGrid's selected object.
I want to edit the properties of the class at runtime, and dynamically remove some of them depending on some criteria. The attribute [Browsable(false)] does
not do what I need since it does not allow me to dynamically select what to remove, and invoking Properties.Remove in the component.PreFilterProperties method
is more what I'm looking for.
Unfortunately, and contrary to all the msdn's articles I've read on the subject, what I'm doing is not working as expected.
Here is a snippet to illustrate my point :
--------------------------------
entity = new Entity();<br />
entity.MyValue = "Hello world !";<br />
propertyGrid1.SelectedObject = entity;<br />
<br />
[Designer(typeof(Entity.EntityDesigner))]<br />
public class Entity : Component<br />
{<br />
public Entity()<br />
{<br />
}<br />
<br />
private string myValue;<br />
public string MyValue<br />
{<br />
set { myValue = value; }<br />
get { return myValue; }<br />
}<br />
<br />
public class EntityDesigner : Component<br />
{<br />
public EntityDesigner()<br />
{<br />
}<br />
<br />
protected override void PreFilterProperties( IDictionary Properties )<br />
{<br />
base.PreFilterProperties( Properties );<br />
Properties.Remove("MyValue");<br />
}<br />
}<br />
}
--------------------------------
The 'entity' class is never instantiated, and I suspect this is because it will only be done at design-time and not runtime,
could you confirm this ? Or am I missing something else ?
Thanks for the help,
Julien
|
|
|
|
|
|
Oups sorry about that, propertyGrid1 is a System.Windows.Forms.PropertyGrid control.
|
|
|
|
|
I loaded an image into a PictureBox control. But next time I want to unload it. How can I do that? Thanks!
I'm ...
a fan of Manchester United
a fan of Ozzy Osbourne
a King of Nothing
|
|
|
|
|
if(pictureBox1.Image != null)
{
pictureBox1.Image.Dispose();
pictureBox1.Image = null;
}
|
|
|
|
|
It works! Thanks again!
I'm ...
a fan of Manchester United
a fan of Ozzy Osbourne
a King of Nothing
|
|
|
|
|
Hello frends!
Im currently working on a simple web form when suddenly it hangs when i run it (1st time). I tried debuging but i dont think there's something wrong as it passes through Page Load. My Page Load doesnt do much xcept populate my 2 dropdownlists with texts and thats about it. Im scrapping through this one looking at web for designer, my html, even tried creating a new form with similar codes but it still hangs. Can someone pls help me...tnx so much!!!
Aim small, miss small...
|
|
|
|
|
Nevermind I found it...apparently in my html one of my dropdownlists was out of the <form> scope. Tanx!
Aim small, miss small...
|
|
|
|
|
Hi all
I working a Console Application.
I must hide Commmand prompt when start application.
How can i hide command prompt(dos prompt)?
Please,help me!!!
Thanks
|
|
|
|
|
You'll have to explain this better, because a Console Application can't run without the Console Window. What on earth do you mean by "hide the command prompt"?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Try executing prompt $s in the command line before running your application
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
I have created a ContextMenuHandler to show an additional menu item in the File Explorer when someone right clicks on a file (similar to winzips additions, or cut, or copy). This works fine. I actually followed an example from this site.
I added a registration function to additionally register the handler to work with Folders as well as files, so that when you right click a folder, it also shows the additional menu item. While this works under most conditions, the problem I am having is that the handler's IContextMenu.InvokeCommand() method is getting called when you click the Windows key + "e" (this brings up the file explorer normally). This is somehow preventing the file explorer from being launched at all when activated this way. I can still run the file explorer by navigating to it's shortcut, but it won't launch using the method I show above as long as I have my handler registered to add to the context menu for folders.
Any ideas?
|
|
|
|
|
Hi, anyone there, who knows a code snippet, in which a word doc document is converted to txt ?
I just want to extract the plain text of a doc and put it in a bytearray, without using external tools. I tested the "automating word" :
Link: http://www.dotnet247.com/247reference/msgs/26/131289.aspx[^]
But this doesn`t function with ASP ;(
I get a "access denied" Errormessage. I tried then to change the rights of the ASPNET User in dcomcnfg , but there is no "Microsoft Word Document" in DCOM ????
Anyone an idea ??
Thx
Hans.
|
|
|
|
|
i still have this " access denied" error ! I gave a lot of users full rights in the security tab:
Administrators
ASP.NET Machine Account
IWAM_Machinename
Interaktiv
IUSR_Machinename
everyone
System
But with no success...
I changed the identity from the user, who starts the application in my actual WinXP-useraccount...stilll the same error !!
No one there with an idea ?
|
|
|
|
|
Does BindingSource.Filter support wildcards? I have tried *,% and ? but none of them work.
|
|
|
|
|
Well always when you post a question you find the answer. I had to use LIKE instead of = when I used the wildcard (%).
|
|
|
|
|
Can you use framework 2.0 with visual studio 2003?
I just ran a bunch of service packs and installed framework 2.0.
Now, I open an C# web app and I get an error:
"Visual Studio .NET has detected that the specified web server is not running ASP.NET version 1.1."
"You will be unable to run ASP.NET web applications or services"
I did the aspnet_regiis.exe -i and thought that 2003 would be compatible. Am I wrong or is there something that I need to change in my solution or project file?
Thanks Much.
Will
|
|
|
|