Pivot Table

[hihosilvey]

Hello All,

 

I'm trying to create a cable pull sheet to put in my drawings.  My big dream is more of an Excel pivot table looking worksheet built from a database. Has anyone done this before? 

 

Thanks

 

Chad

[Pat Stanford]

Not going to happen in current versions of VW.

 

VW2021 will export to Excel, so you might be able to export and run the pivot table there.

 

In current versions of VW there is nothing similar to Pivot Tables (or lookups). Database rows can not have anything else special done to them.

[unearthed]

@Pat Stanford Does VW still not interwork (i.e. two-way live file editing) with Excel? Even just reading from Excel end would be okay.

[Pat Stanford]

VW can read and write XLSX files. But there is information on each end that will not translate and will end up as static text/numbers.

 

When you export to XLS you loose the live updating of information in databases (or worksheet field with criteria).

 

When you import from XLS you loose any functions that are not in the VW Worksheet (Pivot tables come to mind).

 

But at least you don't have to export as CSV and then import into the other program.