|
One option is to use VSTO (Visual Studio Tools for Office) and create an Excel Addin. Another option is to wrap Excel and use automation - either way, you've got some serious coding ahead of you.
|
|
|
|
|
Hi Pete,
Thanks for the reply. Let me do some reserch on that.
Have a nice day
Laddie
Thanks
Laddie
Kindly rate if the answer was helpful
|
|
|
|
|
I just thought of one more option. I have already created the code to dynamically generate the web content which i am using in web apps. Is there a possibility that i can create a mht file and get it opened in Excel as different sheets?.
The excal can save multiple sheets as a single mht file. But how about the other way round ?
Any ideas..Kindly let me know.
Thanks
Laddie
Kindly rate if the answer was helpful
|
|
|
|
|
hi
how can right click on a row og datagridview and select thats row?
|
|
|
|
|
|
Hey guys
how can i put the contents of a string variable into a crystal report? ive been trying it for hours and im going no were slowly
thanx
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS
you.suck = (you.passion != Programming)
|
|
|
|
|
|
And how exactly would i go about doing that?
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS
you.suck = (you.passion != Programming)
|
|
|
|
|
Add a parameter to the report, if you load up the report in the Crystal Reports application it will ask for it...
If you load it up via .Net you can pass that parameter via a function in your code. It should be somewhere on MSDN how you can do that, it has been a little too long since I've done this stuff.
In any case it's one of the functions available with the Crystal Reports objects. Did you find the object model?
|
|
|
|
|
thanx, ill go search on MSDN
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS
you.suck = (you.passion != Programming)
|
|
|
|
|
Hello Friends,
I have a problem with print and print preview.
I am using the following code to print:
This print the image but there is one problem that it print one image on one page as i want it should print 4 images on one page so how can i do that.
Bitmap memoryImage = new Bitmap(panel1.Width, panel1.Height);<br />
panel1.DrawToBitmap(memoryImage, panel1.ClientRectangle);<br />
printDocument1.Print();
And how can i show Print Preview of these images before printing
|
|
|
|
|
You need to draw four images when you're printing, they you'll have four images. The best way to do this is to handle your onpaint event, and if you're printing when it occurs, get the printers page size and draw your bitmap four times accordingly
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
To invoke a webservice, we usually generate web referece based on wsdl generated code and use it.
Instead, if i have to dynamically invoke a web service method, given that i know the following
- URL with ip
- Service name
- port
- namespace
This is available in java, sample code given below. I need to implement the same in c#. Any pointers will be a BIG BIG HELP for me 
//URL wsdl = new URL(url);
String tempServiceName = getServiceName(serviceName);
QName serviceQName = new QName(targetNameSpace, tempServiceName);
QName port = new QName(targetNameSpace, portName);
QName operation;
operation= new QName(targetNameSpace, reqInfo.getRequestMethod());
org.apache.axis.client.ServiceFactory factory = new ServiceFactory();
//org.apache.axis.client.Service service = (Service) factory.createService(new URL(url), serviceQName);
org.apache.axis.client.Service service = (Service) factory.createService(serviceQName);
org.apache.axis.client.Call call = (org.apache.axis.client.Call) service.createCall(port, operation);
call.setReturnType(XMLType.XSD_STRING);
call.addParameter("string", XMLType.XSD_STRING, ParameterMode.IN);
//-------------settign the header
org.apache.axis.message.PrefixedQName svcName = new org.apache.axis.message.PrefixedQName("http://schemas.xmlsoap.org/ws/2002/07/secext", "Security", "wsse");
org.apache.axis.message.SOAPHeaderElement sh = new org.apache.axis.message.SOAPHeaderElement(svcName);
javax.xml.soap.SOAPElement sub = sh.addChildElement("UsernameToken");
javax.xml.soap.SOAPElement element = sub.addChildElement("Username");
element.addTextNode(userName);
element = sub.addChildElement("Password");
element.addTextNode(password);
call.addHeader(sh);
//------------
// int iIndexWsdl = url.indexOf("?");
// String strEndPointAddress = url.substring(0, iIndexWsdl);
call.setTargetEndpointAddress(url);
// String requestXML= CommonHelper.getInstance().loadFile(reqInfo.getRequestXML().trim()).toString();
logger.info("request XML:"+reqInfo.getRequestXML());
//long startTime=logger.perf("calling webservice");
long startTime= System.currentTimeMillis();
String response = (String) call.invoke(new Object[]{reqInfo.getRequestXML().trim()});
// long endTime=logger.perf("timeTaken for webserviceCall:",startTime);
long endTime=System.currentTimeMillis();
GHanesh
|
|
|
|
|
Hello,
I have a specific format of writing XML for which i use XML notepad editor. As the schema and format of XML is same and only contents differ so i want to design some tool to write the XML with predefind components.
In nutshell, i want something like class view desiner in C#. The classes are my nodes and the properties contains the information about that node. So i just pickup those predefined components(classes) from pallet, edit theire properties and add child node(class) by defining theire relationships.
The final output(export) of the file(relationship) should be in XML format.
This will give very intutive way to create and visualise process and coverted to XML.
What is the best way to implemet this concept?
I am using windows form but i don't know how can i get the components pallet view and the class designer view window?
Thanks & Regards
Gajesh
modified on Thursday, March 6, 2008 10:48 PM
|
|
|
|
|
In my book, XML is so simple that a tool like that would just get in the way.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Thanks Christian,
Which book you are talking about?
Would you please give me the online reference or other details of the book.
regards
Gajesh
|
|
|
|
|
hi all ..
i am devoloping a windows service which performs a task periodically.
For that, i used system.threading.timer. Every thing is fine but when the time to complete the given task is more than the time interval of 'system.threading.timer', then the task would be performed agian .
For that i need to stop(or pause) 'system.threading.timer ' while my task is performing.
Any body is knowing any information in this regard ,plz help me.
thanks in advance
Regards ,.
Kiran
|
|
|
|
|
If you use System.Timers.Timer instead, it has an Enabled property.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Yeah, that's what I use too. Or .Start() and .Stop()
|
|
|
|
|
Hello,
I have created an excel spreadsheet file using the ole database engine. I have it populating the file without a problem. I am now trying to insert a blank lines into the file to make the transition look better. The way I am currently doing it is
string InsertStatement;
InsertStatement = "Insert into [tabname$] (";
for(int i = 0; i < ExcelColumns; i++)
{
InsertStatement += "null";
if(i < ExcelColumns-1)
InsertStatement += ",";
}
InsertStatement += ")";
then I put that into a oledbcommand and my connection to the excel file. The the rest of it works fine. But the blank line does not.
Any help would be greatly appreciated.
|
|
|
|
|
Hi!
We can write something on the console window using Console.WriteLine. I want to write something on console in some color like Red or blue. How can i do so ?
Imtiaz
|
|
|
|
|
|
And since .Net 2 you can just use the handy properties in the Console class:
Console.BackgroundColor<br />
Console.ForegroundColor
Then just set them to Color.Red for example, background will obviously change the background colour, and Foreground will change the text colour.
My current favourite word is: Nipple!
-SK Genius
|
|
|
|
|
hi,
i want to create a backup server by using C# and MS-Sql. but dont know how i start. plz tell me complete process. if source code is available then send me that plz.
regards
tanoli
|
|
|
|
|
The complete process is that you define exactly what your program will do, then you do some reading to work out the best way to do those things, then you write the code.
What do you want to achieve exactly ? Although, this is the wrong place to ask 'how do I write this program and please send me source code'. We usually help people who have a specific problem they want help with. I'm not sure how I could answer your question in the context of a forum reply.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
