Script to Copy Data from Existing Excel Worksheet into New Worksheet (Auditing Purposes)

Packages
,
1

Hello,

I am fairly new to dynamo. I was just wondering if there was a node/script that can copy data from a worksheet in excel into a new worksheet & rename it for editing/auditing purposes?

2

Hi @french_designs

Yes it is possible you can read data from worksheet in excel and copy it to new worksheet. For renaming data before writing you can rename your data in Dynamo and feed the values in “Excel.WriteToFile” node.

Pasted image1539Ă—671 181 KB

3

Thanks @Kulkul. Would it be possible to extract the data location (row,column) from the existing and transfer it to the exact same location on the new worksheet?

4

@french_designs Yes its possible. Just few minutes i will post solution soon.

5

@french_designs Here you go. There are nodes from @Konrad_K_Sobon’s Bumble Bee package to read excel rows and columns you can use that nodes.

Pasted image1575Ă—745 59.1 KB

2 Likes
6

Great, thank you for this. Much appreciated.

7

Easier to use an Excel macro ?

Sub CopySheet1()
    ThisWorkbook.Sheets("Sheet1").Copy Before:=Sheets(1)
    End Sub