I'm testing this module, and my export of fields is showing HTML tags in all rows (e.g., a href, spans, p).

CommentFileSizeAuthor
#1 Selection_001.png58.88 KBd.novikov

Comments

d.novikov’s picture

d.novikov commented
StatusFileSize
new Selection_001.png58.88 KB

The module has nothing to do with data which Views provides to it. It just "wraps" those data into Excel spreadsheet. I'm almost sure you need just to set "Strip HTML tags" checkbox for necessary fields inside the view (see the file attached).

d.novikov’s picture

d.novikov commented
Status: Active » Closed (works as designed)
ludo.r’s picture

ludo.r
Location Brussels
commented
Status: Closed (works as designed) » Active

What's confusing is that when we use the standard XLS format from Views Data Export, no HTML is output in the result file, while when using XLSX from Views Data Export PHPExcel module does output HTML tags.

I don't know which one is wrong, but it isn't consistent accross the different file formats.

Dima DD’s picture

Dima DD commented

However, some HTML tags are very useful: these are formatting tags like b, i, sup and sub. Pseudo-XLS files from the Views Data Export module shows nicely formatted text if they are not stripped at field rewriting.

So, the question: is it possible to interpret somehow these HTML tags at XLSX export to preserve original formatting? For example, using RichText functions from PHPExcel.