Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1444
  • Last Modified:

issue with ole2.get_char_property - urgent

I'm using ole2.get_char_property function for loading data from excel to oracle.
In spreadsheet some cell has a numeric values while they still needs to be treated as character for Oracle varchar2 data type.
It seems like this function takes the first byte only for numeric value????
example:
cell values : 12345 -->  1
                  23456 --> 2

Since the same column can have character and numeric value how can I deal with this issue?
0
smena
Asked:
smena
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
The only thing I've been able to locate is talking about the cells property being set to custom instead of text.  Try resetting the cells property to 'text'.
0
 
smenaAuthor Commented:
slightwv.

that works... thank you. I was abke to find it on metalink as well.
Thought, I founf another problem where value does not fit the cell and it's not reading correctly.
For instance, if cell width is not bif enough, excel displays it as #### instead of 05-May-04.
Do you know how take take care of this?
1
 
slightwv (䄆 Netminder) Commented:
Off the top of my head, I can't even attempt to guess at why this is happening.

It's a little surprising that even though the cell width isn't big enough for display that the cell contents can't be read.  That sounds like it might be a bug of some type.

I've never played with the ole2 functions so I'm not able to provide 100% accurate advice.  I'm just thinking out loud here:  Is there a way to manipulate the worksheet using ole2?  I'm thinking that there might be a way to set the column width after you open it.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now