C# Discussion Boards - CodeProject

Hi,

This is what i have done till now...

C#

var myWord = new Microsoft.Office.Interop.Word.Application();
           var myDoc = new Microsoft.Office.Interop.Word.Document();

           object missing = System.Type.Missing;
           try
           {

               object FileName = @"D:\Declaration.docx";

               myDoc = myWord.Documents.Open(ref FileName,
                   ref missing, ref missing, ref missing, ref missing,
                   ref missing, ref missing, ref missing, ref missing,
                   ref missing, ref missing, ref missing, ref missing,
                   ref missing, ref missing, ref missing);

               myDoc.Activate();


               foreach (Microsoft.Office.Interop.Word.Range tempRange in myDoc.StoryRanges)
               {
                   tempRange.Find.Text = "@DonorName";
                   tempRange.Find.Replacement.Text = "Sandeep D Shenoy";
                   object replaceAll = Microsoft.Office.Interop.Word.WdReplace.wdReplaceAll;

                   tempRange.Find.Wrap = Microsoft.Office.Interop.Word.WdFindWrap.wdFindContinue;


                   tempRange.Find.Execute(ref missing, ref missing, ref missing,
                       ref missing, ref missing, ref missing, ref missing,
                       ref missing, ref missing, ref missing, ref replaceAll,
                       ref missing, ref missing, ref missing, ref missing);

                   tempRange.Find.Text = "@Date";
                   tempRange.Find.Replacement.Text = "01-01-2013";
                   tempRange.Find.Wrap = Microsoft.Office.Interop.Word.WdFindWrap.wdFindContinue;


                   tempRange.Find.Execute(ref missing, ref missing, ref missing,
                       ref missing, ref missing, ref missing, ref missing,
                       ref missing, ref missing, ref missing, ref replaceAll,
                       ref missing, ref missing, ref missing, ref missing);

                   tempRange.Find.Text = "@Telephone";
                   tempRange.Find.Replacement.Text = "1234567890";
                   tempRange.Find.Wrap = Microsoft.Office.Interop.Word.WdFindWrap.wdFindContinue;


                   tempRange.Find.Execute(ref missing, ref missing, ref missing,
                       ref missing, ref missing, ref missing, ref missing,
                       ref missing, ref missing, ref missing, ref replaceAll,
                       ref missing, ref missing, ref missing, ref missing);

                   tempRange.Find.Text = "@Email";
                   tempRange.Find.Replacement.Text = "abd@gmail.com";

                   tempRange.Find.Wrap = Microsoft.Office.Interop.Word.WdFindWrap.wdFindContinue;


                   tempRange.Find.Execute(ref missing, ref missing, ref missing,
                       ref missing, ref missing, ref missing, ref missing,
                       ref missing, ref missing, ref missing, ref replaceAll,
                       ref missing, ref missing, ref missing, ref missing);
               }

               myDoc.Save();

               // Close the doc and exit the app
               myDoc.Close(ref missing, ref missing, ref missing);
               myWord.Application.Quit(ref missing, ref missing, ref missing);
           }
           catch (Exception ee)
           {
               myDoc.Close(ref missing, ref missing, ref missing);
               myWord.Application.Quit(ref missing, ref missing, ref missing);
           }

I replaced 4 Texts from the document and replaced it with values, but this document has to be reused many times. So is there any way to bypass that ?

You should be able to figure out that by this link from the Microsoft documentation
http://support.microsoft.com/kb/316384[^]

Hi ,

I have a windows application developed in dot net 3.5 framework where i am importing and exporting data to excel.I am using Microsoft Office interop excel and have added the version 14.0 as reference to my application. When i run this application on a machine having Office 2007 ( version 12.0) my application does not work. My question is why is it having this issue and why am i getting an exception 14.0 could not loaded

The interop libraries are different between 12 - and 14, hint that is why they have versions!

There is a reason we NEVER, EVER, under ANY circumstances use Office products in any of our solutions. MS has no compunction breaking systems going forward let alone backwards compatibility.

Never underestimate the power of human stupidity
RAH

I though you could include the Dll that will make an Excel file in your solution, so regardless of wheter or not you had Excel install, it would create the file, or?

To be honest I am not up with the latest Office capabilities - for obvious reasons, I'm assuming you are talking about the Interop files which can be included with the app but I'm dammed sure they are not compatible between versions which is the OPs issue I believe.

Never underestimate the power of human stupidity
RAH

When I went to collage I learned that you should always create a new Excel Object without using Interop, as different Excel versions wouldnt be compatible otherwise, i.a. programming without intellisence. I did some internal programming for a company, and I can tell you that it was a nightmare with just 10 useres... When I found out that one of them had Excel 2003 and the rest had Excel 2005 (or soemthing like that) I just included the dll, the Library 12, and It all worked as expected. However I would never recomend doing this on a massive scale...

