Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to select rows from a xls ou xlsx file

AlibuneJun 13 2018 — edited Jun 13 2018

Hi everyone!

I'm working with .xls data and are using Anton Scheffer plugin, it was working just fine, i got that to select different tabs just needed to change the number on the collection number, but now i have a new problem, i have a .xlsx like this:

exemplo.png

I don't need the first 5 rows, how can i define which row i want to insert from the collection? erase the rows or convert the .xlsx to .csv is not an option.

Can anybody help me?

This post has been answered by Alibune on Jun 13 2018
Jump to Answer

Comments

John JB Brock-Oracle

This would be a question for the Visual Builder team. This forum is about JET coding itself.
Please post your question at https://community.oracle.com/customerconnect/categories/oci-visual-builder

Khavya_Karthikeyan-Oracle

Hi @user-tdavg ,

Did you get a solution to this. I have a similar requirement. Was unable to find it.

Thanks

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 11 2018
Added on Jun 13 2018
1 comment
182 views