Extra spaces when exporting to Excel

[#1]

Hello,

Sometimes I have to create huge tables in QV and export them to excel.

I've noticed that when I export tables from QV to Excel the empty cells are not "" but " ".

Removing the empty spaces in excel shrinks the files from 15 MB to 5 MB (500 000+ spaces are being removed).

I was therefore thinking if these spaces are also stored in QV causing the qvw files to work slower. Is there an easy way to check this?

[stabben23]

Hi,

you can add =len(YourFileld) inside a textbox and se no of Spaces.

[el_aprendiz111]

Hi Carl

examples that will help you in the script to load data

TABLE:
LOAD
TRIM(COUNTRY)   AS COUNTRY,
NUM(VALUE)      AS VALUE,
NUM(VALUE_1)    AS VALUE_1,
NUM(VALUE_2)    AS VALUE_2,
NUM(VALUE_3)    AS VALUE_3;

[Clever_Anjos]

"I export tables from QV to"

How do you export your files?