How to select particular data from xls file

[rohit214]

Hi all
my problen is to select data from an xls file

i want to select data from column A &B

from row no11 to row no18

only Green colour data i want

thanks &regards

Rohit

[CELAMBARASAN]

Hi,

I'm assuming that u need selection on load script.

Based on that here is the code.

LOAD @1 as Field1, 
     @2 as Field2
FROM
Test_SBC - Copy.xls
(biff, no labels, table is [Reporting 1 - Dealer (Month)$], filters(
Remove(Row, Pos(Top, 10)),
Remove(Row, Pos(Top, 9)),
Remove(Row, Pos(Top, 8)),
Remove(Row, Pos(Top, 7)),
Remove(Row, Pos(Top, 6)),
Remove(Row, Pos(Top, 5)),
Remove(Row, Pos(Top, 4)),
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 2)),
Remove(Row, Pos(Top, 1)),
Remove(Row, Pos(Top, 35)),
Remove(Row, Pos(Top, 34)),
Remove(Row, Pos(Top, 33)),
Remove(Row, Pos(Top, 32)),
Remove(Row, Pos(Top, 31)),
Remove(Row, Pos(Top, 30)),
Remove(Row, Pos(Top, 29)),
Remove(Row, Pos(Top, 28)),
Remove(Row, Pos(Top, 27)),
Remove(Row, Pos(Top, 26)),
Remove(Row, Pos(Top, 25)),
Remove(Row, Pos(Top, 24)),
Remove(Row, Pos(Top, 23)),
Remove(Row, Pos(Top, 22)),
Remove(Row, Pos(Top, 21)),
Remove(Row, Pos(Top, 20)),
Remove(Row, Pos(Top, 19)),
Remove(Row, Pos(Top, 18)),
Remove(Row, Pos(Top, 17)),
Remove(Row, Pos(Top, 16)),
Remove(Row, Pos(Top, 15)),
Remove(Row, Pos(Top, 14)),
Remove(Row, Pos(Top, 13)),
Remove(Row, Pos(Top, 12)),
Remove(Row, Pos(Top, 11)),
Remove(Row, Pos(Top, 10)),
Remove(Row, Pos(Top, 9)),
));

Celambarasan

[rohit214]

hi Celambarasan

thanks for your reply

but the problem is my data is not constant it may varies all time means more no. of customeretc..

and second thing i want only data column A&B

thanks&regards

rohit

[rohit214]

please help me it is very urgent

any other idea

thanks

rohit

[#5]

hi Rohit,

For adding More customer you have to load again by filtering  as above Celam said,or for more customer u can concatenate xl file with new customer.

[CELAMBARASAN]

Hi,

    Can you explain me What is unique feature in your excel file for selection?

Celambarasan

[rohit214]

HI Ketan

Thanks for your reply

actuually senario is i have more than 100 file with the same fields but in every file customer no. varies

so the datails about customer is also varies .and i want to load all files at a time means i donn't want to reload

again and again.as celam suggest me is a hardcore script ...suppose if i am using hardcore script so i want only

greem cover part data only

Hope you understood my problem

thanks

rohit

[CELAMBARASAN]

Hi,

     I think its not possible because my understanding is qlkview doesn't know about the background colour it access only data from the excel file in table format.Based on my understanding we cann't implement based on the background color.

Celambarasan.

[rohit214]

Hi

It is not based on coloured background i made it for understanding means i want to fetch only thar data

that is not in my database.

thanlks

rohit

[vijay_iitkgp]

Hi Rohit,

If you want to get data from Excel Sheets that is not in your database then why dont you use where not Exists()condition while loading excelsheet.

Regards

Vijay