topic Re: Table Copy vs. Table Export in QlikView

Table Copy vs. Table Export

chrweber — Mon, 04 Dec 2017 06:06:28 GMT

Hello,

I wish to export a table to excel using the CopyTableToClipboard capability achieving the same result as with the exportToExcel function.

I notice that the clipboard option differs from the export option as it somehow changes the formatting of numbers.

I do not want to change the number formatting.

Can I replicate the export behavior using copy to clipboard?

Can I have a look at the macro that exports to Excel?

Am i missing something essential?

Best Regards.

Anil_Babu_Samineni — Mon, 04 Dec 2017 06:12:18 GMT

What are you facing with "Table Export"? Is that format changing from "Table Copy" to other extensions?

chrweber — Mon, 04 Dec 2017 06:20:11 GMT

Yes.

The formatting of my data is not uniform.

One col is ok: #.### -> #.###

The Next changes the number: #.### -> ###.#

And there is a number conversion making it a date.

I am guessing that there might be some interpretation on the excel side, that does not happen during export.

But that's only a guess.

chrweber — Mon, 04 Dec 2017 06:25:45 GMT

OK I see now, that the table export keeps the values as strings, whereas the copy paste option triggers number evaluation.

Which makes it a configuration problem.

The paste option is therefore "more correct".

Anil_Babu_Samineni — Mon, 04 Dec 2017 06:36:58 GMT

True, Excel always returns into the format issue. Can you work using Num() and then export with premises and tool options..