Discussions about Coollector.
Thu Oct 23, 2014 6:08 pm
Just wondering if there is a way to export my owned movies to a file I can open with Excel in OpenOffice on my Mac? I exported the list as XML, TXT and JSON. Non of them will open in Excel. How can I print a list of my owned movies in columns with the selected fields?
Thu Oct 23, 2014 8:01 pm
I haven't used Excel in years, but I'm surprised that you can't import from XML. In my mind, it's a fundamental.
If I search for "excel import xml" on Google, I get many results...
What about this one?
http://office.microsoft.com/en-au/excel-help/import-xml-data-HP010206405.aspx#BMimport_an_xml_file_into_existing_mapp
Fri Oct 24, 2014 4:26 am
That web page is for Excel on a Windows computer. I'm using OpenOffice on a Mac.
Fri Oct 24, 2014 9:31 am
I thought it would be very similar on a Mac, but if it's not the case, you just have to add "mac" to your Google search.
I won't teach you how to use Excel as I don't use it myself. But there's no doubt that Excel can import XML.
Fri Oct 24, 2014 3:25 pm
I just figured it out. OpenOffice on a Mac has a spreadsheet application built in called Calc. It is not Excel. It does open and save .xls files though. OpenOffice does not open or import xml files. I had to convert the xml file to xls first, then OpenOffice will open it. The following website converts the file online:
http://www.luxonsoftware.com/converter/xmltoexcel
Fri Oct 24, 2014 3:37 pm
Avroman00 wrote:I just figured it out.
Cool
I'm a bit surprised that it's so complex
Powered by phpBB © phpBB Group.
phpBB Mobile / SEO by Artodia.