Working with opened excel file

Aspose.Cells Product Family
1

After opening an excel file , inside that file I want to copy paste the worksheet or range from another excel file.
Please advice

Regards
Deepak R

2

@deepak_ravi,

See the document with example code on how to copy worksheets b/w workbooks for your reference.

Also, see the document with sample code on how to copy ranges for your reference.

3

Hi Sahi

This is what I did , but my requirement is after opening an excel file , I will be having a button inside the sheet.
In that button click need to perform

Regards
Deepak R

4

@deepak_ravi,

You can add drawing shapes including buttons on the sheet via Aspose.Cells APIs. But for the shape you need to add some vba codes/macros by yourselves. Aspose.Cells does allow you add vba codes for the controls, see the document on how to assign macro or vba code for a button control for your reference. Here, I cannot help you much on how to write specific vba codes or macros to copy worksheets, so you need to research on relevant vba codes forums for help.