Export to excel changed NUMBER to TEXT

[sis01]

Hi all

I exported data to a Excel worksheet, when i open the file, i detected numeric columns were converted to TEXT columns....

The columns changed are float type.

Is there any way to export correctly.?

Thanks in advance

[alexa]

Could you please provide us the CREATE definition of the table and the exported XLS file? You can include just a few test records so we can reproduce the issue on our side.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

[sis01]

Hello

Here are the files

check the columns "NUMCRED" and "CANTENTRE", they should be numeric types.

Code: Select all

CREATE TABLE PLD.TMP_CREDEXCED (
  FDESDE      DATE,
  FHASTA      DATE,
  FUENTEBD    VARCHAR2(10 BYTE),
  CDGRG       VARCHAR2(3 BYTE),
  CLNS        VARCHAR2(1 BYTE),
  CDGCLNS     VARCHAR2(6 BYTE),
  CICLO       VARCHAR2(2 BYTE),
  CDGCL       VARCHAR2(6 BYTE),
  NUMCRED     NUMBER(5, 0),
  CANTENTRE   NUMBER(15, 4),
  INICICLO    DATE,
  USUARIO     VARCHAR2(10 BYTE),
  FREGISTRO   DATE,
  TIPOACTO    VARCHAR2(10 BYTE),
  FULTREPORTE DATE
)

The exported excel file is this:
https://www.dropbox.com/s/4k50xip4u98rb ... D.xls?dl=0

hope it can be resolved

Thanks in advance...

[alexa]

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

[syed20]

I exported data to a Excel worksheet, when i open the file, i detected numeric columns were converted to TEXT columns....


_________
Unlock the key of your success by redhat dumps.By using our latest passguide and Iona College study material, you can easily HITACHI selftestengine Youtube

[alexa]

We would like to let you know that we have released a new version 3.7 of dbForge Studio for Oracle where the issue you reported is fixed http://www.devart.com/dbforge/oracle/st ... nload.html

Thank you for your help in improving dbForge Studio for Oracle.