Plug-in to generate Excel files

raghunandanj3904

Certified Senior Developer

over 11 years ago

Any plug-in available for generating excel files??
I was going thru the below link,
forum.appian.com/.../apps
But it doesn support xlsx documents.
Also i want to generate the excel file containing multiple work sheets.
Is it possible in appian to achive this. Please suggest us....

Discussion posts and replies are publicly visible

Parents

0 shelzle over 11 years ago

Open the XML file in an text editor. The structure is quite simple.

The simple case is: You have a report with your 4 columns. A process executes this report and loops on the resulting PVs to generate the corresponding XML text for each line appending to a multiple text PV. This looks like

"<Row><Cell ss:MergeAcross=""14"" ss:StyleID=""s30""><Data ss:Type=""String"">" & pv!your_pv[tp!instanceindex] & "</Data></Cell></Row>"

Now you add header (including the "styles" tag).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 shelzle over 11 years ago

Open the XML file in an text editor. The structure is quite simple.

The simple case is: You have a report with your 4 columns. A process executes this report and loops on the resulting PVs to generate the corresponding XML text for each line appending to a multiple text PV. This looks like

"<Row><Cell ss:MergeAcross=""14"" ss:StyleID=""s30""><Data ss:Type=""String"">" & pv!your_pv[tp!instanceindex] & "</Data></Cell></Row>"

Now you add header (including the "styles" tag).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data