How to copy existing excel sheet and crate another sheet in same excel work book via LINQ Query
I have data in Shee1 and want to copy the same data sheet 2 via linq Query
How to copy existing excel sheet and crate another sheet in same excel work book via LINQ Query
I have data in Shee1 and want to copy the same data sheet 2 via linq Query
LINQ query is used to modify/filter data.
You should be using Excel Process Scope and Copy/Paste Range activity for this.
Thanks,
Ashok ![]()
through Excel Process i can do it…but her i want to create 2 sheets where in i want to avoid using more UiPath activities… i want to code with linq query and write the data
LINQ doesn’t create sheets in Excel files. LINQ is a query language for querying data.
Why wouldn’t you want to use activities? It’s what they’re for. They’re simple and efficient. You’d be done already. Just saying…
if you can want to make it complex and wants to stick to code then
you can use vba code to to perform this task because as other said LINQ is used for querying the data source and structures
@ashokkarale is right, your requirement (or description of the requirement) is simply wrong, you can’t use LINQ to create sheet in excel file.
Cheers
That’s strange requirement I would say. Let’s wait for other experts opinion.