Merge and cumulate static tables

[Jodak]

What is the quickest and easiest way to merge several tables and cumulate their contents?

 

The hard way would be to go through all the rows, buffer and add each value, then write it to a new table.

 

Any other ideas?

tables.vwx

[Pat Stanford]

It looks like all of your data has been manually entered into Spreadsheet cells. So you can use a formula that references the other worksheet to display the data from other cells. Something like ='WS Name':A9

 

After you set up the first cell with the correct formula, Copy, select the overall range you want the WS reference to be used for and Paste. The cell reference will update, but the WS name will remain.

 

HTH

 

[Jodak]

Thank you, @Pat Stanford! That could work!

 

I cant figure out how to import a table (as template) from another file into the active document and create various duplicates. Any hints on that?

Tabels are no symbols, so CopySymbol() does not work and duplicating with duplicate only works on layers and not in the resource manager?

 

 

[Pat Stanford]

Worksheets are Resources, so you can Import them from a different file from the Resource Manager.

 

With the file you want to bring the WS into, open the RM. Navigate in the RM to the file that has the worksheet you want. Right Click on it and choose Import.

 

Navigate in the RM to the active file and find the WS you just imported. Right click on it and choose WS on Drawing. Or right click and Edit and then from the WS File menu choose WS on Drawing.

 

HTH

[Jodak]

On 9/7/2024 at 3:38 PM, Pat Stanford said:

Worksheets are Resources, so you can Import them from a different file from the Resource Manager.

 

With the file you want to bring the WS into, open the RM. Navigate in the RM to the file that has the worksheet you want. Right Click on it and choose Import.

 

Navigate in the RM to the active file and find the WS you just imported. Right click on it and choose WS on Drawing. Or right click and Edit and then from the WS File menu choose WS on Drawing.

 

HTH

I posted in vectorscript because i want to automate this 😜

 

[Pat Stanford]

Sorry, I try and read everthing that gets posted and missed that this was the VS Forum.

 

Take a look at the Vectorscript Function Reference and look at the four BuildResourceList commands and the ResList_ImportItem commands to script bringing resources into your file.

[Mirko Guhr]

Hallo @Jodak,

 

i think what you’re looking for is the syntax:

vs.ImportResourceToCurrentFile

I recently wrote a Marionette node for this: LINK

Maybe this will help you with the code structure.

If you have questions about integrating it into your script or if you get stuck, let me know 😉.

 

Best regards