• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

Export Data to excel sheet and format the data


How can I export data to excel sheet and then style the excel sheet.

        If Page.IsPostBack Then

            dsUsers = df.ExeDBCmdParamReturnDS("rpt_Detail_General_Ledger_User", _
            df.MakeParam("@Acct", TxtAccount.Text, SqlDbType.Char, 10), _
            df.MakeParam("@SubAcct", TxtSub.Text, SqlDbType.Char, 24), _
            df.MakeParam("@PerEnt", TxtDate.Text, SqlDbType.Char, 6), _
            df.MakeParam("@SortBy", DLSort.Text, SqlDbType.Char, 24))

'here I have to export the data from the stored procedure to the excel sheet.

        End If
1 Solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now