XML Map for SQL to Excel Joomla Component

**jrtaylor** · 03-28-2011, 06:25 PM

I have a Joomla site which contains front-end tables.

I've discovered a component which will allow me to upload Excel xml files, which in turn I can convert into front-end tables on my site.

I don't know much about schemas but I did download and install the XML tools for Excel 2003. (I'm using v 2007).

Playing around with it I highlighted a range of cells which I refer to as dataset.

I indicated that the top row consisted of headings (although only one cell in the range has a heading).

I get an error: "1B6 This Object does Not Support This Property or Method."

When I close out of the error popup, I can see that the xml tool did create filters for each column.

I'm attaching the worksheet in .xls form. Any advice?

Thanks.

**michael_aussie** · 07-18-2012, 11:42 PM

My problem has nothing to do with Joomla .. but other than that .. my problem sounds idenitical to the OP.

I am trying to generate an xml file from Excel 2007 and get the same error message.

"fnMapRangeWithXml"
"ERROR 1B6: Object doesn't support this property or method."

pls help!!

**arlu1201** · 07-19-2012, 02:47 AM

mike,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**michael_aussie** · 07-19-2012, 07:14 AM

hi Arlette ... i now understand that those are your rules ... . i laughed when i read "a thread with numerous replies" ... given that the OP has received ZERO replies in 16 months. I'm guessing that they are no longer waiting for a reply. You have a great day, and I'm sorry for breaking your rules.