Decimal and zeros added to text when using DC_Excel2Array

[GeneB]

When converting a spreadsheet to an array using DC_Excel2Array, a column that is fomatted as text but contains only numeric characters has a decimal and many zeros added to every cell in the column.
What is the way to correct this.
This is happening in both build 258 and 260.
Thanks.
GeneB

[Auge_Ohr]

When converting a spreadsheet to an array using DC_Excel2Array, a column that is fomatted as text but contains only numeric characters has a decimal and many zeros added to every cell in the column.
What is the way to correct this.

when Excel see "Number" it want to use as Number ... not as String.

so when using DC_Excel2Array() you have to "format" Excel Column to use as String

Code: Select all

oSheet:Columns(i):NumberFormat :=  "@"

[rdonnay]

I'm travelling home early tomorrow.
I'll look into this tomorrow afternoon.

[D. Schuster]

Further remarks can be found under "User Contributions" --> "Importing Excel to DBF"

Dieter

[GeneB]

Thank you, Dieter, but I'm the one that posted that contribution.
What I posted creates a dbf file with the structure you pass and adds data to the dbf file from the spreadsheet regardless of the data type, but this is a different problem.

If the data in the spreadsheet cell is formatted as text data but the data is all numeric characters, DC_Excel2Array() is adding a decimal point and trailing zeros to the original data and putting that in the array as text data. It is the extra characters that are the problem.

I think the solution is a similar 'filter' added to DC_Excel2Array() which I have no doubt Roger will solve with great alacrity.

[GeneB]

Roger,
I wrote my users a 'quick fix' workaround if this is a problem for them, but there is still an exposure for me.
Any progress on this?
Thanks.

[GeneB]

Any thoughts on this?

[rdonnay]

Oops. I forgot about this. I'll work on this next.

[GeneB]

SkeletonOnKeyboard.jpg (5.92 KiB) Viewed 15999 times

[GeneB]

[img]s2.jpg[/img]