Prev: codec pack recommendation?
Next: Smereka freeform database ?
From: B. R. 'BeAr' Ederson on 23 Oct 2009 12:33
On Fri, 23 Oct 2009 12:03:55 +0530, Diabolic Preacher wrote:

> freeware xml to xls converter?

Excel can only reproduce a subset of all imaginable *.xml structures.
It depends on your data, whether it is easy, very difficult, or neigh
impossible to get your data to *.xls.

You should consider Excel *.xml import functionality. Since v2003
flat lists and simple structures are supported well enough:

http://office.microsoft.com/en-us/excel/HA011895301033.aspx

If you don't have (a new enough) version of Excel at hands, you may
consider using OpenOffice Calc as an intermediate. In most cases you'll
need to create an *.xslt filter fitting your data, though. Have a look
here for suggestions:

http://user.services.openoffice.org/en/forum/viewtopic.php?f=45&t=3490
http://www.ibm.com/developerworks/xml/library/x-oocalc/index.html

HTH.
BeAr
--
===========================================================================
= What do you mean with: "Perfection is always an illusion"? =
===============================================================--(Oops!)===
From: Craig on 23 Oct 2009 14:12
On 10/22/2009 11:33 PM, Diabolic Preacher wrote:
> Hello,
> Most google search results regarding this are topped by topshareware
> links that link to nothing below $20 although the search result snippet
> claims they list freeware on the page as well. Anyone can suggest a
> freeware xml to xls converter?

If you don't mind, why are you looking to do this?

tia,
--
-Craig
From: Diabolic Preacher on 23 Oct 2009 16:09
Diabolic Preacher expressed the following thoughts on 10/23/2009 12:03 PM:
> Hello,
> Most google search results regarding this are topped by topshareware
> links that link to nothing below $20 although the search result snippet
> claims they list freeware on the page as well. Anyone can suggest a
> freeware xml to xls converter?
>
> Thanks,
> Diabolic Preacher
> As Is

Thanks to everyone who replied. I'll also individually reply the
follow-up queries. I need to get a table of data in xml format converted
to mediawiki code. but i know of a good excel to wiki converter but no
xml to wiki converter, so i was searching for xml to xls/csv converter
and the xml file is pretty simple format. it won't even need too complex
a xsl i think. though am zero knowledged about it.

--
Diabolic Preacher
As Is
From: Diabolic Preacher on 23 Oct 2009 16:16
> When I saw converting XML to CSV, I had the same reaction.
>
> To illustrate what Yrrah is saying, converting XML to CSV or XLS for that
> matter would involve creating a spreadsheet where individual cells contain
> another spreadsheet where those cells may contain actual data, or maybe
> even another spreadsheet. It would be exceedingly difficult to take a
> multidimensional format like XML and try to "flatten" the data.
>
> There is no doubt that some XML files will have a schhema such that the
> data can be flattened, but there is no guarantee that any XML file will
> contain such easily converted data.
>

Thanks H-Man and Yrrah I'm xml's totally alien to me, regarding its
structure, so its good you raised your doubts and I am aware of the
potential issues.

--
Diabolic Preacher
As Is
From: Diabolic Preacher on 23 Oct 2009 16:17
B. R. 'BeAr' Ederson expressed the following thoughts on 10/23/2009
10:03 PM:
> On Fri, 23 Oct 2009 12:03:55 +0530, Diabolic Preacher wrote:
>
>> freeware xml to xls converter?
>
> Excel can only reproduce a subset of all imaginable *.xml structures.
> It depends on your data, whether it is easy, very difficult, or neigh
> impossible to get your data to *.xls.
>
> You should consider Excel *.xml import functionality. Since v2003
> flat lists and simple structures are supported well enough:
>
> http://office.microsoft.com/en-us/excel/HA011895301033.aspx
>
> If you don't have (a new enough) version of Excel at hands, you may
> consider using OpenOffice Calc as an intermediate. In most cases you'll
> need to create an *.xslt filter fitting your data, though. Have a look
> here for suggestions:
>
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=45&t=3490
> http://www.ibm.com/developerworks/xml/library/x-oocalc/index.html
>
> HTH.
> BeAr

Being able to use Calc will be really cool for me.

Thanks
--
Diabolic Preacher
As Is
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: codec pack recommendation?
Next: Smereka freeform database ?