Jump to content


Photo
- - - - -

Writing reports to Excel through XML


17 replies to this topic

#16 mikelandl

mikelandl

    Expert

  • Members
  • PipPipPipPip
  • 101 posts

Posted 26 May 2009 - 06:22 PM

We write to a XML file format then command Excel to load it in that way.
3 steps in 3 callable functions:
Prep file using stored data cell formats on local machine.
Export and Write file to users computer
Open excel and import XML file.

Totally transparent to user. They get Excel popped up in their screen WITH the data in in.


Hi Glenn,

Thanks for the quick reply. What do you mean by "prep file using stored data cell formats on local machine"? I'm assuming you have an Excel template setup on the user's machine and you load the XML document into Excel using that template. Is that correct?

#17 Glenn Meyers

Glenn Meyers

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 221 posts
  • Gender:Male
  • Location:St. Louis, MO, United States
  • Interests:I also raise African Gray Parrots and build hot rod automobiles.

Posted 27 May 2009 - 01:33 AM

We write to a XML file format then command Excel to load it in that way.
3 steps in 3 callable functions:
Prep file using stored data cell formats on local machine.
Export and Write file to users computer
Open excel and import XML file.

Totally transparent to user. They get Excel popped up in their screen WITH the data in in.


Hi Glenn,

Thanks for the quick reply. What do you mean by "prep file using stored data cell formats on local machine"? I'm assuming you have an Excel template setup on the user's machine and you load the XML document into Excel using that template. Is that correct?


No that is not correct.

We load the cell format data as a string in the file we create as the file is written in step one.
We tell the cell all the necessary information AND add the data.
This information is stored on the mainframe in a file that we can call using a subroutine. So in our transfer file is:
Cell A-one data + cell A-one format
Cell A-two data + cell A-two format
Cell A-three data + cell A-three format
etc.

When the file is read on the users machine the cell is populated and formatted before excel moves to the next cell.

#18 mikelandl

mikelandl

    Expert

  • Members
  • PipPipPipPip
  • 101 posts

Posted 27 May 2009 - 12:07 PM

We write to a XML file format then command Excel to load it in that way.
3 steps in 3 callable functions:
Prep file using stored data cell formats on local machine.
Export and Write file to users computer
Open excel and import XML file.

Totally transparent to user. They get Excel popped up in their screen WITH the data in in.


Hi Glenn,

Thanks for the quick reply. What do you mean by "prep file using stored data cell formats on local machine"? I'm assuming you have an Excel template setup on the user's machine and you load the XML document into Excel using that template. Is that correct?


No that is not correct.

We load the cell format data as a string in the file we create as the file is written in step one.
We tell the cell all the necessary information AND add the data.
This information is stored on the mainframe in a file that we can call using a subroutine. So in our transfer file is:
Cell A-one data + cell A-one format
Cell A-two data + cell A-two format
Cell A-three data + cell A-three format
etc.

When the file is read on the users machine the cell is populated and formatted before excel moves to the next cell.


Ahh, makes sense. Thanks for the info, I'm thinking that might be the route we'd like to take.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users