xslt dynamic settings

Question

hi all,

using xslt and dataset im uploading my data to excel file.

now i want to set the column display position dynamically ie.) let we assume if the dataset has 5 columns col1,col2,col3,col4 and col5 then the xslt is in the order of col2,col1,col4,col5,col3 so, now the excel file displaying in the order xslt, that is col2,col1,col4,col5,col3 got it!

now how i expect is, the excel output should be based on dataset position, and the ability to set the column title dynamically(i need to use xslt to design my excel) so, any body please tell me how to achieve this?

---

Thanks In Advance, Jeyaseelan

Answer 1

Hi jeyaseelan2,

Welcome!

According to your description, the excel file displaying in the order of xslt, you want to display it based on dataset position now, right?

I think you need to modify your xslt to fit for your requirement, you can refer the links here:

http://msdn.microsoft.com/en-us/library/aa140055(v=office.10).aspx#An Example

Export DataSet to Excel in C# 

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hi,

I am writing to check the status of the issue on your side. Would you mind letting us know the result of the suggestions?
If you need further assistance, please feel free to let me know. I will be more than happy to be of assistance.

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.