I am using Views data export module (version 7.x-3.1) to download content in Microsoft Word Format.

I am able to download the content but the fields of the view are coming out in columns rather than rows.

Please guide.


As an alternative to using the Views data export module, you may want to use the Forena module (disclosure: I'm a co-maintainer of it) to create a "report" that includes the data that you're interesting in (i.e. the "content" as in your question). As part of the report design, indicate which export formats you want to allow for exporting the data included in it. DOC (for MS Word) is one of the typical formats that are supported (apart from CSV, XML, HTML, etc). By using Forena, the layout of the exported table (in your MS Word doc) would not be "coming out in columns rather than rows" (as in your question).

Have a look at the Simple Table of States example, and think of it as the equivalent of your "posts that you want to export". And note the hyperlinks in the upper right, which are:

Try any of these links to get the equivalent of the extracted information, but in the format you requested (there or other supported formats such as PDF, DOC, JSON, etc).

Checkout Forena's Community Documentation for (way) more details, and/or the documentation that comes with the module.

Forena versus Views

Forena can be used together with the Views module, or as an alternative to it, more specifically:

  • As an alternative to Views, to create reports (and derivatives such as charts and/or exports of data) which you cannot, or not easily, create with only Views. E.g. to pivot data, where you want to create tables in the format of what in Forena is called "Render a report in FrxCrosstab format".
  • Integrated with Views, as explained in the Forena tutorial pages, i.e.:

Using the Forena integration with the Views module, it is possible to use Forena reports as a views row style, so that in a view you can use the Forena templating engine to do the formatting. Although this can be done through the views templating engine Forena users may find they have more control with this engine.

  • Can you please guide on how to use forena with view. when i chose forena reports as views rows style, the content disappears in the view. – Tulika Sharma Feb 7 '17 at 10:37
  • @TulikaSharma : check my updated answer (= Forena versus Views) – Pierre.Vriens Feb 7 '17 at 10:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.