Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

issue with ole2.get_char_property - urgent

Posted on 2004-10-17
3
Medium Priority
?
1,410 Views
Last Modified: 2008-02-01
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
Comment
Question by:smena
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 12338739
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
 

Author Comment

by:smena
ID: 12342708
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
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1050 total points
ID: 12346875
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question