Hi All,
I Have a Excel file with sheet 1 containing columns A,B,C,D.............Y,Z
I want to read data of columns C,E,W,X from excel file. I dont want remaining data.
I tried get worksheet range as collection, but its working only for single column and for multiple its taking sequence as I provide start and end cells.
In my requirement I need random columns from excel, for this its throwing an error " Could not execute code stage because exception thrown by code stage: This action won't work on multiple selections."
Can some one say how to read excel file of required columns.
Note: I know we can use OLEDB connection with Queries. But I want to check with Excel VBO or any code stage.
Thanks in advance
------------------------------
vinod chinthakindi
------------------------------
