My Problem is, We need to generate an excel file whose columns are dynamic which is depend on the field template name. Using template name we are fetching data which will become the column of the excel sheet, and one template can generate around 150- 250 columns of the excel sheet . Out of 150-250 columns we need to populate values of around 10 columns rest of the columns of the excel sheet would be blank.
For Example :- Let say for a Template name, we are fetching 10 columns from database [Employee Name, Employee iD, C, Street Name, City, Zip, G, H, I and J] and we need to populate only some of the field like Employee Name Employee ID, StreetNM, City and Zip rest other columns are Blank.
EmployeeName Employee ID C StreetNM City Zip G H I J
A 101 XX YY 1234
B 102 XXC YU 234
If you the solution of this problem please provide me the Step by process to achieve it using webMethods 7.1.2.