Table Copy vs. Table Export

[chrweber]

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]

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

[chrweber]

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]

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]

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