Re: Issue with Excel vesion in C# - C# Discussion Boards

WuRunZhe30-Oct-13 4:12

WuRunZhe

30-Oct-13 4:12

Well, Could you tell me your specific word file format? Without that, nobody can insert it. Wink | ;)

Sandeepdshenoy30-Oct-13 21:37

Sandeepdshenoy

30-Oct-13 21:37

Hi,

Its some contract agreement with the header , picture and some other agreement details. I need to fill the Customer Name, Date and address from the database.

I already tried the find and replace codes, but since that document has to be reused , finding and replacing text wont solve the problem.

Is there any way i can create an object from one existing document and save it in another name with the replaced texts ?

Eddy Vluggen1-Nov-13 6:00

Eddy Vluggen

1-Nov-13 6:00

Sandeepdshenoy wrote:
Is there any way i can create an object from one existing document and save it in another name with the replaced texts ?

Use File.Copy.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Sandeepdshenoy30-Oct-13 21:42

Sandeepdshenoy

30-Oct-13 21:42

Hi,

This is what i have done till now...

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 ?

Kenneth Haugland30-Oct-13 21:31

Issue with Excel vesion in C#

30-Oct-13 21:31

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

superselector29-Oct-13 19:05

superselector

29-Oct-13 19:05

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

Mycroft Holmes29-Oct-13 20:11

29-Oct-13 20:11

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

Kenneth Haugland29-Oct-13 20:30

29-Oct-13 20:30

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?

Mycroft Holmes29-Oct-13 21:16

29-Oct-13 21:16

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

Kenneth Haugland29-Oct-13 21:25

29-Oct-13 21:25

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...

superselector30-Oct-13 18:42

superselector

30-Oct-13 18:42

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.

Kenneth Haugland30-Oct-13 21:29

30-Oct-13 21:29

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....

Bernhard Hiller29-Oct-13 21:39

Bernhard Hiller

29-Oct-13 21:39

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.

Need pointers to build the Car Park Management System

TnTinMn30-Oct-13 14:12

TnTinMn

30-Oct-13 14:12

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.

ashuthind00129-Oct-13 18:53

ashuthind001

29-Oct-13 18:53

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

Re: Need pointers to build the Car Park Management System

Mycroft Holmes29-Oct-13 20:07

Re: Need pointers to build the Car Park Management System

29-Oct-13 20:07

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

turbosupramk330-Oct-13 1:48

turbosupramk3

30-Oct-13 1:48

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.

Re: Need pointers to build the Car Park Management System

Dave Kreskowiak30-Oct-13 2:54

Dave Kreskowiak

30-Oct-13 2:54

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

Re: Need pointers to build the Car Park Management System

jschell30-Oct-13 8:08

jschell

30-Oct-13 8:08

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.

Re: Need pointers to build the Car Park Management System

Dave Kreskowiak30-Oct-13 9:04

Dave Kreskowiak

30-Oct-13 9:04

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

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: Need pointers to build the Car Park Management System

GuyThiebaut31-Oct-13 3:20

GuyThiebaut

31-Oct-13 3:20

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

Dll Files in .NET

Amit Saini29-Oct-13 18:37

Amit Saini

29-Oct-13 18:37

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

Re: Dll Files in .NET

Mycroft Holmes29-Oct-13 20:01