excel and xml file openend from within Navision

wic

yo. I'm trying to do the following from within Navision. :P
From a codeunit, I start a XMLPort data export (sales header+lines)
Then, with Excel automation, I try to open this xml created file. It's more than difficult. I have something but it's badly formatted, the
>
xlBooks.OpenXML('h:\myFile.xml',whatshouldbehere,'xlXmlLoadMapXML');
<
command doesn't work. And no documentation how to write the code.

Finally I want to do a pivot table with the excel sheet (still within navision: xlActivesheet.pivotTable or pivotTalbeWizard).
Nothing work like it should (or nothing work like I think it should! Or I'm a big dreamer!)

The ultimate goal is: my customer has, in one click, a great pivot table for analyzing some business datas. (Don't tell me about JetReport). =;

Does anyone have some experience in it?Where could I find automation description?
many thanx

DenSter

I think there's some standard stuff in the analysis view area. I have not worked with itmyself, but I think there is some functionality there that creates pivot tables in Excel that you could borrow from.

Luc_VanDyck

Indeed, check out codeunit 424 "Export Analysis View" (which is called by menu "Export to Excel" in form 554 "Analysis by Dimensions"). This codeunit does all the hard work.