Hello

Is there a way of converting ExcelML (.xml) workbooks into
standard .xls files? I would like to do this without using Excel as it
is going to be part of another application, and I don't want all the
hassle of opening Excel and dealing with all the user-oriented stuff.

Thanks

Chris

Chris,
XML is nothing to do with Excel, per se.

IMHO, unless you want a lot of trouble parsing the XML DOM and converting
that to Excel with formatting etc, just open it in Excel, if you have access
to Excel > v9.

NickHK


<(E-Mail Removed)>
???????:(E-Mail Removed)...
> Hello
>
> Is there a way of converting ExcelML (.xml) workbooks into
> standard .xls files? I would like to do this without using Excel as it
> is going to be part of another application, and I don't want all the
> hassle of opening Excel and dealing with all the user-oriented stuff.
>
> Thanks
>
> Chris
>

Thanks NickHK

Allow me to be more specific. I have an application that creates Excel
workbooks in XML form (i.e. what you would get if you saved a workbook
as an Xml Spreadsheet in Excel 2003). This doesn't use the Excel
application as it can just generate the workbooks from XSL templates,
and this part is straightforward, certainly easier than using the
Office COM dlls to do the same thing.

The problem is I then have Excel spreadsheets in Xml format, which
cannot be opened in versions of Excel < 2003. So, I want to convert
these back into the standard .xls format. However, I don't want to
open Excel to do this, because as Microsoft say:

"Server-side components need to be highly reentrant, multi-threaded
COM components with minimum overhead and high throughput for multiple
clients. Office Applications are in almost all respects the exact
opposite."

I was hoping somebody would know about a tool to do this.

Thanks

Chris

Yes, you can do it with Applescript. Infact, you could create a Perl
script that you could call on the command line to do it (which calls
Applescript to do the job)

Chris,
You can create Excel workbooks without Excel being installed. There are
various classes/dll around. Here's one of the more complex :
http://www.freevbcode.com/ShowCode.Asp?ID=6856
I assume you have some means of compiling this VB code, or converting to
your language of choice, although the download comes with compiled DLLs and
samples.

So either do both .xml and .xls versions or drop the .xml and go with .xls

NickHK

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks NickHK
>
> Allow me to be more specific. I have an application that creates Excel
> workbooks in XML form (i.e. what you would get if you saved a workbook
> as an Xml Spreadsheet in Excel 2003). This doesn't use the Excel
> application as it can just generate the workbooks from XSL templates,
> and this part is straightforward, certainly easier than using the
> Office COM dlls to do the same thing.
>
> The problem is I then have Excel spreadsheets in Xml format, which
> cannot be opened in versions of Excel < 2003. So, I want to convert
> these back into the standard .xls format. However, I don't want to
> open Excel to do this, because as Microsoft say:
>
> "Server-side components need to be highly reentrant, multi-threaded
> COM components with minimum overhead and high throughput for multiple
> clients. Office Applications are in almost all respects the exact
> opposite."
>
> I was hoping somebody would know about a tool to do this.
>
> Thanks
>
> Chris
>

Sorry wrong news group.

You could doing it with VBScript.

On 1 Jun, 15:07, "gimme_this_gimme_t...@yahoo.com"
<gimme_this_gimme_t...@yahoo.com> wrote:
> Sorry wrong news group.
>
> You could doing it with VBScript.

Really - how?

Chris

Hello Chris. Im sorry to ask, do you found a suitable approach for
your problem ?
Thanks in advance.

On 8 Jun, 19:52, rene.ruge...@gmail.com wrote:
> Hello Chris. Im sorry to ask, do you found a suitable approach for
> your problem ?
> Thanks in advance.

Afraid not. I'm going to use automation to do the conversion, as there
shouldn't be much to go wrong in such a simple step (famous last
words).

Sorry

Chris