|
In the past I have used NPOI for .xls and eeplus for .xlsx
xlsx has been around for a good while now and isn't going anywhere so if possible I would suggest insisting on .xlsx and using eeplus.
|
|
|
|
|
|
Thanks, but before I dive into it, which one of these ...
a. doesn't require client installation of driver library
b. if we do need driver library, 64 bit compatible? (For instance I heard Excel interop not 64bit friendly)
dev
|
|
|
|
|
|
how can I dedicate a Data source to a chart manualy ??
(by writing commands and not by wizard?)
tanx a lot.
|
|
|
|
|
|
How do you add the:
="1.0"="utf-16"
<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns="http://website.RFGCommonSpecListingSchema" xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://rfg.realogy.com/Btt/Listingfeed/Import/2011/07.RFGCommonSpecListingSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
for the headers with Xelement?
|
|
|
|
|
by using the XmlSerializerNamespaces[^] you can add the namespaces to your Xmlheader.
sample:
XmlSerializer serializer = new XmlSerializer(typeof(OrderedItem));
OrderedItem i = new OrderedItem();
i.ItemName = "Widget";
i.Description = "Regular Widget";
i.Quantity = 10;
i.UnitPrice = (decimal) 2.30;
i.Calculate();
XmlSerializerNamespaces ns =
new XmlSerializerNamespaces();
ns.Add("inventory", "http://www.cpandl.com");
ns.Add("money", "http://www.cohowinery.com");
Stream fs = new FileStream(filename, FileMode.Create);
XmlWriter writer =
new XmlTextWriter(fs, new UTF8Encoding());
serializer.Serialize(writer, i, ns);
writer.Close();
Jibesh V P
|
|
|
|
|
Using XElement from System.Xml.Linq :
XNamespace root = "http://website.RFGCommonSpecListingSchema";
XNamespace xs = "http://www.w3.org/2001/XMLSchema";
XNamespace b = "http://schemas.microsoft.com/BizTalk/2003";
var doc = new XDocument(
new XDeclaration("1.0", "utf-8", null),
new XElement(xs + "schema",
new XAttribute("xmlns", root.NamespaceName),
new XAttribute(XNamespace.Xmlns + "b", b.NamespaceName),
new XAttribute(XNamespace.Xmlns + "xs", xs.NamespaceName),
new XAttribute("targetNamespace", "http://rfg.realogy.com/Btt/Listingfeed/Import/2011/07.RFGCommonSpecListingSchema"),
new XAttribute("elementFormDefault", "qualified"),
new XAttribute("attributeFormDefault", "unqualified"),
)
);
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
How to put videos, with alpha channel, on the image using Windows Forms c#
|
|
|
|
|
I've been looking at a problem for the last couple of days, that hopefully someone has an answer for. When I get my variable (cr) as shown below, I can't use the variable and then step into the next method call and code that once worked is now not working. When I look into the class definition inside cr, it says "could not evaluate expression" edfed for the variable inside the class (cr).
I've searched the internet and found a couple of sources that seem to be saying that I have something that's null, but I'm not seeing why edfed would be null here.
http://stackoverflow.com/questions/9558498/could-not-evaluate-expression-activator-createinstancet[^]
This is where I obtain my class definition of cr:
cr = factory.GetCR(type);
I can show you the factory GetCR method, but I don't think there's an issue there:
public iCR GetCR(CRType type)
{
iCR cr = null;
switch (type)
{
case CRType.CR5:
cr = new CR5_new.CR5();
break;
}
}
In my CR5 class, this is how I define edfed. (It's possible that I could do something more in a C# way here and less of a C++ way like I'm familiar with; feel free to make suggestions):
using Sec_;
namespace CR5_new
{
public class CR5:iCR
{
Sec edfed = null;
public CR5()
{
edfed = new Sec();
System.Diagnostics.Debug.WriteLine("edfed definition: " + edfed);
}
...
I also tried defining edfed in CR5 as follows and get the same result:
using Sec_;
namespace CR5_new
{
public class CR5:iCR
{
Sec edfed = new Sec();
public CR5()
{
System.Diagnostics.Debug.WriteLine("edfed definition: " + edfed);
}
...
I'm hoping someone has a good suggestion of what I could do to fix this. It's really stumping us. Thanks.
|
|
|
|
|
cr = factory.GetCR(type); This looks to be the likeliest culprit. The question I'd have here is what is the value of type? In your switch statement, it only retrieves this value if it's CRType.CR5. If it's not that type, then it doesn't look like you're returning anything.
|
|
|
|
|
On top of that, there is no
return statement in that method either, so no matter what happens in that method it's returning null .
|
|
|
|
|
Thanks for the idea, but I don't think that's it. The rest of the factory method/case statement looks like this:
default:
throw new ArgumentException(string.Format("A CR of type {0} cannot be found", Enum.GetName(typeof(CRType), type)));
}
return cr;
It also couldn't be that because the rest of the variables associated with the cr variable returned from the factory look good when I mouse over and expand it when I run the program. It's just the edfed one that's an issue. No exception is thrown in the remainder of the case statement above, so it's not getting to the default. Any other ideas??
|
|
|
|
|
Put a break point in the constructor of the class you're trying to instantiate and see if it gets hit. Similarly, put a break point in before the factory method. As you've shown us incomplete fragments, we can only guess, and I suspect that your problem lies elsewhere.
|
|
|
|
|
When I try stepping into
crum = new CR5_new.CR5();
it (=>)goes to the break statement that comes after the line shown above and the output window is showing:
Step into: Stepping over method without symbols 'CR5_new.CR5.CR5'
Any idea why the constructor of CR5 wouldn't have symbols? It's built...
|
|
|
|
|
Your using terminology that doesn't mean what you think it does, so your post is a bit confusing. For example, "This is where I obtain my class definition". "class definition" is the actual Class myClassName block, not creating an instance of a class, which is normally refered to as an "Object".
If these snippets are not edited to remove what you think is irrelevent code to this problem, it's amazing this code ever worked at all.
Your GetCR method (terrible name by the way), shows that it should be returning either an object of type iCR or one that implements a possible iCR interface. There isn't enough codce snippet to be sure either way. But the method has no return statement in it, so it's always returning null.
Also, what is the value of type that you're passing in?? Is it really CRType.CR5?? If you're wrong, the method will, again, return null.
Oh! When asking questions about your own code, a copy'n'paste or the error message as well as the stack trace would be very helpful.
As of right now, it's impossible to know for sure what your problem is as there is insufficient detail. So, put a breakpoint on the line that throws the error and run your app. When the code stops, hit F11 to step into the next line of code and watch the execution and explore the contents of variables to see if the code is really doing what you think it should be doing. Chances are really good it'll show YOU that you're making incorrect assumptions about the execution of your own code.
Instead of guessing at what the problem might be, you better prove to yourself that it is indeed the problem by stepping through the code as outlined above. Oh, and learn to read the stack trace! These are critical skills you must have in order to write code.
|
|
|
|
|
Dave, thanks for the thoughts. I'm sorry my code is confusing to you. The class names have been shortened because I don't want to give away secure info. All code snippets are edited to remove code that isn't relevant. See my reply to the other response to this question for the rest of the factory method that shows what the default is if it doesn't fall into a case. Unfortunately, as I said, I can't step into the code that has the error message for some reason, and can only see it by exploring (with + for the cr class) during execution of the code (after I obtain the cr from the factory), and it shows up that way. I posted the error message in the subject and also in my problem statement. I'll look into whether it has a stack trace. Good idea.
|
|
|
|
|
MichCl wrote: can't step into the code that has the error message for some reason, and can only see it by exploring (with + for the cr class) during execution of the code (after I obtain the cr from the factory), and it shows up that way.
Is it defined in the same project (as source), or does it come from another assembly that you linked to?
MichCl wrote: I posted the error message in the subject
I get this one often, usually when I choose "Evaluate" in the IDE. It's not an exception, it's merely a message from the IDE that it cannot predict the outcome.
|
|
|
|
|
cr5, icr, factory, sec, and the code that calls the factory get method are all separate dll's (compiled separately), but I own them (I own everything being run). Different projects.
I used to be able to step into the cr5 code, and would expect to be able to step into the constructor/variable definition area, but for some reason it's not working. (message is step into: stepping over method without symbols 'cr5_new.cr5.cr5' shows in output window)
I looked into this message, and found a couple of links:
[^]
http://stackoverflow.com/questions/1495720/stepping-over-method-without-symbols-how-to-step-into[^]
I do have a pdb file for the cr5 build. I can't put a breakpoint in cr5 because the debugger is stepping over it and the implementation is in a separate project.
It seems that you think the error message in the subject isn't my issue. If I could figure out how to step into my cr5 class, that would help me figure out what the issue is. Thanks!
|
|
|
|
|
Are all thes eprojects in the same solution or are they seperate solutions?? Is everything compiled Debug?? Are you referencing the .DLL's in the other projects directly or are you referencing the projects themselves??
|
|
|
|
|
Thank you for the suggestions. The projects are separate solutions. They are all compiled debug, according to Build->Configuration Manager->Configuration . I reference the .dll's in the other projects directly (Solution Explorer->References->Browse to the .dll of the other project). It's possible that I am implementing a more C++-centric solution and that there is a more c# way that would make the project more stable, and I'd be open to that idea. It could also be that there's another setting somewhere in the project that got messed up...
|
|
|
|
|
When you reference the assemblies in your project, if they are in the same solution, it's a great idea to make sure that you have added them as project references, rather than browsing to the DLLs and selecting those. One thing I would check - do a clean on your solution (make sure you actually remove the bin directories as well), and then do a full rebuild - look to see if the pdb file for the cr5 assembly has been copied into the bin directory of the executing process.
|
|
|
|
|
When you say it's better to add them as project references, could you clarify this? You're not talking about going to Solution Explorer->References->Browse to other solution dll?
|
|
|
|
|
In the References dialog you can pick what you want to set a reference to. That includes Browsing to a .DLL, a registered .NET assembly, or another project.
The thing is that project needs to be part of the solution you're currently in. It would be better for you if you added these other .DLL projects to a single solution.
|
|
|
|