Export to Excel conversion error

[#1]

Hi guys,

I have the following table of values:

AGRINET PRODUCT CODE	PRODUCT DESCRIPTION (Eng)	CUSTOMER PRODUCT CODE	MIN ORDER QTY	DELETE FLAG	BARCODE
65010-10-02	POLYFILLA INT POLYCELL 2KGX8	124626	0.00
65010-10-02	POLYFILLA INT POLYCELL 2KGX8	D1178	0.00
65010-10-02	POLYFILLA INT POLYCELL 2KGX8	903630	0.00
65010-10-02	POLYFILLA INT POLYCELL 2KGX8	6001606010404	0.00

But when I export these to excel, the first column's value get changed to numbers, which is a big problem for me. I've tried fiddling around Qlikview & Excel to find a solution that will work, but to no avail.

What we would like to do is export the tables to excel & send them to our customers to keep them updated on our product codes etc.

The result I get when exporting to Excel is the following:

AGRINET PRODUCT CODE	PRODUCT DESCRIPTION (Eng)	CUSTOMER PRODUCT CODE	MIN ORDER QTY	DELETE FLAG	BARCODE
23050730	POLYFILLA INT POLYCELL 2KGX8	124626	0.00
23050730	POLYFILLA INT POLYCELL 2KGX8	D1178	0.00
23050730	POLYFILLA INT POLYCELL 2KGX8	903630	0.00
23050730	POLYFILLA INT POLYCELL 2KGX8	6001606010404	0.00

Any ideas would be highly appreciated. I`m sure I`m not the only one experiecing this when exporting mixed-type data to excel.

[marcohadiyanto]

hi,

i think because of your agrinet product code same as date format in qlikview. so when you export them to excel, have your code had different value.

i'm still can't find the solution

[#3]

Hi Marco,

I definitely feel it has something to do with a date conversion of some sort, which is why I check my regional & language settings for the date format used.

Also, the start of my Qlikview script has the following:

SET

SET TimestampFormat='YYYY/MM/DD hh:mm:ss[.fff]';

Does anybody know how I can sidestep this conversion or know where I can override the manual settings?

Thanks in advance!

DateFormat='YYYY/MM/DD';

[#4 · Accepted solution]

Hi all,

For those interested, I've found the solution.

When loading the data into the model, explicitly define the field as text.

When this then gets exported to Excel, it will export as text & no conversions will be done on the data.

For example:

Load

....

TEXT(PRODUCT_CODE) as [AGRINET PRODUCT CODE],

.....

FROM ....;

[marcohadiyanto]

hi,

it's nice solution.

[#6]

Thanks. Your solution worked for me.

Don Saluga

ServiceLink

Pittsburgh, Pa.