[CLOSED] Export To Excel with multiple sheets from Stored Procedure

  1. #1

    [CLOSED] Export To Excel with multiple sheets from Stored Procedure

    Hello,

    is there an example of how I can export to excel with multiple sheets from a stored procedure?
    Last edited by fabricio.murta; Mar 24, 2017 at 3:48 PM. Reason: No user feedback in 7+ days
  2. #2
    Hello @atroul!

    I don't quite understand what your needs are. Can you elaborate on your question please?
    Fabrício Murta
    Developer & Support Expert
  3. #3
    Hello Fabricio,
    what I want is to call a Stored Procedure in my database and export the results in an Excel file.
    I found this example: examples
    but I want the data to be fetched from a Stored Procedure

    EDIT:
    Probably is not going to work with this example because the result has not a specific number of columns...
    Last edited by atroul; Feb 21, 2017 at 1:53 PM.
  4. #4
    Hello @atroul!

    I don't think the data coming either from a stored procedure or file, statically or from any other source matters for Ext.NET at all as long as you map the data to a C#/VB.NET object.

    Here's an example fetching data from a database to a grid panel (that the example you pointed will complement with the export functionality).
    - GridPanel - DataSource controls - SQL Data Source
    Fabrício Murta
    Developer & Support Expert
  5. #5
    Hello Fabricio,
    thx for the reply , I just edited my post. The result from the Stored Procedure has columns whose number varies.
    1st time I can get result with 3 columns, 2nd with 5 columns etc.
    Is there any C#/VB.NET object where the result can be mapped to it?
  6. #6
    Hello!

    Here's an example of a grid panel that's fully reconfigured dynamically: Grid Panel - Column Model - Change Models

    You probably may need to define the model from code behind and adequate de grid to comport it then. Or just define the grid from Page_Load() if the grid data is fetched once when the page is opening.

    These two other dynamic approaches may be used to your advantage:
    - Grid Panel - Data Presentation - Meta Config
    - Grid Panel - Data Presentation - Server Mapping

    Hope this helps!
    Fabrício Murta
    Developer & Support Expert
  7. #7
    Hello @atroul!

    It's been some time since we replied to this thread and no feedback from you still. Do you still need help with this issue?

    We may mark this thread as closed if you don't post back in 7+ days but that won't prevent you from posting when you can.
    Fabrício Murta
    Developer & Support Expert

Similar Threads

  1. Export to excel: Grid Panel with multiple pages.
    By breakyoheart in forum 2.x Help
    Replies: 0
    Last Post: Aug 02, 2012, 8:09 PM
  2. [CLOSED] Export To Excel with multiple tabs
    By Fahd in forum 2.x Legacy Premium Help
    Replies: 5
    Last Post: Jun 25, 2012, 2:01 PM
  3. Replies: 12
    Last Post: Oct 03, 2011, 9:59 PM
  4. Replies: 11
    Last Post: Feb 06, 2009, 7:45 AM
  5. Sqldatasource - Update With Stored Procedure
    By Tbaseflug in forum 1.x Help
    Replies: 0
    Last Post: Jan 20, 2009, 8:51 PM

Tags for this Thread

Posting Permissions