Inverting DataGrid columns and rows in excel

Ask a Question related to ASP.NET Data Grid Control, Design and Development.

  1. #1

    Default Inverting DataGrid columns and rows in excel

    I am populating a datagrid and allowing it to be exported as an excel spreadsheet but my internal customer needs the columns and rows inverted. Any help will be appreciated. Asp.Net, Office XP, Visual Studio.Net 200
    Jac

    Jack Mullins Guest

  2. Similar Questions and Discussions

    1. Howto display an ASP.net datagrid rows as columns and vice versa?
      Hi I want to display my datagrid with the columns horizontal and rows vertical, so just the other way around. For example instead of : name ...
    2. Add/Delete rows/columns in datagrid
      Hi, I'm trying to add additional or delete rows/columns to a datagrid based on a specified number. I tried addColumn, this only adds 1 column at...
    3. datagrid sort columns not rows
      Hi, I am filling a datagrid via xml and the columns as not created in the order I have in my xml. I've also added them in the correct order in...
    4. DataGrid: Selecting multiple rows/columns
      Hi, I would like to enhance the DataGrid by adding scripting functionality that allows the selection of multiple rows or columns via...
    5. DataGrid, 7 columns on 2 rows?
      Is this possible? I currently have a datagrid showing 7 columns, I would like to show the 6th and 7th columns on the next row. How can I do this?
  3. #2

    Default Re: Inverting DataGrid columns and rows in excel

    Excel renders whatever the grid looks like so you need to get the grid to
    conform first. Here is some code to flip rows with columns


    [url]http://www.networkip.net/tidbits/flip.htm[/url]
    --
    Regards,
    Alvin Bruney
    Got Tidbits? Get it here
    [url]www.networkip.net/tidbits[/url]
    "Jack Mullins" <jack.mullins@lmberry.com> wrote in message
    news:32B6A003-531B-4DFE-9E34-361C1A6C5EE5@microsoft.com...
    > I am populating a datagrid and allowing it to be exported as an excel
    spreadsheet but my internal customer needs the columns and rows inverted.
    Any help will be appreciated. Asp.Net, Office XP, Visual Studio.Net 2002
    > Jack
    >

    Alvin Bruney Guest

  4. #3

    Default Re: Inverting DataGrid columns and rows in excel

    Thanks Alvin, this looks like exactly what I'm trying to do.
    Jack Mullins Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139