I have a spreadsheet which I need to load into Oracle on a regular basis.
The user has colour coded some cells and I need to import this fill colour as well as the cells text
I don't see any way to do this but hope to be proven wrong
Question
Is it possible to read the cell fill colour when reading data from an Excel spreadsheet
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi
I don't think that is currently possible.
A workaround might be to introduce a new column in your Excel-sheet where the cell colour is written out in text. You might be able to get some inspiration here.
David
+59- Safer
No, this isn't currently possible. There is already an enhancement request (PR#47193) so I have added your question to that so you are informed if/when it is implemented.