which office version i should add to C# application as reference to work with excel 2007 and higher keeping the excel 2007 to be installed as prerequisite to run the application.

In my experience (which is not perfect in this area) I would target the 2007 version of Excel, add this version as a DLL resource that follows the exe file you produce. That way it should be able to write files that are compatible with any newer excel file, however you might have a problem in reading newer excel files this way....

Create a Primary Interop Assembly (PIA) with an old version of Excel (2007 or older), and use that for your coding. Newer version are normally backwards compatible. I use a PIA generated with Office XP, and do not encounter problems with Office 2010.

Not claiming any expertise on this, but instead of:

Microsoft.Office.Interop.Excel.Application app = new Excel.Application();

you may want to try this code sequence. I believe this will find the relevant info from the system for the installed PIA's and create the appropriate instance.

Type ExcelType = System.Type.GetTypeFromProgID("Excel.Application");
Microsoft.Office.Interop.Excel.Application app;
app = (Microsoft.Office.Interop.Excel.Application)System.Activator.CreateInstance(ExcelType);

I think this is the method [^]Kenneth described.

Hi,

I need to build a system that detects the availability of the parking space for 2/4 wheelers.

I will not be using the RFID to detect the availibity though.

The points that I have in my mind are :

1.The pressure sensors (or any other sensor) to be installed on the parking place.
2.The space will show green when no car is park on the monitor installed at the entry of the parking
3.As soon as the car gets parked on the space, the area will be marked as red on the screen which means the space is no more vacant.

The purpose of the system will be to save time looking out for the parking spaces and wasting precious fuel Smile | :)

Hope I get some help here

Regards
Ashu

This is a solved problem, there are systems out there that tell you how many spaces are left in a parking station, although I wonder if they are simply working on a count in/out.

Why not consider surveillance camera with some sort of recognition algorithms that detect an object in a specified area. How are you going to display the vacant spaces for a driver, a bloody big screen somewhere or are you going to send it to a mobile device.

Once you work out the hardware infrastructure the building the application is trivial!

Never underestimate the power of human stupidity
RAH

How do you plan to interface the pressure sensors with the software? You are going to need a microchip and a ton of ADC's, among other things, then to write firmware for the uC and then the easy part is sending the data via USB to the C sharp application.

I think you would need to consult a civil engineering design firm for this one.

The reason you don't see this widely implemented already is because of its cost. You're not going to get away with using simple microcontrollers and pressure sensors.

The loads you need to deal with are far greater. What's the heaviest weight of a single axle of the heaviest vehicle your parking lot will accommodate? In the U.S., a 1-ton pickup (a 6,000lb vehicle) can put well over 3,000lbs on the front axle alone, and therefore that much weight on the sensor under the pavement in the parking spot.

The cost of one of those load cells is about $200+ in the U.S.

You'd also need to have considerations for motorcycles (can be less than 400lbs) and how people park them in a park spot, possibly missing your load cell altogether.

Then there's the cost of installation of a single load cell in a single parking spot.

Total up what it takes to install them, per parking spot, and you've got an enormous cost. Compare that to the expected cost savings to the business for telling people what spots are open. Oh! That's right! The owner of the parking spot didn't buy the gas for the customers! So, that savings for the owner of the parking spot is ZERO!

That's why you don't see this being widely used anywhere.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Dave Kreskowiak wrote:
Total up what it takes to install them, per parking spot,

Which is going to be quite a bit less than what it costs to maintain them over time.

Well, I didn't want to scare him too bad! Wink | ;)

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

I agree with Mycroft that the best solution is probably an image processing solution.
You could start with the Aforge library and make use of IP webcams.

Or checkout my Opensource webcam movement detection system [^]that is IP webcam enabled which makes use of Aforge.
(Warning the code is an example of how not to write .Net code however it was written around 5 years ago and I have learned a lot since...)

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

I Want that My logic in my dll file should be hidden just.

Screaming out in angst will not get you a different answer than you got the other day. Obfuscation is what you are looking for. It will stop the casual inspection of the logic in your DLL.

Never underestimate the power of human stupidity
RAH

Actually My work is that I have an Website in VB .NET.

I Want To convert it into C# and asp.net website.

My business logic is in a separate class file.So I want to convert it into a dll file.

My question is that is it possible to run both website pages simultaneously i.e.(asp. net and vb .net website) on same domain.

I want to convert the vb .net website in asp.net C# website side by side so that the vb. net website would not affect the task.

why are you yelling

We already told you what your choices are. Reposting the same question (and still yelling about it) will only get you flagged as "abusive".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

So what do you want? Could you explain it more correctly?
Don't you know the method of make DLL? Frown | :(

any someone can give me some solution about plate recognition with c# any reference or some code for me .,.,.,please Help me.,.,.,., Frown | :(