XML Port in excel format

sabzam

Dear All,

Is it possible to modify an xml port in a way that the resultant file is in excel format? For example reading from a table and creating an xml file which has two tabs and can be read in Excel.

kine

You will need to use the Office Open XML format. Example is e.g there: http://en.wikipedia.org/wiki/Microsoft_ ... et_example

sabzam

Hi Kine,

Thanks for your reply. I have opted to use coding which is very similar to codeunit 424 which exports the analysis view. What I am trying to do now is to do some formatting such as bold text and underlining. Is this possible or should I use another method to get such final touches?

kine

sabzam wrote:

Hi Kine,

Thanks for your reply. I have opted to use coding which is very similar to codeunit 424 which exports the analysis view. What I am trying to do now is to do some formatting such as bold text and underlining. Is this possible or should I use another method to get such final touches?

Of course, you can use the automations to set all this as needed....

sabzam

Thanks kine for your prompt reply. I'll try to use the commands.