Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, in my excel there is huge amount of data, in that i want to select only few rows and upload it in the QV, i tried uploading the excel but i have to deleted all the others rows by using delete function and is there any way that i upload only specific range in the excel, any help will be appreciated
Hi,
Can you please clarify more what exactly you need.
If you want rows on certain condition then you can use where clause .
Regards
Vijay
Actually in my sheet i have data till 233 rows and i need to upload only last 10 rows, if i delete rows the code is becoming vary large, so what i want is instit of deleting all the rows i want to select particular range, example (D242:I246)
Hi Mohammed,
Put a flag against those line items as "Y" in excel and give a condition in your script to pick those lines alone.
Regards,
Raghav
Thanks you ur reply, that a good idea, but i have many charts so each data set i have insert flag that will be a problem,