Solved

issue with ole2.get_char_property - urgent

Posted on 2004-10-17
3
1,377 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 350 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

624 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