Re: Problem about size with creating excel file using xml spreadsheet ? - C# Discussion Boards

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

4-Apr-13 21:48

Hi Rah,

I did as your suggestion The new file is 200KB. I haven't known why ? Could you please open and check that file ?

Thanks and regards,

Mycroft Holmes4-Apr-13 22:02

Mycroft Holmes

4-Apr-13 22:02

taibc wrote:
Could you please open and check that file

Sorry I am not an excel expert, I suggest you chase this down through the MSDN forums as I would think it is an Excel problem not a c# issue.

Never underestimate the power of human stupidity
RAH

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

taibc4-Apr-13 22:05

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

4-Apr-13 22:05

Yes, thank you.

Maybe there is something wrong with my xml string format

Eddy Vluggen4-Apr-13 22:30

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

4-Apr-13 22:30

taibc wrote:
I have a excel with the size is: 500KB

But, after opening it and click "save" button without changes, the new size is: 2.5MB

It's by design. XML is exactly that; XML, not a XLS file. If you open it in Excell, it'll parse it correctly. But save it in Excell, and it'll generate an Excell-file (.xls), and not write in your XML-format.

You might want to use a CSV file instead.

Bastard Programmer from Hell Suspicious | :suss:

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

taibc4-Apr-13 22:43

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

4-Apr-13 22:43

Hi Eddy,

Thank you.

So, I can save xml string as "CSV" file ? But, I am wanting to creat .xls file from xml string.

Do you have any ideas ?

Eddy Vluggen5-Apr-13 0:28

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

5-Apr-13 0:28

taibc wrote:
But, I am wanting to creat .xls file from xml string.

XML is not a native Excell-format. Creating an .xls file is not the same as dumping your data as Xml and renaming the extension - it will still be XML (even if Excell can read it without problems) and as soon as you save it, it will become a "real" XLS-file. That will contain more than Xml, as it will contain even properties that identify the author.

taibc wrote:
So, I can save xml string as "CSV" file ? <layer>But, I am wanting to creat .xls file from xml string.

CSV would behave in a similar way, but at least it'd be very clear that it's no longer an Excell-file Smile | :)

If you want a "real" Excell file (the large ones), you'll need to create a file using Excel-interop and move the Xml values into a worksheet.

Bastard Programmer from Hell Suspicious | :suss:

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

taibc5-Apr-13 0:34

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

5-Apr-13 0:34

Thank you

,

How can I move Xml values (xml string) into a worksheet ?

Eddy Vluggen5-Apr-13 7:00

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

5-Apr-13 7:00

As Richard notes, if you want to write a file in the native Excell-format, you'll have to InterOp to Excell. One problem to be expected is that the interop-libraries are tied to a specific version of Office. Use Office-2007 interop, and you'll be able to write .xls and .xlsx files. Do note that the native format is also tied to a specific Office-version. Second point is that one would need a license for Excell.

Alternatively, you could try searching for some third-party libraries. Most people will spit out an XML or CSV and not bother with it, unless there's a need to have some formatting in there.

Why is it such a big problem if the file grows a bit?

Bastard Programmer from Hell Suspicious | :suss:

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

taibc5-Apr-13 17:55

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

5-Apr-13 17:55

Thanks Eddy,

I had a solution for this. I used Interop.Excel to open the file and Save as a normal workbook, and the result is ok (the size is smaller, and don't have any problems).

Thanks and regards,

Richard MacCutchan4-Apr-13 22:37

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

4-Apr-13 22:37

The default "SaveAs" option in this spreadsheet is to save as XML Spreadsheet, which is text, and therefore takes much more space on disk. Save it as Excel Workbook and it is the same size.

Use the best guess

taibc4-Apr-13 22:41

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

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

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

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

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

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

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

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

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

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

How to deny users from disabling my C# service

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[^]

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