C# Discussion Boards - CodeProject

Re: Problem about size with creating excel file using xml spreadsheet ?

4-Apr-13 22:41

Hi Richard,

I used "Save" button (not SaveAs), but the size is bigger after saving

Richard MacCutchan4-Apr-13 23:29

Richard MacCutchan

4-Apr-13 23:29

Yes, and it is because the default format for saving this file is XML Spreadsheet, as I mentioned above. If you open that file with a text editor you will see that it is an XML file. You need to use SaveAs to change the default to Excel Workbook.

Use the best guess

Re: Problem about size with creating excel file using xml spreadsheet ?

taibc4-Apr-13 23:36

Re: Problem about size with creating excel file using xml spreadsheet ?

4-Apr-13 23:36

Oh, you are right.

How can I save this file to Excel Workbook using C# ? So, users only need to open and save it (not save as)

I used below codes to save xml string as .xls file.

<pre lang="c#">

FileStream fs = File.Open(path,  FileMode.Create,  FileAccess.Write); // path contain ".xls" extension

StreamWriter stmWriter = new StreamWriter(fs, System.Text.Encoding.UTF8);

stmWriter.Write(strXMLContent); // strXMLContent is the xml string of excel file

Thanks and regards,
Tai

Richard MacCutchan4-Apr-13 23:41

Richard MacCutchan

4-Apr-13 23:41

You cannot use a StreamWriter to create an Excel spreadsheet, you need to use the Microsoft.Office.Interop.Excel Namespace[^].

Use the best guess

Re: Problem about size with creating excel file using xml spreadsheet ?

taibc4-Apr-13 23:51

Re: Problem about size with creating excel file using xml spreadsheet ?

4-Apr-13 23:51

Before, I tried to use Interop.Excel but, It is quite slow to create file.

So I used StreamWriter to write xml string, and it is more quickly.

Is it possible to use Interop.Excel to create excel file from XML String ?

Are there any otherway ?

Thanks and regards,

Tai

Richard MacCutchan4-Apr-13 23:54

Richard MacCutchan

4-Apr-13 23:54

Fine, but what you end up with is an XML Spreadsheet, not an Excel Workbook. You need to decide which is best for your application.

Use the best guess

Re: Problem about size with creating excel file using xml spreadsheet ?

taibc4-Apr-13 23:57

i use google maps api and can't remove single marker

4-Apr-13 23:57

Ok, thank you for your help

Asaf Shay4-Apr-13 13:05

Asaf Shay

4-Apr-13 13:05

in my example it's show that I put only one marker but lets say I add much more markers and I only want to remove marker in my array in index 0.

protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        if (CheckBox1.Checked == true)
        {
            GMap1.addGMarker(markers1[0]);
        }
        else
        {
            //i dont know what to put here

        }
    }

modified 6-Apr-13 17:51pm.

Automating website using c# windows form

Nico Panares4-Apr-13 7:35

Nico Panares

4-Apr-13 7:35

Hi Guys,

Do you have any idea on how to automate website using c# windows form? If so, can you provide me. I am a new bee in automation and I want to automate my testing in the website.

Thanks,
Nico

Re: Automating website using c# windows form

Eddy Vluggen4-Apr-13 9:38

Eddy Vluggen

4-Apr-13 9:38

Create a new project, throw a WebBrowser component on there, and

<a href="http://msdn.microsoft.com/en-us/library/system.windows.forms.webbrowser.navigate.aspx">Navigate</a>[<a href="http://msdn.microsoft.com/en-us/library/system.windows.forms.webbrowser.navigate.aspx" target="_blank" title="New Window">^</a>]

where you want.

Bastard Programmer from Hell Suspicious | :suss:

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

How to deny users from disabling my C# service

candogu4-Apr-13 7:05

candogu

4-Apr-13 7:05

Hi everyone, I have a problem, we borrow our clients laptops in our company for a short time. Users should be the local admin of the computer in order to add/remove programs they need. However, some of them didn't return the laptops in time so, we decided to write a program that locks the computer on date that we give before. I have one windows service, one form application which interacts with user and communicates with the service. While I testing, when I kill my program or my service, I give bsod but, when I try to disable the service and restart my computer, it doesn't run anymore. I need a method to prevent disable my service. Even my form application gets killed, my service has to run in background. Thanks.

Re: How to deny users from disabling my C# service

jschell4-Apr-13 9:24

jschell

4-Apr-13 9:24

candogu wrote:
we borrow our clients laptops in our company for a short time

Presumably you mean that you lend them to your clients.

candogu wrote:
we decided to write a program that locks the computer on date that we give
before

Seems like an unlikely and complicated solution. Why don't you just send them a bill, with an appropriate markup, as the replacement cost of the computer? The markup should be high enough that it allows you to buy a new computer and cover collection agency costs. Presumably the clients are in fact capabable of covering that cost or you shouldn't be lending it to them in the first place.

candogu wrote:
I need a method to prevent disable my service

I am rather certain that is impossible. You can however make it difficult.
But really will this fix your problem? Are you sure the clients will return the computer then? What stops them from just throwing it in the trash?

Re: How to deny users from disabling my C# service

Eddy Vluggen4-Apr-13 9:42

Eddy Vluggen

4-Apr-13 9:42

I'd boot in safe mode and install my own "fun.exe" before returning it to you Smile | :)

While there's few valid reasons to be late in returning the laptop, there's none in locking it. You have a list of people whom you lent it to; send them a mail and charge them a small fee for each day that it's not returned.

Bastard Programmer from Hell Suspicious | :suss:

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

Re: How to deny users from disabling my C# service

Dave Kreskowiak4-Apr-13 12:27

Dave Kreskowiak

4-Apr-13 12:27

Since everyone is an admin, you can't, really.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

hello

youshy4-Apr-13 4:00

4-Apr-13 4:00

ThePhantomUpvoter is that ur account Smile | :)

Pete O'Hanlon4-Apr-13 4:14

Pete O'Hanlon

4-Apr-13 4:14

I think I speak for everyone when I say "What?"

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Keith Barrow4-Apr-13 4:36

Keith Barrow

4-Apr-13 4:36

I think this may be an exercise in redundancy.

He is asking everyone if the ThePhantomUpvoter account is your account, but there is only one account that can answer this, ThePhantomUpvoter. A bit like asking all the integers if they are the number 17. The question might even have deep existentialist qualities, but if it does, I've failed to discern them.

“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”

Sir Thomas More (1478 – 1535)

Keith Barrow4-Apr-13 4:36

Keith Barrow

4-Apr-13 4:36

Yes, it isn't mine.

youshy4-Apr-13 4:57

4-Apr-13 4:57

sorry sir Thomas
but i want to send an Email to this person so he could help me with my code Frown | :(

and i don't know how to send it to him Frown | :(

Pete O'Hanlon4-Apr-13 5:09

Pete O'Hanlon

4-Apr-13 5:09

youshy wrote:
i want to send an Email to this person so he could help me with my code

That's generally frowned upon by the recipients. It's unwanted requests like this that led to me removing the option to email me.

I was brought up to respect my elders. I don't respect many people nowadays.

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

youshy4-Apr-13 6:54

4-Apr-13 6:54

thank you

Keith Barrow4-Apr-13 5:15

Keith Barrow

4-Apr-13 5:15

It is not my account. I certainly wouldn't welcome people e-mailing me directly for help. e-Mailing like this also goes against the purpose of Code Project, as the idea is to share problems so that other can see them and hopefully use any answers given.

youshy4-Apr-13 6:53